Macro that append output in next column at every run

Microsoft Office excel 2003
January 12, 2012 at 09:26:16
Specs: Windows XP SP 2, C2D/2GB
Hi,
I have a macro that gives output in a column. I have to run that macro at every hour, I want all 24 hrs output in a file by appending in column every time that macro run like:

00:00 01:00 02:00 03:00 04:00.......... 23:00
output1 output2 output3 output4 output5 output24
output1 output2 output3 output4 output5 output24

Please help...


See More: Macro that append output in next column at every run

Report •

#1
January 12, 2012 at 12:24:44
It would probably help if we saw the macro you are using.

Please click on the blue line at the end of this post and read the instructions on how to post a macro in this forum.

Thanks

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 15, 2012 at 00:31:56
Every hour i am copying a data from a file to a column in excel sheet and want to append to next blank column at next run.

Report •

#3
January 15, 2012 at 08:38:00
I know what you want to do.

I asked for a copy of the code that you are using to see if it can be easily modified.

Depending on how the data is currently being copied, it may be a simple change to a single line or it might be considerably more complicated.

Without seeing your code, or at least the section of code that writes the data to sheet, all we would be doing is guessing if we offered any suggestions.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question