Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell reference in diff worksheets
Any help please!
I have one workbook 3 worksheets. The data is exact the same but is sorted differently on each worksheet. What I want is the data (cell) from worksheet 1 to reference/update the data to workseet 2 and 3 instantly. The cells will not be the same cells in all 3 worksheets because it is sorted differently. I am not using numbers I am using text, which is another problem because the functions are mostly numeric. I just want the same data that I entered in worksheet1 on A1 to worksheet2 A20 and worksheet3 A40. Is this possible??? There has to be a way -- moseguer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Cell reference problem | Excel Worksheet Functions | |||
indirect function to reference cell on different sheet | Excel Worksheet Functions | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |