Excel Workbooks

[k8truscott]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)

I use excel to make a TON of checklists - but they are all based on ONE initial list.

I want to create a workbook, where the first tab is the MASTER list, and then each of the subsequent pages is based off of that one. I want the "A" column to update on all worksheets, when I update the MASTER sheet, and then I want to be able to edit each worksheet independantly from there - with the "A" column never changing.

Can that be done?

Kate

 

[JE McGimpsey]

I use excel to make a TON of checklists - but they are all based on ONE
initial list.

I want to create a workbook, where the first tab is the MASTER list, and then
each of the subsequent pages is based off of that one. I want the "A" column
to update on all worksheets, when I update the MASTER sheet, and then I want
to be able to edit each worksheet independantly from there - with the "A"
column never changing.

I'm not sure you've given enough information - and I'll admit that I'm
make a an assumption about what you mean by making column A "never
changing" in the list sheets yet having column A "update on all
worksheets" when the MASTER sheet changes - but this would seem to meet
your criteria:

1) Create your workbook with two worksheets. Name the first "MASTER"
2) On the second worksheet (say "Template"), in cell A1, enter

=IF(MASTER!A1<>"", MASTER!A1, "")

3) Copy cell A1 down as far as required
4) Format/enter other "permanent" information as desired.
5) Copy "Template" to a new sheet (e.g., by dragging) for a new list
6) Hide "Template" when not needed.