Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeating Reformatting Macro
Project just got tossed to me with little or no IT backup. Need to
write a macro that will take data from columns "A" and "B" (3000+ rows worth), 52 rows at a time and paste it into rows "D" and "E" leaving "C" empty. This needs to be repeated so that the next 52 rows of data skip "F: and get pasted into "G" and "H". The values in A1:B1 also need to be placed in cells at the top of these pasted columns. Lastly, I need it to know when to stop automatically. If someone could point me towards examples that do any or all parts of this, I would greatly appreciate it. THANKS! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeating macro | Excel Discussion (Misc queries) | |||
repeating a macro | Excel Discussion (Misc queries) | |||
Macro for reformatting cells | Excel Worksheet Functions | |||
Repeating Macro | Excel Discussion (Misc queries) | |||
Repeating macro | Excel Programming |