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

andycreber

Board Regular
Joined
May 20, 2010
Messages
65
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
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,809
Members
416,983
Latest member
LessThanAverageUser

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
Top