Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy content of coloums between different workgroups
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 ! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy content of coloums between different workgroups
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy content of coloums between different workgroups
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 :-(( "Aqib Rizvi" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
How do I add every other coloums in a linked sheet? | Excel Discussion (Misc queries) | |||
how do I limit the number of coloums? | Excel Discussion (Misc queries) | |||
How to match the Coloums | Excel Discussion (Misc queries) | |||
Excel 2002 - link columns across workgroups | Excel Discussion (Misc queries) |