Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy range in macro using paste special values Jeff Excel Discussion (Misc queries) 2 August 20th 07 08:12 PM
macro to copy a value multiple times depending on value in adj dribler2 Excel Worksheet Functions 0 January 10th 07 01:48 AM
Copy and Paste Macro for front totals sheet [email protected] Excel Discussion (Misc queries) 0 May 5th 06 05:12 PM
Macro to copy, paste in a range and then delete Garry Excel Discussion (Misc queries) 0 March 23rd 06 08:37 PM
Copy/Paste using a macro that identifies occuoied range JorgeAE Setting up and Configuration of Excel 1 March 13th 06 01:51 AM


All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"