LinkBack URL
About LinkBacks
Hi, I have linked three worksheets together but was wondering if there was a way that if you add a cell in the first worksheet it can be added in the other worksheets automatically, so you don't have to manually put it in.
Thanks
Josh
Automatically adding cells from one worksheet to another
Hi, I have linked three worksheets together but was wondering if there was a way that if you add a cell in the first worksheet it can be added in the other worksheets automatically, so you don't have to manually put it in.
Thanks
Josh
Need a better explanation.
Biff
"josh3185" <josh3185.275k4n_1146526801.9605@excelforum-nospam.com> wrote in
message news:josh3185.275k4n_1146526801.9605@excelforum-nospam.com...
>
> Hi, I have linked three worksheets together but was wondering if there
> was a way that if you add a cell in the first worksheet it can be added
> in the other worksheets automatically, so you don't have to manually put
> it in.
>
> Thanks
>
> Josh
>
>
> --
> josh3185
> ------------------------------------------------------------------------
> josh3185's Profile:
> http://www.excelforum.com/member.php...o&userid=34029
> View this thread: http://www.excelforum.com/showthread...hreadid=537902
>
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
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
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" <josh3185.275us4_1146540710.63@excelforum-nospam.com> wrote in
message news:josh3185.275us4_1146540710.63@excelforum-nospam.com...
>
> 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
>
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
Originally Posted by 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" <josh3185.275y8z_1146545101.7494@excelforum-nospam.com> wrote in
message news:josh3185.275y8z_1146545101.7494@excelforum-nospam.com...
>
> 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 Wrote:
>> 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" <josh3185.275us4_1146540710.63@excelforum-nospam.com> wrote
>> in
>> message news:josh3185.275us4_1146540710.63@excelforum-nospam.com...
>> >
>> > 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
>> >
>
>
> --
> josh3185
> ------------------------------------------------------------------------
> josh3185's Profile:
> http://www.excelforum.com/member.php...o&userid=34029
> View this thread: http://www.excelforum.com/showthread...hreadid=537902
>
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.
"josh3185" <josh3185.277c8y_1146609903.1554@excelforum-nospam.com> wrote in
message news:josh3185.277c8y_1146609903.1554@excelforum-nospam.com...
>
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks