Forum Discussion
use formula for tabs in excel
I'm using the spreadsheet looking for information from different tabs, I would like to know how to apply the same formula where I can automatically move to the next tab which would be 'Fornecedor 2' ...
=INDIRECT("Fornecedor"&ROW(1:1)&"!B4")This formula can be filled down and it returns the values from: Fornecedor1!B4, Fornecedor2!B4, Fornecedor3!B4 and so on.
alternatively:
=TOCOL('Fornecedor1:Fornecedor99'!B4)
where Fornecedor1 is the first sheet and Fornecedor99 is the last sheet
