Hi,
if anyone could help on the following problem i would really appreciate it:
I have about 15 status reports that come in each month from around the country, now each report is spread across 4 sheets in excel. it has information about expenses, time off, amount of people, and text boxes filled in with reports.
this report that comes in will always have differnet values but the format should be the same, i would like a way of collating the data, such as amount spent on fuel( part of expenses) and budget into a bigger picture file, for the entire fleet, so i could just open one master document and have it show me, for instance the total budget for the 15, this would obviously come from the 15 indiviual reports, these are all emailed in throughout the month.
i hope i've explained clearly enough so far.
So if anyone could help, what i would like is the easiest way to take data from one excel document and put it into another document, as it comes in, in the most effecient way, rather than just copy and pasting all the seperate bits of information and putting them into the new document then adding up for all 15 reports.
which at present it takes about an hour to take all the information across.
a more effecient method would be highly appreciated
Thanks
Simon
if anyone could help on the following problem i would really appreciate it:
I have about 15 status reports that come in each month from around the country, now each report is spread across 4 sheets in excel. it has information about expenses, time off, amount of people, and text boxes filled in with reports.
this report that comes in will always have differnet values but the format should be the same, i would like a way of collating the data, such as amount spent on fuel( part of expenses) and budget into a bigger picture file, for the entire fleet, so i could just open one master document and have it show me, for instance the total budget for the 15, this would obviously come from the 15 indiviual reports, these are all emailed in throughout the month.
i hope i've explained clearly enough so far.
So if anyone could help, what i would like is the easiest way to take data from one excel document and put it into another document, as it comes in, in the most effecient way, rather than just copy and pasting all the seperate bits of information and putting them into the new document then adding up for all 15 reports.
which at present it takes about an hour to take all the information across.
a more effecient method would be highly appreciated
Thanks
Simon