Stephanie30
New Member
- Joined
- May 21, 2015
- Messages
- 13
Hi
I was looking for a VBA to do the following things stage by stage.
Stage 1: Click button which should open a drop down1 with list of names
Stage 2: Select the NAME whose values need to be exported from the Master Workbook (Names are in Column B (Criteria1), dates are in row 3:3 (Criteria2)and values are in rows under dates)
Stage 3: Select the start and end dates for exporting values
Stage 4: After selecting the names and dates, a second drop down should appear with a list of all the available workbooks from a specific folder
Stage 5: Select and Open the workbook from the drop down list
Stage 6: Paste Values (from previosly selected name and dates) in column D of the newly opened workbook based on their matching dates in column C.
I hope its clear but if not then please do ask
Thnaks in advance
I was looking for a VBA to do the following things stage by stage.
Stage 1: Click button which should open a drop down1 with list of names
Stage 2: Select the NAME whose values need to be exported from the Master Workbook (Names are in Column B (Criteria1), dates are in row 3:3 (Criteria2)and values are in rows under dates)
Stage 3: Select the start and end dates for exporting values
Stage 4: After selecting the names and dates, a second drop down should appear with a list of all the available workbooks from a specific folder
Stage 5: Select and Open the workbook from the drop down list
Stage 6: Paste Values (from previosly selected name and dates) in column D of the newly opened workbook based on their matching dates in column C.
I hope its clear but if not then please do ask
Thnaks in advance
Last edited:
