Copy content of coloums between different workgroups

[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 !

 

[Aqib Rizvi]

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

 

[Satish Sonbarse]

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 :-((