View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Newbee Newbee is offline
external usenet poster
 
Posts: 33
Default Macro updating a new column each day

I have a macro that run's daily and gives me the output I want, However I
would like for it to autopopulate the correct line of information.
For example.
The updated numbers are coming from a pivot table are the raw numbers. I am
copying and pasting them to the correct column and day. So tommorrow I will
post 8/1 infomation. What would be the code to get it auto copy and paste to
the correct day?

7/30 7/31 8/1
Data 1 123 111
Data 2 456 222
Data 3 789 333