- Each month I must update "final reports" which contain information from "initial reports" which are saved monthly in folders containing the new month and year
- How can I design a macro that completes the basic data entry for me, thus saving time and limiting typos?
- While I am familiar with recording macros, I am not familiar with how to build a macro that will easily pull information from a new file path
- The file path will be different each month, however, it will follow the same naming pattern ie this month it is "2013 > 0113" next month it will be "2013 > 0213"
Thank you for your time and help.
Bookmarks