Hi!

Maybe you want something like this:

Assume you have 3 sheets and want the data from Sheet1 A1 to also appear in
Sheets 2 and 3 A1.

Enter this formula in both Sheet2 and Sheet3 A1:

=IF(Sheet1!A1="","",Sheet1!A1)

If Sheet1 A1 is blank the other Sheets A1 will also be blank.

If you want to "mirror" all or part of Sheet1 then you can just copy the
formula down and/or to the right as needed.

Biff

"josh3185" wrote in
message ...

The spreadsheet is what we use at work to monitor our progress. I'm a
cartographer and this spreadsheet lists all of the maps with their map
name, their size and other details. When a new map is added to the
first worksheet as a new row, we have to manually add it to the same
row in the other worksheets. The three worksheets link to each other. I
thought that there may be a way of adding the row to the first worksheet
and it automatically adds to the other worksheets in the same position.
Sorry it sounds confusing. I hope that makes more sense.

Josh


--
josh3185
------------------------------------------------------------------------
josh3185's Profile:
http://www.excelforum.com/member.php...o&userid=34029
View this thread: http://www.excelforum.com/showthread...hreadid=537902