get values from sheets
hi,
I have, for now, two sheets (A and B) and third sheet called summary. I would like to get 2 values from sheet a and b (always the same cells, first U109 and U160 from both sheets).
Like I said, for now i have two sheet but many new sheets will be added (c, d, etc). I would like to write formula (macro?) to get values from those two cells (in A,B,C,D....etc. sheets) on summary sheet.
is it possible? Maybe indirect function?
Thanks
|