Copying a column

  • Thread starter Thread starter Don
  • Start date Start date
D

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
 
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
 
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
 
Back
Top