jaimecastellanos
New Member
- Joined
- Apr 1, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello, I have a spreadhseet to keep track of project status, but im making a worsheet called "POCFinder" with a dropdown list with all my projects (B3), next to it there is a hyper link to take me to the "POCData" worksheet with formula (=HYPERLINK("#"&CELL("address",INDEX('POC Data'!D6:D240,MATCH(B3,'POC Data'!D6:D240,0))),"Go Project Data")).
This last formula works just fine, but what I need now is a macro that works like a vlook up and copy and pastes the information from the data sheet to the finder sheet
this is the table where I want the data to display, the POCdata sheet has many tables exactly like this one, Every table is above the other one
so on and so on, how can i make the display button to pull data from this sheet? Thank you experts!!
This last formula works just fine, but what I need now is a macro that works like a vlook up and copy and pastes the information from the data sheet to the finder sheet
so on and so on, how can i make the display button to pull data from this sheet? Thank you experts!!