Pulling Specific Cell Value from Multiple Workbooks

xtptbx

New Member
Joined
Oct 19, 2021
Messages
1
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi guyz,

Please excuse me if this question has already been asked multiple times. I am very bad with the VBA Scripting and would appreciate any and all help with my query here.

So, what do I need help with?

I have a folder in my C:\ Drive with the name "Acc". In this folder I have Multiple Workbooks. What I am currently looking for is a way to extract a specific Cell content namely L38, from all the workbooks in the folder (this is basically a net value).

I want all of these to be listed in my "Ledger" excel workbook. So, the scenario is pretty much like this:

"Test1.xlsx" Cell Value L38
"Test2.xlsx" Cell Value L38
"Test3.xlsx" Cell Value L38
"Test4.xlsx" Cell Value L38

And all of these values being listed in a column format (like L38 Value from Test1 is in A1, so on and so forth) in my Ledger.xlsx file. It would be great if someone can help me with this query and provide me with a dynamic (possibly - reusable) code to get this done.

Thank you in advance.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,148,283
Messages
5,745,842
Members
423,981
Latest member
ph1l

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top