Macro to update data from Exercise to Master File as per specified sheet and range

[Bimmy]

Hello,

I have an Exercise File and a Master File. Both files are stored in same folder.

Master file has 30 sheets named as 1,2,3 and so on and will remain closed.

The activities will be performed in Exercise File on sheet1 Range A3:G500 and J2:L2000,
and should be copied to Range B5:H600 and L10:N3000 of the Master File.

I'm looking for a code with a button. Clicking on the button will give the user a prompt
asking them to enter the sheet name, clicking ok will update the data to the specified
sheet and range. Clicking Ok should also give a reminder message "Don't forget to update
Mean Time" for 5 seconds.

 

[vletm]

@Bimmy
You could get answer quicker,
if You could upload (sample) files here.

 

[Bimmy]

Hello,

Have uploaded both files with explanation.

 

[vletm]

@Bimmy
Use this file instead of Your.
Save it to same folder.
For testing ...

 

[Bimmy]

Hello vletm,

Some of the cells will have comments in them. Can you tweak the code so that the code will paste comments also.

 

[vletm]

@Bimmy - for testing
... comments too

 

[Bimmy]

vletm... Perfect