Question Locked

Excel 2003 VBA Copy and Paste where date equals in other worksheet

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm very new to VBA and barely understand how it flows. Here is what I'm trying to do. I post new data based on a current date and it runs through a series of formulas to get the output in C43:C46. However the next day I need to take the values in C43:C46 and post them in my formulas above (trying to avoid my copy/paste errors plus simplify the daily process). I can handle the calling of the current days data the next day with a vlookup calling another worksheet. I need a macro to copy and paste the value from C43:C46 to the other worksheet where the date equals the date.
Worksheet1 Called (Daily)
C2(this is the current date)
C43
C44
C45
C46

Worksheet2 Called (Prior Day)
columns: B C D E F
Dates Paste(C43) P(C44) P(C45) P(C46)

Each day it will look at (Daily)C2 compared to (Prior Day)Column B and copy and paste the values.

Hopefully this makes sense. If not let me know if you have any questions or if there is an easier way.

Thanks,
jason

1 reply

This discussion is closed to new replies.