Hi guys, first time poster... looking for some help/advice. I know this question has been answered in part for some other requirements but cant seem to apply those resolutions to my problem...
I am trying to create a macro that will follow these basic steps:
*Clear all data in my worksheet "Data"
*Prompt and allow the user to select multiple csv files (from possibly different directories)
*Import specific data from the csv files: B29 and C29 down to the last row containing data
- example attached
*Import this data to my master workbook (worksheet "Data") but obviously do not overwrite and append each files data to the bottom of each imported file
Bookmarks