Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating graphs in Excel using a macro Angela R Excel Discussion (Misc queries) 2 July 3rd 07 02:19 PM
Regarding auto updating Macro sumi1 Excel Discussion (Misc queries) 0 July 3rd 07 07:58 AM
Updating copy of Macro workbook... have_a_cup Excel Discussion (Misc queries) 2 June 29th 06 03:13 PM
Need help updating my macro to include a 2nd worksheet. billrl34 Excel Worksheet Functions 0 December 9th 05 08:06 PM
Have a Macro run after updating cells sip8316 Excel Discussion (Misc queries) 1 June 2nd 05 07:54 PM


All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"