calculate multiple worksheet totals then invoice

**lostplanet** · 07-25-2007, 04:29 AM

*sorry i meant to say workbook rather than worksheet totals in the title.*

hello, I am very new to excel hence why i am here. i have made very simple worksheets in the past for simple printing but thats as far as my excel knowledge goes.

what i am trying to acheive is this,

A friend who has a small civil engineering company has asked me to try to automate some of there paperwork tasks they get daily.

an example of where i think excel could be used is here:

an engineer on site fills out a predefined work sheet with for example: hours and consumables(more fields will need to be added) used that day on his laptop. this information is emailed back at the end of each day to the office where a normal job folder is held and updated.

this work book is stored in the appropriate folder.

at the end of 5 days there would be 5 separate work books with the data on from the engineer/engineers.

my idea is to have excel automatically merge?/overwrite?/calculate the data in each field for the workbooks day 1, 2, 3, 4, 5 data totals into one invoice sheet for the office to print and email off to the client.

can excel be manipulated to this? and for my next question where do i start

**lostplanet** · 08-03-2007, 07:01 AM

bump anyone help me with this? should i be looking at different software?

**arthurbr** · 08-03-2007, 07:26 AM

Hi lostplanet,
the idea of this kind of forum is to help out when someone gets stuck somewhere in his project.
What you are asking here is to build a whole project for you, which obviously is a large task for volunteers.
This being said, XL can do the kind of thing you are asking and I suspect there should be free examples on the net to get you started.

Good Luck, and if you get stuck don't hesitate