copy sheet

milking

New Member
Joined
May 20, 2011
Messages
15
Hello, I’m new to vba and i have a problem i would really be grateful for your help<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
Sheet1 has a range from A7-A32, whit names of the sheets names.<o:p></o:p>
range B7-B32 has values of cells that need to be changed in each created sheet at range C7<o:p></o:p>
<o:p></o:p>
Sheet2 is the template sheet that needs to be copied. if there are any values in b7-b32 in sheet1.<o:p></o:p>
<o:p></o:p>
i would really be grateful for all your help, i even bought excel for dummies , and still can't get the button function to work.<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
<o:p>please help</o:p>
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,224,586
Messages
6,179,718
Members
452,939
Latest member
WCrawford

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