Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro - copy a range and paste it in a new sheet 12 times
Hi
How to do a macro that copy a range form sheet1 and paste it into sheet2 12 times changing each time a one factor - in one column is a month, so each time when macro paste a range, should change a month by 1 Example sheet1 col col 1 2 month descrip 1 AAA so macro should copy it all, paste in a new spreadhseet, say Sheet2, copy it again nd paste in again in sheet2, below the pasted values and change the month to 2 it should do it 12 times. Any ideas? Thanks Eva |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy range in macro using paste special values | Excel Discussion (Misc queries) | |||
macro to copy a value multiple times depending on value in adj | Excel Worksheet Functions | |||
Copy and Paste Macro for front totals sheet | Excel Discussion (Misc queries) | |||
Macro to copy, paste in a range and then delete | Excel Discussion (Misc queries) | |||
Copy/Paste using a macro that identifies occuoied range | Setting up and Configuration of Excel |