Merging Worksheets from different employees

[jarin]

Thursday, September 06, 2007

Here is my problem:

Have an excel spreadsheet trying to track "customer complaints" and
how they are treated by my CSR, dispatch, accounting & Op. Mgr. Each
of them would get their own section - worksheet - from my spreadsheet
and enter - each working day of the month - info on calls they have
received & how they handled complaints. I want then each of them to
send me back their individual worksheet and I want to copy there info
back into my master spreadsheet for that same week. My spreadsheet
then keeps track of calls that came in and how it was handled and by
who.

So my problem is how can I integrate there results back into my master
spreadsheet.

Many thanks in advance for advice.

Jacques

 

[Ron de Bruin]

Hi jarin

For code see
http://www.rondebruin.nl/copy3.htm

If you use Outlook you can do this to get the files from Outlook
http://www.rondebruin.nl/mail/folder2/saveatt.htm