Announcement

Collapse
No announcement yet.

Macro to Pull Specific Data Based on tomorrow's date.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Re: Macro to Pull Specific Data Based on tomorrow's date.

    I am not understanding what this means. Can you clarify with an example?.

    Is there a way when the macro is running if it finds a match in Column C
    Alan

    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

    If someone has helped you, say "thank you" by clicking on the Like Button.

    Comment


    • #17
      Re: Macro to Pull Specific Data Based on tomorrow's date.

      [ATTACH]72725

      It's an add on from the macro you have already helped me with. Everything would stay the same except I would like to eliminate duplicate entries.

      In regards to column C (CP Code) in the data tab. When there is a same name it would then add column G (volume) volumes together to then create only one line in the UP tab.

      Example in the attachment:

      As before its looking for day ahead information and only Sell's. Everything you have already helped me with and created.

      But now:

      It would see in Column C a match with the name ABC and then add the volumes form Column G. So in this case the Sell volume total would be 200.

      I hope that makes sense.

      Also, this macro you have been helping me with can be utilized in ten of my spreadsheets. I have another twenty spreadsheets that would require a new macro. Would I need to start a new thread or just continue with this one.

      Thanks
      Attached Files

      Comment


      • #18
        Re: Macro to Pull Specific Data Based on tomorrow's date.

        Will work on this issue. You should start a new thread for each new issue. In this manner, you will have more people looking at it. When a thread gets long, it is rarely looked at by anyone other than the OP and the responder. You want to have as many participants look at your issue as possible as not all participants are active all the time and there are 24 times zones.
        Alan

        Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
        FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

        If someone has helped you, say "thank you" by clicking on the Like Button.

        Comment


        • #19


          Re: Macro to Pull Specific Data Based on tomorrow's date.

          A quick idea. Once you have the data moved to UP as we did earlier. Sort them by the CP and then use the sub totals function to aggregate the sell amounts. This would be faster and more efficient in my mind. No VBA required, however, these few steps could be automated. You could try to write the code for this by doing a Macro recording and see if that works. If you need help amending the code, then post the recorded code in a new thread and ask for assistance.
          Alan

          Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
          FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

          If someone has helped you, say "thank you" by clicking on the Like Button.

          Comment

          Working...
          X