Hi, I am new to using VBA and need some help.
I have 30+ sheets in my workbook each named after a product (Product A, Product B, ...). The cell A1 in each sheet has the name of the tab. For example: Cell A1 of Product A sheet has Product A listed.
In another workbook, Cell A2 is a dropdown box with Product Listings. If Product A is selected, then I would like entire contents of Product A from Workbook1 to be displayed in current workbook. Similarly, if Cell A2 has Product B, then entire contents from Product B from Workbook1 should be displayed in current workbook. I can keep both workbooks open while running this.
Hope you can help.
I have 30+ sheets in my workbook each named after a product (Product A, Product B, ...). The cell A1 in each sheet has the name of the tab. For example: Cell A1 of Product A sheet has Product A listed.
In another workbook, Cell A2 is a dropdown box with Product Listings. If Product A is selected, then I would like entire contents of Product A from Workbook1 to be displayed in current workbook. Similarly, if Cell A2 has Product B, then entire contents from Product B from Workbook1 should be displayed in current workbook. I can keep both workbooks open while running this.
Hope you can help.
