Hello,
I am brand new to Macros and I can't figure out this problem I am facing.
I have multiple columns, ID, Store Name, Type in a workbook. And Store Name is a dropdown at column D6 that I can select a specific store from and see that store's data only on current worksheet. My other 2 worksheets do not change at any selection.
I want to export the result of each Store selection in a new workbook that contains one specific store's data on worksheet 1 and includes the other 2 worksheets that remains the same and the new workbooks take the name of the store selection.
Any help is appreciated.
Thank you.
I am brand new to Macros and I can't figure out this problem I am facing.
I have multiple columns, ID, Store Name, Type in a workbook. And Store Name is a dropdown at column D6 that I can select a specific store from and see that store's data only on current worksheet. My other 2 worksheets do not change at any selection.
I want to export the result of each Store selection in a new workbook that contains one specific store's data on worksheet 1 and includes the other 2 worksheets that remains the same and the new workbooks take the name of the store selection.
Any help is appreciated.
Thank you.