Universally changing portion of formulas, within a sheet
Posted by A on January 03, 2002 11:27 AM
Hi...-just discovered your web-site, it's fantastic!
Perhaps I'm approaching this incorrectly, but given my experience, I guess it will have to do.
Given: I have Sheet(1), with data in each row.
Reporting: I want to make a "report" for some of the lines in Sheet(1), so I set up Report(1), Report(2), Report(3), etc. with the Report(#) corresponding to each specific row in Sheet(1).
I have no problem setting up the Report(#'s) [copy tab, using Ctrl & mouse click], however, in each Report(x), I reference Sheet(1) numerous times, indicating a specific row number, corresponding to the Report(#)
Question: Is there universal way to change the reference number, on each report, without going down each column, line-by-line, changing the code? (I have about 60 line changes, for each Report)
Example: in a given cell of Report(14) I have ='Sheet(1)'!A$14, in another Report(14) cell, I may have ='Sheet(1)!H$14, etc.
Help: How can I change the $number, to correspond with the Report(#), for the entire Report (sort of "change all $14 you see to $15")?
I'm only on Report(14), and I have about 50 to go.
Please make your reponse easy to understand (sorry!).
OR: If you know a better way, and it's too complicated for this site, please tell me WHAT to look for, in an Excel manual.