get values from sheets

pero978 · #1 01-11-2016, 07:30 AM

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

pero978 · #2 01-11-2016, 11:37 PM

hi,
solved problem with indirect function.
BR

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display multiple values as new values based on selection from template.	MvdB	Excel	2	09-29-2015 08:51 PM
Reference another workbook and return values from the same cell across multiple sheets/tabs	lwls	Excel Programming	5	11-08-2014 02:11 PM
carry values of various sheets to another sheet	zizao	Excel	2	06-20-2014 12:47 PM
Reporting Values Between Sheets/Tabs	jjbNana	Excel	3	10-06-2011 10:28 PM
Linking sheets to fetch transactions from sheets to another	waqer	Excel	4	09-01-2011 12:35 PM