Master sheet in Excel

jasonakinney

New Member
Joined
Sep 4, 2007
Messages
1
Hello all,

Is there a way (through Macro or other) to input fields on a master sheet - i.e. worksheet a, and have the contents also populate individual corresponding sub-sheets i.e. worksheet b, c and d?

Thanks
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
Right click on the sheet tab and select "Select all Sheets". Now what ever is entered will be there on all selected sheets. After finishing your job, remember to "Ungroup sheets" as said above
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Hi Jason,

Can you give us a bit more background on this please? The answer generally is that, yes you can do it, but exactly how to tackle it will depend on your needs.

For example, if the sub-sheets will only be used for viewing selected data but not for further data entry, you could either (a) filter the data on the main sheet, copying to each subsheet in turn and pasting the results, (b) create a pivot table using your main data sheet as the source table, and then filter the layout for each grouping that you need.

So, a bit of detail please (layout and what you need to do), and we can go from there.

Denis
 

Watch MrExcel Video

Forum statistics

Threads
1,123,317
Messages
5,600,912
Members
414,415
Latest member
joshuaba

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