Hello,
I am trying to improve my process by creating a file that consolidates data sheets.
Because my source file names are variable and always changing, as well as the sheets I want to grab, I was hoping to create a VBA script that first prompts me to open the workbook containing the worksheet I want to copy, then prompts me to name the sheet I want to copy. The workflow would look, at a high level, like this: Clicks Button to run>Prompts me to Find the File>Opens File>Prompts me to input the name of the sheet I want to copy>Copies sheet to destination workbook>Closes source workbook.
I have the script for opening the workbook, I just don't know how to chain the rest. I would appreciate any help, as I am a very new VBA user.
Chris
I am trying to improve my process by creating a file that consolidates data sheets.
Because my source file names are variable and always changing, as well as the sheets I want to grab, I was hoping to create a VBA script that first prompts me to open the workbook containing the worksheet I want to copy, then prompts me to name the sheet I want to copy. The workflow would look, at a high level, like this: Clicks Button to run>Prompts me to Find the File>Opens File>Prompts me to input the name of the sheet I want to copy>Copies sheet to destination workbook>Closes source workbook.
I have the script for opening the workbook, I just don't know how to chain the rest. I would appreciate any help, as I am a very new VBA user.
Chris