inputting data from multiple worksheets and calculating costs of the results
Posted on 2012-09-12
My work has several differnt copy machines with each employ having their own copy code. each month the copiers provide a usage report - listing all copies done for each copy code.
So far I am able to extract the number of copies from each sheet, however one copier does provide color: worksheet COPY-DUPCTR2 column H, but right now this data is not being pulled (I do need it to pull).
I also need when this report is run to extract which organization and fund the copy code is assigned to (this way the right department is charged.) this information can be pulled from the worksheet Fund and Org.
Now once the Run Report macro is finished I than want to run the calculate cost macro. This macro is to go through each column "Cost" on the Copy-Report and apply the charge: 0.04 for Black and white and .18 for color. The color is only applied to Column H on the Copy report.
Once all of the columns for Cost are complete, the totals need to be calculated at the end of the Copy Report (Columns AG and AH) I need to know the totals for each copy code (number of copies and total charge amount).
I have attached the workbook. All macros and buttons are on the Copy-Report sheet.
Any help would be great.