Worksheet inheriting

kristinnj

Board Regular
Joined
Sep 14, 2004
Messages
91
Hello everybody

Heres my problem.
I have a document which has many worsheets which are basically all the same single form. Each one has a different head and and a different name of course. Now what I need to do is make the same changes to each and every worksheet as certain parts of the form have become outdated. Its gonna take a lot of time if I need to go to every worksheet and delete what i need to delete and add what I need to add so I was wondering if there was some "magical" way to do this, as I have so often found out via this message board.

Thanks
Kristinn J
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Yes, you select all the sheets. Right click on one of the sheet tabs and click select all.

Now every change you make to one sheet will happen to them all.

Remember to right click and ungroup sheets once you have finished.
 
Upvote 0

Forum statistics

Threads
1,215,839
Messages
6,127,196
Members
449,368
Latest member
JayHo

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