C
ChrisJ
I have 13 copiers
Each produces a csv with an account ID column, a mono page count
column and a colour page count column, 6 times per year.
The account ID column contains a 5 digit number. The first two digits
identify the cost centre that needs charging. The next 3 digits
represent the user which I don't need to use here. There are multiple
users per cost centre so multiple rows in each spreadsheet that refer
to each cost centre but they are not necessarily adjacent. I'd like to
write a separate spreadsheet that adds up all the mono page counts for
each cost centre and all the colour page counts for each cost centre
across all 13 csv reports. Ideally I don't want to edit the csv's at
all, I just want to drop the 13csvs and 1 spreadsheet in their own
folder and the spreadsheet automatically pullthe required information
from the csvs. This is for an accounting user who doesn't really have
a clue about spreadsheets so I need to minimise the interaction they
need with the
I need a function to put in row 1 (for cost centre 1) that says "sum
(monopage count column in all linked sheets where left (accountID,2) =
account cost centre 1" style function but I'm not sure how to do this.
Can it be done easily this way or should I write a small perl script
to parse each csv to get the answer programatically?
Looking forward to learning more about excel....
Thanks
Chris
Each produces a csv with an account ID column, a mono page count
column and a colour page count column, 6 times per year.
The account ID column contains a 5 digit number. The first two digits
identify the cost centre that needs charging. The next 3 digits
represent the user which I don't need to use here. There are multiple
users per cost centre so multiple rows in each spreadsheet that refer
to each cost centre but they are not necessarily adjacent. I'd like to
write a separate spreadsheet that adds up all the mono page counts for
each cost centre and all the colour page counts for each cost centre
across all 13 csv reports. Ideally I don't want to edit the csv's at
all, I just want to drop the 13csvs and 1 spreadsheet in their own
folder and the spreadsheet automatically pullthe required information
from the csvs. This is for an accounting user who doesn't really have
a clue about spreadsheets so I need to minimise the interaction they
need with the
I need a function to put in row 1 (for cost centre 1) that says "sum
(monopage count column in all linked sheets where left (accountID,2) =
account cost centre 1" style function but I'm not sure how to do this.
Can it be done easily this way or should I write a small perl script
to parse each csv to get the answer programatically?
Looking forward to learning more about excel....
Thanks
Chris