View Single Post
  #1   Report Post  
moseguer
 
Posts: n/a
Default 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