I need to pause macro so user can select sheet in which to copy current data into

[Liberteric]

I need to write a macro that copies everything in current sheet, (variable sheet one), pauses for user to select new sheet tab, copy the data to the selected sheet, then value the data in (variable sheet on).

 

[dermie_72]

or you could have 2 macros. 1 that does the first part, the user selects the sheet, and then you run the second part.

 

[Liberteric]

I thought of that but the macro needs to copy the sheet ie:Aug to another sheet ie:Sep, then value out the original sheet ie:Aug and return to the newly updated sheet ie:Sep.