syncronising workbooks

[Ctech]

Hi

I have made a spreadsheet with data in columns A-P, which I have sent to 8 different managers. They are now filling data for their PO(rows), in column Q-V.

What is the easiest way to sync the workbooks back to one?

[kurt]

Could you not just share this on the network instead of sending it??

regards

Kurt

[Ctech]

I guess that would have been a good solution, however this than limits one to amend the report at a time. And when there is several people that is to input info, it will be difficult.

Anyway, this is to late for this report anyway.

[Ctech]

I guess I have found the easiest solution to this myself.

By Copying the variable area(column Q-V), and past special as values (skip blanks) into a master workbook.

This works you assume that none of the managers have entired data into other managers PO(rows).


However, I am still very interested in any solotion of a macro, which can sync several documents into a master doc. Depending on a referance cell or two ref cells match... on a row..