Copy Certain Values
I have 2 files where I generate reports for others. They both work the same
way in terms of setup and purpose. What I do is enter information onto the worksheets and run subtotal reports for each sheet using a macro in PERSONAL.xls. What I would like to do is pick up the subtotals from all sheets for certain cells containing matching criteria. I tried a SUMIF across the board but, because my criteria was not present in all sheets considered, I got an error. I would like to pick up the subtotals as values and sum them up by account number. Say I have entries for account 123. The subtotal wizard kicks out a summary cell called 123 Total. What I would like is to have a command where if the left of the 123 Total = the cell in my master sheet and the right of the 123 Total = "Total", pick up the cell I need using the Offset line. I need to stick this in a procedure as well. Thanks (hope this is enough info!) -- I am running on Excel 2003, unless otherwise stated. Please rate posts so we know when we have answered your questions. Thanks. |
Copy Certain Values
Please ignore this post, as I have found a workaround to get my desired
results. |
All times are GMT +1. The time now is 08:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com