darkwizdom42
New Member
- Joined
- Jan 28, 2025
- Messages
- 5
- Office Version
- 2021
- 2019
- Platform
- Windows
- Mobile
- Web
Hello all!
Needed a little help to see if this was possible.
So I have a formula setup to pull values from a worksheet/report I paste into the Master worksheet everyday. I only really use the data on the last few lines of the report and since it varies and changes everyday, I usually just copy and paste that bottom section into my master workbook and it pulls fine. However, I want to ask if there was a way to be able to just create a formula that pulls this data without having to only copy and paste that bottom section. Just copy the whole thing and have the formula pull the value.
I included a few screenshots to show what I mean. Note that the yellow highlight indicates that it can change everyday (Categories and Names) and the pink highlights are the values I'm looking to pull (the total "solved" for each category).
Hope it makes sense. Let me know if you require any further clarification.
The current formula I use is:
=IFERROR(INDEX($A:$H,MATCH("SOLVED:",$A:$A,0),MATCH("ENTRY",$A$3:$H$3,0)),0)
Thanks in advance!
Needed a little help to see if this was possible.
So I have a formula setup to pull values from a worksheet/report I paste into the Master worksheet everyday. I only really use the data on the last few lines of the report and since it varies and changes everyday, I usually just copy and paste that bottom section into my master workbook and it pulls fine. However, I want to ask if there was a way to be able to just create a formula that pulls this data without having to only copy and paste that bottom section. Just copy the whole thing and have the formula pull the value.
I included a few screenshots to show what I mean. Note that the yellow highlight indicates that it can change everyday (Categories and Names) and the pink highlights are the values I'm looking to pull (the total "solved" for each category).
Hope it makes sense. Let me know if you require any further clarification.
The current formula I use is:
=IFERROR(INDEX($A:$H,MATCH("SOLVED:",$A:$A,0),MATCH("ENTRY",$A$3:$H$3,0)),0)
Thanks in advance!