Copy Cell Data from one Worksheet to Another
 

Hi Everyone,

Hope someone can help? I have a spreedsheet used by our purchasing
department - a purchase order if you like! From the main sheet a second
sheet is constructed listing the products they are buying an dis laid out to
import into our Stock System. The users then save this Workbook under the
name of the supplier and the date due.

What I want to be able to do is have a WB on the network that collates all
the information from the second sheet as each buyer saves their work book so
that I can then import the data direct into our SOP database from one WB
rather than having to open each Purchase order and copy the contents of each
WB into a separate WB to import, does tha make sense?

Any VBA pointers would be greatly appreciated

TIA

Jonathan