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? |
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? |
All times are GMT +1. The time now is 12:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com