insert lines

A

abunge

I am trying to do the following:
If I add a line in Sheet 1, I want the same line with the same infos
added automatically in Sheet 2.
Is there any way to do that?

Thanks for advice!
Alex
 
A

Ardus Petus

Group Sheet1 and Sheet2:
With Ctrl pressed, click on Sheet1 tab, then Sheet2 tab

All modifications will appear in all sheets of the group

HTH
 
K

KellTainer

Hi

I assume when u mean add lines u mean putting in cell entries?

You can do it by grouping the worksheets when u enter data.

Click on the sheet tab, like say Sheet 1, den ctrl click on other
Sheets like Sheet 2 to group them. Alternatively, you can use shift to
select a range of worksheets on the sheet tab.

Then, enter any data in Sheet 1, and the change will reflect on all
sheets grouped. To upgroup them, just right click on the sheet tab and
press ungroup.

Drawing like lines or shapes cannot be added to multiple sheets
automatically, so you have to do it manually.

^^
 
A

abunge

Great, thanks a lot! I am trying to handle loads of data on different
sheets, and this makes adding changes much easier. I knew there was
some sort of easy solution...
Thanks
Alex
 
Top