Carry Line insertion to several Sheets.

  • Thread starter Thread starter Jean Luc
  • Start date Start date
J

Jean Luc

Hello,
I am looking for help on the following :
I am working on a file where several sheets need to have
common information on columns A and B.
Example :
A B
Peter Marketing
Paul Services
Steve Admin
etc..
This can be done by
1. entering these information on sheet1
2. using "=Sheet1!A$1"....on the others

Problem : if we need to insert a new line (say
insert "Kim Sales" between Paul and Steve) then this new
line does not show up in other sheets. The only
consequence of the insertion is that line 3 on other
sheets now relates to line 4 of sheet 1 (which is normal)

Is it possible to have columns that would be common to
several sheets, or a means so that any insertion in sheet1
automaticaly show up in other sheets refereing to cells of
these columns
(In my example, the new line 3 "Kim Sales" in Sheet1,
between Paul and Steve would automaticaly show up in other
sheets).

Can someone help on this ?
Many thanks and best regards

Jean Luc
 
You might consider using "group mode" to enter data common to several
worksheets. Then you wouldn't even need the formulas to carry over changes.
With the first sheet active hold Shift down and click the tab of the last
worksheet (you may have to scroll the sheet tabs to see the last sheet's
tab).

It should say "[Group]" in the worksheet caption. Now any change you make
on one sheet is also made on all the others. This includes inserting rows,
entering data, formatting cells, etc. Be sure to exit group mode when
you're done making common changes. This can be done by clicking the tab of
a worksheet not in the group. Or by right clicking a tab and picking
"Ungroup sheets".
 
Back
Top