Automatically adding cells from one worksheet to another

[josh3185]

Hi, I have linked three worksheets together but was wondering if ther
was a way that if you add a cell in the first worksheet it can be adde
in the other worksheets automatically, so you don't have to manually pu
it in.

Thanks

Jos

 

[Biff]

Need a better explanation.

Biff

 

[josh3185]

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]

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

 

[Biff]

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]

OK. So in the " " I add Sheet2 and Sheet 3 etc, or do I actually add the
name of the sheets such as:

=IF('Map Progression List'!A1='Mapping Schedule'!A1,'Suggestions for
Next Edition'!A1)

or do I just paste as is?

Also, if I insert a cell in the first sheet, where the cells below will
go down one, will this be inserted in the other sheets also?

Thanks

 

[Biff]

Ok, since you have long sheet names instead of typing the formulas just
point and let Excel do the dirty work.

If you want Map Progression List A1 to also appear in Mapping Schedule A1:

Navigate to Mapping Schedule A1.
Type an equal sign: =
Then navigate to Map Progression List and select cell A1
Hit ENTER.

Excel will create this formula:

='Map Progression List'!A1

If Map Progression List A1 is empty then the formula in Mapping Schedule A1
will return a 0. If you don't want the 0 displayed then use this formula and
it will suppress the 0 display:

=IF('Map Progression List'!A1="","",'Map Progression List'!A1)

If you insert new rows on Map Progression List the formula will
automatically adjust to the new location of the reference. For example, if
you insert a new row 1 the formula will adjust to:

='Map Progression List'!A2

But it will still reside in cell A1 of Mapping Schedule.

Biff

 

[josh3185]

Thanks for your help. I have them all linked. I guess if you insert a
new cell in the first worksheet, even though they are all linked, you
still have to manually insert the same cells in the other worksheet
with the same function. It wouldn't automatically insert it for you.

 

[Biff]

Thanks for your help. I have them all linked. I guess if you insert a
new cell in the first worksheet, even though they are all linked, you
still have to manually insert the same cells in the other worksheet
with the same function. It wouldn't automatically insert it for you.

You can insert new rows/columns/cells to all sheets or just the selected
sheets in one operation.

Select the sheets (several ways to select the sheets) you want to insert the
new row into by holding down the CTRL key and clicking on the sheet tabs. In
the Title bar you'll notice the word [GROUP]. that means the selected sheets
are treated as group. what you do to one will be done to all.

So, if you insert a new row 1 that will happen on each sheet in the group.
You have to be careful when you work with grouped sheets!!! After your done
make sure you ungroup the sheets. Right click any one of the sheet tabs of
any grouped sheet and select Ungroup sheets.

Biff