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
|