syncronising workbooks
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 |
syncronising workbooks
Could you not just share this on the network instead of sending it??
regards Kurt |
syncronising workbooks
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 |
syncronising workbooks
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 |
All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com