| 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
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 |
|
#5
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 |
|
#6
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 |
|
#7
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 |
| 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) | |||
Hybrid Mode
