I have a report that I get in "Excel" format, that is it looks like the printed report but "fires" into cells. I need to look at certain portions of the report which move from report to report in their row location (always the same column). For instance, the report refences a base unit in column c and I can run MATCH and find it starts on row 5 and with MATCH & find it ends on row 48 this month. In column E is a reference that I need to look up in the A column. If I can range the beginning and end of the particular base unit, it's a DSUM and there are 40+ of these to look up. Currently, I have to go into the report and manually search and replace which takes 2 hours to put in the correct row references. How can this process be automated? Neither ADDRESS nor MATCH will let me use them within the DSUM formula.
Dana
Dana