Mapping?

jimmywanna

Board Regular
Joined
Mar 18, 2002
Messages
182
Hello my peers,
I received some help yesterday for a macro which i am intending to use to save me an awful amount of time.

scenario:
I have a sheet which i wish to paste into about 120 workbooks.
The sheet will be the new sheet 1.
I want to create a button on the 120 workbooks that when pressed runs a macro to make some changes to the it's presentation.
After that i need the macro to look at the other workbook (which will be open) copy the sheet and move it to the front of the workbook which has had amenments.
I have tried myself but the macro records the name of the workbook. All 120 have very different names.
So far the coding (post changes) looks like this:

Sub Button1_Click()
'
' Button1_Click Macro
' Macro recorded 02/11/2005 by GibsonJa
'

Windows("Book1").Activate
Sheets("Sheet1").Select

Dim wb As Workbook
Set wb = ThisWorkbook
Sheets("Mapping").Copy Before:=wb.Sheets(1)

End Sub

it works right to the point of Sheets("Mapping").Copy.........

I am unaware of the term "mapping" and i think this is the problem, any help would be really great as this could save me hours.

thanks again

jim
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Have you renamed any of your worksheets. When the macro was recorded you had a worksheet called mapping (which may still be there but just hidden). The "Mapping" referes to the name of the sheet and the script moves this sheet to become the first sheet in the workbook.

Any help?

James
 
Upvote 0

Forum statistics

Threads
1,224,317
Messages
6,177,850
Members
452,810
Latest member
jeffrey0409

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top