MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Simultaneously updating


Posted by Tim Cluney on September 10, 2001 8:36 AM

We are creating a mini database with excel for our Quality Dept. We track our work with a simple self generated tracking number and we would like to be able to place this tracking number in a cell and have it simultaneously update on each page. Some of our reports can have as many as 20 pages, so being able to automatically update these cells would be a great time saver instead of cutting and pasting to 20 different pages. Any idea's? Thanks in advance.


Posted by Tom Urtis on September 10, 2001 9:19 AM

Would a formula do the trick?? Click on the destination cell in the other worksheet(s), and enter (assuming the tracking number is in A1 of your Report sheet):
=IF(Report!A1="","",Report!A1).
Speed tip, because you have 20 sheets or so, if the destination cell is the same on all of them, (say cell B3), then enter the formula for all sheets at once, by selecting all sheets (select the first sheet, holding the Shift key, and select the last sheet), click cell B3, enter the above formula, then click on the Report sheet to deselect all destination sheets.

HTH

Tom Urtis