I want to copy formula & formatting from say Row 3, Clm C to R to the next row a number of times designated by the value populated into a cell (say B1). ie if B1=3 i want to copy Row 3 Clm C-R 3 times to Row4,5 & 6.
Note i want the copy to happen automatically when the detail is entered into cell B2
See attached file.
Any Ideas would be great
Thanks
So the first time you enter data into B1 and then B2, the macro will insert rows as per the value in B1.
What if you want to enter another value like B2, where will that be entered? Should the macro insert rows when you enter the value too or should the macro just run once?
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]
Also,
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread. http://www.excelforum.com/excel-2007...-that-row.html
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks