I am wanting to setup a worksheet which will allow me to separate corp credit card charges by cost center and dept and then transfer over to a summary sheet which shows the totals only for each cost center and dept.
Info would be like:
6015-004 $268.85 03/15/01
First 4 digits represent the cost center with the last 3 being the dept number. Any suggestions? I want it in one workbook where others can just enter the information and maybe use a macro button to do all the sorting and subtotaling???? Please help. I'm in over my head!
Info would be like:
6015-004 $268.85 03/15/01
First 4 digits represent the cost center with the last 3 being the dept number. Any suggestions? I want it in one workbook where others can just enter the information and maybe use a macro button to do all the sorting and subtotaling???? Please help. I'm in over my head!