| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Link cells in a workbook and be able to sort differently
How can I link two pages in the same book so that each time a cell is updated
the info carries to the other sheet AND I be able sort each sheet differently and not lose info? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Link cells in a workbook and be able to sort differently
Just some thoughts. Think what you're after here could be done using either
VLOOKUP or INDEX/MATCH provided there's unique values in a key* col which is common to both sheets, eg: Product ids? *which could be used in matching Suggest you browse Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mex" wrote: How can I link two pages in the same book so that each time a cell is updated the info carries to the other sheet AND I be able sort each sheet differently and not lose info? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
| How do I link cells from a workbook, to talley one one sheet? | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Link to another workbook error | Excel Discussion (Misc queries) | |||
| Can't link cells in worksheets in same workbook | New Users to Excel | |||
Linear Mode
