Hi all,
I have created a macro to copy the template sheet and name the sheet based on the last sheet, so sheet names are 1,2,3 etc
This works fine but i also want to add to the macro to copy this formula =IF('1'!A$3="","",'1'!A$3) to the next row but to reference the new worksheet so it would be =IF('2'!A$3="","",'2'!A$3). Does anyone know how I can do this?
Please Login or Register to view this content.
Thanks,
Last edited by arlu1201; 07-19-2012 at 06:26 AM. Reason: Put code tags in future.
Do you have a sample file that you can upload?
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks