Quelbarachi
New Member
- Joined
- Dec 29, 2020
- Messages
- 1
- Office Version
- 365
- 2019
- Platform
- Windows
Hi,
I'm looking to extract information from multiple files (file data) in a folder and paste the results in a new workbook.
1. I want to find the total income on a certain date.
2. I want to find the total from the total column.
3. If the file name has "cash" in it, save it as a record labeled cash.
4. If the file name has "accrual" in it, save it as a record labeled accrual.
5. Save a record of the customer id (which is the 7 characters of the file name)
The goal is to get it to look like the desired result image.
I'm looking to extract information from multiple files (file data) in a folder and paste the results in a new workbook.
1. I want to find the total income on a certain date.
2. I want to find the total from the total column.
3. If the file name has "cash" in it, save it as a record labeled cash.
4. If the file name has "accrual" in it, save it as a record labeled accrual.
5. Save a record of the customer id (which is the 7 characters of the file name)
The goal is to get it to look like the desired result image.
