Bright01
asked on
Moving Data from one WS to another
EE Pros,
I have a Workbook with 3 Worksheets. I'm trying to select an Industry on the Splash Screen, have it match up to a range, and then place the new data from a DB (where the range is named), and place it in the third Worksheet.
Please take a look at the sample Attached.
Thank you in advance.
B.
Matching-up-Data-from-a-DB.xlsm
I have a Workbook with 3 Worksheets. I'm trying to select an Industry on the Splash Screen, have it match up to a range, and then place the new data from a DB (where the range is named), and place it in the third Worksheet.
Please take a look at the sample Attached.
Thank you in advance.
B.
Matching-up-Data-from-a-DB.xlsm
ASKER
Saurabh,
Thanks for jumping in....however, I don't believe that will work as a automatic macro. If you look at the code I provided, you will see it looks for a change in the cell N16 for a particular Industry that then triggers the move.
Please take a relook.
Thank you,
B.
Thanks for jumping in....however, I don't believe that will work as a automatic macro. If you look at the code I provided, you will see it looks for a change in the cell N16 for a particular Industry that then triggers the move.
Please take a relook.
Thank you,
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You nailed it! Thanks very much..... excellent work...and fast.
B.
B.
Open in new window
Saurabh...