Linking Multiple Worksheets and Cells
 

I have to process up to 125 worksheets with similar information every week
and then combine it into a master order form. The data I am compiling is very
basic, names, addresses, cost centers, etc. However, I cannot figure out
which formula to use to be able to gather these individual worksheets from
individual users and populate different rows, without overwriting the info,
on the master worksheet. Please help, I need to save hours of time!?!?!?

Linking Multiple Worksheets and Cells
 

Hi Lkap

This is a code example
http://www.rondebruin.nl/copy2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lkap" wrote in message ...
I have to process up to 125 worksheets with similar information every week
and then combine it into a master order form. The data I am compiling is very
basic, names, addresses, cost centers, etc. However, I cannot figure out
which formula to use to be able to gather these individual worksheets from
individual users and populate different rows, without overwriting the info,
on the master worksheet. Please help, I need to save hours of time!?!?!?