How to link worksheets so editing one will edit others automatica

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to link worksheets within a workbook so that a line inserted in sheet
one automatically gets inserted in all the other sheets. This facility was
available in Lotus but I havent yet found how to do it in excel. Any help
greatly appreciated. (Excell 2000 version)
 
jax said:
I need to link worksheets within a workbook so that a line inserted in sheet
one automatically gets inserted in all the other sheets. This facility was
available in Lotus but I havent yet found how to do it in excel. Any help
greatly appreciated. (Excell 2000 version)
Click to expand...



Just hold down the shift key while you select the sheet tabs that you
want to include (the selected sheet tabs will change colour) then do
your changes .

when you have finished, key a non selected tab to stop the grouping.


There are several other ways of doing this, via VBA etc but you'll need
to play around with it first to suit your methods
 
You must log in or register to reply here.

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

Similar Threads

Permanently link Col A edits, inc 'insert row' in multiple workshe 2
Can't Edit Worksheet Comments 1
I want to copy rows with values >0 to another worksheet automatica 4
Permanently linking Column A in many worksheets 3
Automatic Cell Copy to other worksheets 1
dynamic data copying between worksheets 0
Linking data from one worksheet to another... 2
Auto update worksheets 2

Back
Top