Forum Discussion
How to Pull Required Data from Multiple Workbooks to Single Workbook
Hello Everyone, I have multiple files (same template) placed on one location. I need to open file available at folder one by one & pull only required data from each file. Template which have dat...
Hi Hans, Can you elaborate with one example for named ranges?
Hi,
Not sure what you expect from an example...
* In the source file:
- right-click on the source cell you want to use, "Define name", and give a name that you can remember - let's say NAME
See: Define and use names in formulas
https://support.microsoft.com/en-us/office/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64
- make sure you know the name(s structure) of the source files - let's say SOURCE
- in the target file, fetch the content of the files using the INDIRECT function
something like
filename content
--------- --------
file1.xlsx =INDIRECT(A2!NAME)
More about INDIRECT in
INDIRECT function
https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261
Does that make sense?
Kind regards
Hans
Not sure what you expect from an example...
* In the source file:
- right-click on the source cell you want to use, "Define name", and give a name that you can remember - let's say NAME
See: Define and use names in formulas
https://support.microsoft.com/en-us/office/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64
- make sure you know the name(s structure) of the source files - let's say SOURCE
- in the target file, fetch the content of the files using the INDIRECT function
something like
filename content
--------- --------
file1.xlsx =INDIRECT(A2!NAME)
More about INDIRECT in
INDIRECT function
https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261
Does that make sense?
Kind regards
Hans
- I need to work on multiple files so using Indirect function it will be little bit difficult.
Can Names will be used in macros? I'm looking to have some guidance on macro in this case.