Copying a column

[Don]

I need to be able to copy a column (Column A) from
Worksheet 1 through several different worksheets. My
problem has been trying to keep it so that whenever Column
A is edited it will reflect those changes on the other
worksheets. If anyone could direct me as to how this
almost impossible task can be done I would be forever
indebted to them.

Don VanMeter

 

[Frank Kabel]

Hi
you have to enter links on these other sheets. Try the following:
- first group the other sheets (hold down th SHIFT key and select the
tab names)
- in A1 enter the following formula
='sheet1'!A1
copy this formula for the other cells

 

[Don]

While it this was helpful, this procedure doesn't allow me
to add or delete certain rows. I'm looking to be able to
completely edit Column A in Worksheet 1 and have that
information carry over to all the other Worksheets. If
you have any other suggestions, I'm all ears.

Thanks for your assistance,

Don VanMeter

 

[Frank Kabel]

Hi
you could try using a formula like
=INDIRECT("'sheet1'!A1")