I have a summary page, and each cell in that summary page has a long formula that grabs data from another sheet in the same workbook. if that data page changes names, how do i update all the formulas on the summary page (easily) so that they will grab data from the right place?

9/25/2006 12:58:13 PM

if you're working inside the same workbook (i.e. file), then just change the name of the worksheet as usual. The formulas will update themselves automatically

9/25/2006 1:03:47 PM

^ exactly

alternately, if it doesn't change automatically, go to the worksheet (ex. "Sheet2") you need to change the formulas, do a replace "Sheet1" with "Sheet3".

9/25/2006 1:08:03 PM

well holy crap, that was easy.

thanks joe

9/25/2006 1:08:08 PM