Hi,
I have one worksheet named "Bid Template". I'm trying to write a macro that makes a copy of this worksheet, puts the tab at the end of all my other worksheets within the same workbook and renames it "Bid Scrubbed".
Then I want the same macro to insert 4 columns starting at column DV, shifting this column to the right. I want to name the columns "Test 1", "Test 2", "Test 3", "Final Test".
Then I want to paste the entire sheet as Paste Special Values.
Is this a difficult code to write? Can anyone help me out? When I try to record a macro, it breaks for some reason.
Thanks!
I have one worksheet named "Bid Template". I'm trying to write a macro that makes a copy of this worksheet, puts the tab at the end of all my other worksheets within the same workbook and renames it "Bid Scrubbed".
Then I want the same macro to insert 4 columns starting at column DV, shifting this column to the right. I want to name the columns "Test 1", "Test 2", "Test 3", "Final Test".
Then I want to paste the entire sheet as Paste Special Values.
Is this a difficult code to write? Can anyone help me out? When I try to record a macro, it breaks for some reason.
Thanks!