Is it possible to create a master Worksheet


K

Kim

I have a excel sheet that I use for all 60 different people. Each prson has
their own workbook and each workbook contains 12 tabs with this excel sheet.
If I need to add columns or rows to the sheet it takes forever because I have
to go into all 60 workbooks and make the changes individually on all the 12
tabs in each workbook.

I am wondering if it is possible to create one master worksheet that I could
make additions or deletions to and have it apply the changes to all the other
worksheets without me having to go into everyone of them on an individual
basis to do so. Does that make sense? Any guidance you could give me would
be greatly appreciated.
 
Ad

Advertisements

L

Luke M

Simply setup all the other workbooks to link directly to your Master workbook.

Step by step:
1. Open master workbook & coworker's workbook.
2. In A1, start typing "="
3. while still typing formula, select your master workbook, master sheet,
and select cell A1
4. Formula should now look something like:
=['Book1.xls]Sheet1'!A1
5. Copy this formula over entire sheet (or as large as you feel is necessary)
6. Save & close.

Then, copy this linked sheet from the one coworkers workbook to all the rest
of the workbooks.
 
J

JCS

Kim,

If I understand your requirement, all you need to do is to:
1. Select all of the tabs by holding down the Shift key and then selecting
each tab.
2. Make you changes

This should do it.

John
 
J

JCS

Kim,

In my last reply, I forgot to mention that you only have to make changes to
any one of the spreadsheets that have been selected and the change will be
made to the others.

John
 
Ad

Advertisements

K

Kim

I have several different files that all use the same spreadsheet. The data
that is entered into each one is different but the formating is the sames and
the required data being entered is the same. I just want to be able to
change the formating on one spread and have the changes made on all of the
other spreadsheets without me having to do it one sheet at a time. I also
don't want the data that has already been entered to change either. Does
that make sense.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top