Automated Linking
 

Hi all,
Hopefully someone can advise or help:)

I have various suppliers (8 x) who will send (via email) an audit of
their sites every month. The information will be around 5 to 300 rows
of information for each of the 12 suppliers, as follows:
Month -
Region, District, Store Name, Score 1, Score 2, Score 3, Score 4, Total
Sco
= 2, 101, Nottingham, 4, 3, 5,
2, 14.

I need to pull this information from each supplier into a seperate main
workbook. I will need some information as a summary - for example:
supplier 1, Score 1, Score 2, Score 3, Score 4, Total Score
supplier 2, Score 1, Score 2, Score 3, Score 4, Total Score...

I will also need to list the data in Region or in district order.

I was thinking to have a main folder - for the main workbook, with
subdirectories for each individual supplier. Each month on recieving
the 12 emails from each supplier (All workbooks will be formulated the
same as a template, so the information is set the same), then save the
workbook in the suppliers folder as : supplier1 May 2006 or supplier2
May 2006 and on.

The person using this is not good at excel and just a office clerk, so
I would need for her to press a button - creating a link to the new
data for each supplier for each month!

Can this be done and how?
Many thanks for your help,
Thanx,
Dave


--
deejayh
------------------------------------------------------------------------
deejayh's Profile: http://www.excelforum.com/member.php...o&userid=34110
View this thread: http://www.excelforum.com/showthread...hreadid=538832