userds5593
New Member
- Joined
- Dec 5, 2023
- Messages
- 1
- Office Version
- 2011
- Platform
- Windows
Hello,
I have a couple of files that my manager uploads into an internal folder for our department on a monthly basis. Those files relate to multiple existing real estate investments of our own.
Each real estate file differs in terms of its format. What I need is one cell from each of those files, and that is the effective monthly rent figure.
I need to compile all those effective monthly rent figures in a Monthly Report excel file that I submit to my manager showcasing the effective rent for every month.
How can I create a VBA to allow me to extract the effective monthly rent figure from those files every month into my Monthly Report file ?
Thank you!
I have a couple of files that my manager uploads into an internal folder for our department on a monthly basis. Those files relate to multiple existing real estate investments of our own.
Each real estate file differs in terms of its format. What I need is one cell from each of those files, and that is the effective monthly rent figure.
I need to compile all those effective monthly rent figures in a Monthly Report excel file that I submit to my manager showcasing the effective rent for every month.
How can I create a VBA to allow me to extract the effective monthly rent figure from those files every month into my Monthly Report file ?
Thank you!
