Terry Echols
Member
I'm using Excel 2013.
I want to pull info from two cells across all spreadsheets in a specific folder. I want to pull the customer name (cell F6) and the current balance (cell I39). I only want to pull customers that have a balance > than zero.
All workbooks in this folder have only one sheet named "Statement".
Folder Path: C:\Users\Monica Reynolds\Documents\Customer Spreadsheets\Statements - NEW FORMAT (ONLY pull F6 customer name, not the full path).
Customer Name = F6
Total Due = I39
So I'd like to pull this information from the files in the folder and have column A be "Customer Name" and column B be "Balance" with those as headers.
How can I do this?
The file attached has sample data.
Thanks,
Terry
I want to pull info from two cells across all spreadsheets in a specific folder. I want to pull the customer name (cell F6) and the current balance (cell I39). I only want to pull customers that have a balance > than zero.
All workbooks in this folder have only one sheet named "Statement".
Folder Path: C:\Users\Monica Reynolds\Documents\Customer Spreadsheets\Statements - NEW FORMAT (ONLY pull F6 customer name, not the full path).
Customer Name = F6
Total Due = I39
So I'd like to pull this information from the files in the folder and have column A be "Customer Name" and column B be "Balance" with those as headers.
How can I do this?
The file attached has sample data.
Thanks,
Terry