I have to copy / paste and change a few thousand items and i want to get a macro to do this. I have recorded what i am doing 10 times as an example. I am increasing the value by one when i make the replacement.
I need a macro to paste five rows from A to U and then change the value by one.
Thank you in advance
Please Login or Register to view this content.
Do you have a sample file that you can upload? One that you use with the code above?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Example - Copy.xlsmIf you look at the Page Two Sheet you will see that the first five rows are links to the Page One Sheet Row 1
I then copied the first five rows and pasted them to row 6 to 10. I then change the cell reference by using the replace option example ='Page One'!$A$1 becomes ='Page One'!$A$2 and so forth.
What im trying to do is copy the first five rows the paste the with the cell reference changed a few hundred times
Do you need the cell references in page 2, or will just the values suffice?
I need the cell references as the values on page one will change as i am making a template.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks