VBA Code to create sheet and then copy another sheet and go to the new copied sheet and paste the data

[andycreber]

Hi there,

I am fairly new to VBA and need help with the following:

summary - I need a VBA Code to create sheet from a cell value and then copy data from another sheet and go to the new copied sheet and paste the data

detail - I have a sheet called Survey and when a user types a number into Cell "J4" ie '213', I want to run a macro to create a new sheet and rename the new sheet with what the value is in Sheet "Survey" Cell "J4" ie '213' then after that, I want to go to another sheet called Raw_Data and copy all the data onto the new sheet "213" and paste the data into the newly named sheet and then hide the newly created sheet.

I will be using this workbook as a master template so each time a user types in their number, it will create a new sheet of data.

I have tried all sorts and cannot get anything to work.............

I appreciate your time in helping me with this.

Thanks

 

[andycreber]

please ignore request