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 |