Copy content of coloums between different workgroups

  • Thread starter Thread starter Satish Sonbarse
  • Start date Start date
S

Satish Sonbarse

Want to copy the content of a coloum ( eg Coloum F ) from 10 different excel
workgroup to a Master excel workgroup. (ie. to copy the content of coloum F
from 10 different excel workgroups to a new master excel workgroup into the
coloums starting from say coloum C to coloum L respectively).
Any change/Update in any of these 10 excel workgroups should be updated in
Master excel workgroup.
The master excel workgroup is in Version 2003 while the 10 excel workgroups
from which data to be copied are in lower versions.

Help from the friends will be highly appreciated !
 
Most simple way is to link the columns to your master sheet, instead
of copying. Each time when you open the worksheet select Yes to
update links and that would update your master.

AQIB RIZVI
 
Thanks Aqib for the suggestion,

I am using links instead of copying, but as any changes done in any of the
10 different excel workgroup which are are of older version than master
workgroup the Update doesnt return correct updated value, instead returns the
old unchanged value or gets #ref error.

Regards,
Sonbarse :-((
 
Back
Top