| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
link values from same cell of 20 worksheets into column on one she
I would like to list on one sheet, the values of a cell B2 from about 20
worksheets This list would run down a column of the master worksheet ie B1,B2,B3 etc Ideally this list would automatically expand if more sheets were added, perhaps by having a blank 'FIRST" and 'LAST" sheets at either end? I can see how to do the linking by hand, one at a time, but is there a way to do it by formula? In fact I'd like to make two lists on the master sheet- one would be names from all the B2 cells and the other would be corresponding numbers from all the I12 cells |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link cell in to different worksheets in same workbook excel 2003 | Excel Discussion (Misc queries) | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
| Auto Update the formula values without opening the link worksheets | Excel Worksheet Functions | |||
| Creating a link from cell values | Excel Discussion (Misc queries) | |||
| Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
Threaded Mode
