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