D
deejayh
Hi all,
Hopefully someone can advise or help
I have various suppliers (8 x) who will send (via email) an audit o
their sites every month. The information will be around 5 to 300 row
of information for each of the 12 suppliers, as follows:
Month -
Region, District, Store Name, Score 1, Score 2, Score 3, Score 4, Tota
Score:
= 2, 101, Nottingham, 4, 3, 5,
2, 14.
I need to pull this information from each supplier into a seperate mai
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, wit
subdirectories for each individual supplier. Each month on recievin
the 12 emails from each supplier (All workbooks will be formulated th
same as a template, so the information is set the same), then save th
workbook in the suppliers folder as : supplier1 May 2006 or supplier
May 2006 and on.
The person using this is not good at excel and just a office clerk, s
I would need for her to press a button - creating a link to the ne
data for each supplier for each month!
Can this be done and how?
Many thanks for your help,
Thanx,
Dav
Hopefully someone can advise or help
I have various suppliers (8 x) who will send (via email) an audit o
their sites every month. The information will be around 5 to 300 row
of information for each of the 12 suppliers, as follows:
Month -
Region, District, Store Name, Score 1, Score 2, Score 3, Score 4, Tota
Score:
= 2, 101, Nottingham, 4, 3, 5,
2, 14.
I need to pull this information from each supplier into a seperate mai
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, wit
subdirectories for each individual supplier. Each month on recievin
the 12 emails from each supplier (All workbooks will be formulated th
same as a template, so the information is set the same), then save th
workbook in the suppliers folder as : supplier1 May 2006 or supplier
May 2006 and on.
The person using this is not good at excel and just a office clerk, s
I would need for her to press a button - creating a link to the ne
data for each supplier for each month!
Can this be done and how?
Many thanks for your help,
Thanx,
Dav