| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- josh3185 ------------------------------------------------------------------------ josh3185's Profile: http://www.excelforum.com/member.php...o&userid=34029 View this thread: http://www.excelforum.com/showthread...hreadid=537902 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically adding cells from one worksheet to another
Need a better explanation.
Biff "josh3185" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically adding cells from one worksheet to another
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically adding cells from one worksheet to another
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically adding cells from one worksheet to another
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically adding cells from one worksheet to another
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" 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 -- josh3185 ------------------------------------------------------------------------ josh3185's Profile: http://www.excelforum.com/member.php...o&userid=34029 View this thread: http://www.excelforum.com/showthread...hreadid=537902 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically adding cells from one worksheet to another
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" wrote in message ... 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" 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 -- josh3185 ------------------------------------------------------------------------ josh3185's Profile: http://www.excelforum.com/member.php...o&userid=34029 View this thread: http://www.excelforum.com/showthread...hreadid=537902 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically adding cells from one worksheet to another
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 Wrote: 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" wrote in message ... 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" 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 -- 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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically adding cells from one worksheet to another
"josh3185" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| Problem adding a worksheet | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| Fill automatically from one worksheet to another based on cel valu | Excel Discussion (Misc queries) | |||
Linear Mode
