• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Exercise

A

AlbertoPA

New Member
I would like to get some help on coding for the following exercise:

The goal of this task is to find a way via Macro / VBA to copy the input date from columns H-N into the output columns B-F automatically. However, the input data comes in on a daily basis via web query. In field N2 you are able to simulate new dates to test your code.

The essential problem is that the numbers of the last 60 days may still change at any time - but the data concerning t-61 days is fixed and should not change anymore.

I get stuck with the second paragraph

Thank you very much!
 

Attachments

Would love to help but don't understand your issue. I suspect that is one reason no one has assisted yet. I don't get what you mean by
The essential problem is that the numbers of the last 60 days may still change at any time - but the data concerning t-61 days is fixed and should not change anymore.
Click to expand...

Are you wanting to use the date in column A, find the corresponding date in column H, and then copy that information (cols H-N) to cols B-F? However, if the date in column A is <= t-61 days, then don't copy?
 
You must log in or register to reply here.
Back
Top