Copy column to Another sheet...incrementally increasing the column every run of the vba

C

chiswickbridge

Board Regular
Joined
Feb 2, 2013
Messages
127
Hi,

I have dynamic data on one sheet in a Column E2 to E101. This is updated on a daily basis.

Need a VBA to copy this column and save this data for future use, on a different sheet, Starting Column is AA.

AA1 will contain the date and AA2 to AA101 will have the data correspondingly.

Next day the saved data will use column AB and so forth...

Thank you in advance...
 
Sort by date Sort by votes

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
You must log in or register to reply here.

Similar threads

I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
199
Insurance Dave
I
P
  • Question
Automating copying of columns within same sheet in excel using VBA.
Replies
1
Views
100
MountainFog
M
B
  • Question
Excel 365 Compare Date & Copy Cell Data for Data Base
2 3 4
Replies
33
Views
738
skillilea
S
Kaz09
  • Question
Copy rows of data from multiple worksheets to based on column equalling YES
Replies
0
Views
99
Kaz09
Kaz09
K
  • Solved
Update to existing Move data macro
2
Replies
11
Views
259
Alex Blakenburg
A

Forum statistics

Threads
1,214,553
Messages
6,120,179
Members
448,948
Latest member
spamiki

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top