Thread: [Solved] get values from sheets
View Single Post
 
Old 01-11-2016, 07:30 AM
pero978 pero978 is offline Windows 10 Office 2013
Novice
 
Join Date: Nov 2015
Posts: 13
pero978 is on a distinguished road
Default 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
Reply With Quote