Hi All,
I am trying to create a macro that pulls data from one tab to another based on specific criteria. I've attached the file to this posted. In the attached spreadsheet, I am looking to pull the data from the "Fund Information" tab to the "Overview" tab. How I am trying to get this to work is when I set the region and currency in the "Overview" worksheet (cells B2 and C2) I can then run a macro that will:
1) Pull the fund name in column A of the "Fund Info" tab into the "Overview" tab under the Holdings Summary section (starting at cell A16), based on the criteria selected in cells B2 & C2 in the "Overview" tab
2) Pull the Investment $ Amount (column H in the "Fund Info" tab) of the specific fund under the corresponding headings in row 3 of the "Overview" tab.
If someone can point me in the right direction it would help immensely.
Much appreciated.
Matt
Bookmarks