

June 4, 2021

Hi Mynda,
I have an extract of Statement of Accounts from an application which downloads each Client account code into multiple sheets. I have attached the sample file and would like to know how to extract certain cell reference from each Sheet.
The End result is per Sheet11 of the file.
Thank you and hope to hear from you soon.


Trusted Members

December 20, 2019

Hello
Indirect will let yoiu make the cell from the worksheet name and text
=INDIRECT(A24&"!P3")
Then in the grid you can have a match to find the correct row, and index + Indirect to pull the data
=INDEX(INDIRECT($A24&"!a:a"),$M24)
The one thing you MUST to is to get rid of merged cells - the above will not work with merged cells and they are without doubt the worse thing you can use on a spreadsheet. Try 'Centre Accross Selection' from the formatting menu as it does a simular job but is far less destructive


Trusted Members

December 20, 2019


VIP

Trusted Members

June 25, 2016



June 4, 2021

Hi again,
Getting specific cell reference from multiple sheets in same workbook is now working fine for me.
New similar question:
How do i now get specific cell reference from multiple sheets from a different Excel Workbook (file).
eg.
- I have WB1 and WB2
- WB1 is the master file
- I need to get specific Cell reference from multiple sheets in WB2 into WB1.
Can we still use MATCH & INDIRECT and INDEX? If so, how? I can seem to get it.
Thank you and hope you are able to assist.
1 Guest(s)
