By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,897 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

HElp needed for a small Excel macro

P: 1
I wanted to copy data from cell sheet 1 A1 to B24,
paste it into two sheets in 24 columns As in one sheet (sheet 2), Bs in another
sheet (sheet 3)
and continue the next 24 (A25 to B48)
paste in the same sheets under row A1 to A24 (sheet 2), and under B1 to B24
and continue till all the data in sheet 1 is done.
Thanks

I am a newbie, so Please Help.
Apr 25 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 5K+
P: 8,434
I wanted to copy data from cell sheet 1 A1 to B24,
paste it into two sheets in 24 columns As in one sheet (sheet 2), Bs in another
sheet (sheet 3)
and continue the next 24 (A25 to B48)
paste in the same sheets under row A1 to A24 (sheet 2), and under B1 to B24
and continue till all the data in sheet 1 is done.
The easiest way to get going on something like this in Excel is to start recording a macro, then do the operation "manually". Then, when you stop recording, you have all the VBA code there in the recorded macro, so you can play with it.

Depending on the situation, this may produce exactly what you need with no further work required. But at the very least, it will provide the building blocks for your macro.
Apr 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.