Help with duplicate worksheet

  • Thread starter Thread starter kit-e
  • Start date Start date
K

kit-e

Hello,
I am having trouble with duplication of a worksheet. What
I need to do is use the first sheet as a 'master' and each
duplicate as a 'slave', updating the master as often as I
choose and each slave similtaniously updating as well. I
have been using the formula =if(isblank(sheet1!
rc),"",sheet1!rc), and this is working just fine. Now I
have a problem with my slave sheets. Cells containing
overflowing text, are not showing the same on the slaves.
They show only the width of the cell, and this causes me a
great problem. I have scoured the help files but can't
find anything I understand.
Also, how do I duplicate any text boxes within the master
sheet, and text contained within these text boxes.

Appreciate any input.

Regards
Kit-e
 
Not sure I follow your problem entirely, but here is a suggestion. Create
the master sheet first, and format it as you wish. Then copy it to create
each subsidiary worksheet; right-click on the sheet name, choose Move or
Copy, and be sure to check "Make a copy." Now, each subsidiary sheet has the
same formatting as the master. This procedure also duplicates the text boxes
of the master.

Go ahead and enter the data in the subsidiary sheets. In the master, each
cell requires a formula to add (or subtract, multiply, divide) the
comparable cells in the others. Click on, say, B7 in master; type =, then
click on each B7 cell in the sheets to be summarized, placing a + (or -, *,
or /)between each click but not at the end of the formula.
 
Thanks for the reply Richard, I appreciate your effort.
Yes this helps me with my copy text/numbers problem. I am
trying to get my different worksheets to automatically
change when the master sheet is changed. Things like
headings, text, and numbers set with formulas for things
like tax or percentages, would change similtaniously when
the 1st sheet is changed.
I have pricelists that I must maintain, and it will save
me many hours updating each sheet separately, if I can
link them all together, but having each with its own
particular mathematical function.
You have helped me with the copy function, how can I now
link them together easily, or was I on the right track
before?
Regards
Kit-e
 
Back
Top