T
thenine
I am very new to working with complex excel functions and I am looking
for a guide to help me complete the following task, and I would also
like to know if the following is possible.
Currently my company creates a usage report for users for each month.
We take those numbers manualy type them into another excel sheet that
totals up the cost for the month. Then we create an invoice for
customers, again in excel.
What I would like to do is.
1. Create our usage report as normal.
2. Import that usage report into the excel sheet that does the cost
caluculations, and have the costs be calculated, and the invoice to be
generated in an automated format.
The calculations are really as easy as X number of users * Y Cost.
Is this a very high level project? Will I need to know VB etc, or is
this something I can do inside of excel itself.
Again I am not looking for an answer, just where to start.
for a guide to help me complete the following task, and I would also
like to know if the following is possible.
Currently my company creates a usage report for users for each month.
We take those numbers manualy type them into another excel sheet that
totals up the cost for the month. Then we create an invoice for
customers, again in excel.
What I would like to do is.
1. Create our usage report as normal.
2. Import that usage report into the excel sheet that does the cost
caluculations, and have the costs be calculated, and the invoice to be
generated in an automated format.
The calculations are really as easy as X number of users * Y Cost.
Is this a very high level project? Will I need to know VB etc, or is
this something I can do inside of excel itself.
Again I am not looking for an answer, just where to start.