I have created a workbook that uses multiple different macros and formulas and have nearly completed it. I have come to the final stage and am completely lost. I will try and give a short but detailed rundown of the workbook and what I want to do.
Page 1:
Criteria 1: A drop down box with a list of Companies
Criteria 2: A cell that updates depending on the company to list the worksheet the information is on.
Criteria 3: The description of the number I am trying to pull (ie stock price, high, low, etc)
I need a macro that would use these three criteria to find the correct worksheet from criteria 2 and pull the information from criteria 1 & 3.
On the pages with the information I want to pull the setup is like this.
Criteria 1: A list of Companies
Criteria 2: Under each list of companies are subcategories. These are criteria 3 above.
Both criteria 1 and 2 are in column A, I need to pull the information from the corresponding cell in column B.
If you need more information than this please let me know.
Bookmarks