Dec 03 2022 02:33 PM
They are all the same invoice on all 400 tabs, but I would like to make a master list with the same 5 cells from each invoice.
I have the current formula in a list ='Basic Invoice'!$I$10 and it brings the info into the master list, but I need the Basic Invoice to update to the next worksheet hoping to use auto fill or something else?
Dec 03 2022 09:34 PM - edited Dec 03 2022 09:35 PM
@Amanday1234 Without seeing sample, really hard to advise. In general, for Microsoft-365 user, can use TOCOL()/TOROW() functions to consolidate data from multiple sheets to one sheet. You can use TOCOL() like.
=TOCOL(Sheet2!D5,Sheet3!D5,Sheet4!D5,Sheet5!D5)
For multiple sheet reference as a time (Array Approach), use following formula. See the attached file.
=TOCOL(Sheet2:Sheet5!D5)
Dec 03 2022 09:48 PM
Thanks for the info. I was able to finally get it to do what I needed using the define name, index, then indirect formulas.
Dec 03 2022 11:34 PM