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?


--
Ctech
------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=500551

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

regards

Kurt

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

Anyway, this is to late for this report anyway

--
Ctec
-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=50055

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

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

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


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

--
Ctec
-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=50055