Jun 06 2022 01:22 PM
Hello,
I am creating a recap and have hit a stumbling block. I want to "automate" the recap summary by pulling from the entry sheet. Here is my issue, on the entries sheet there is a column for remarks if something was late or had issues the person can enter. On the Summary page, I want excel to pull the remark and place the remark as well as other information, which I believe H/V look up would solve but I'm having issues with think of how to find a way to pull the remarks.
Most of the remarks would be empty.
Thank you!
Zack W.
Jun 06 2022 06:56 PM
Jun 07 2022 06:20 AM
@SamB513Thank you for the reply.
I thought about this after I posted, but I believe it makes more sens to filter the data if they route went out late. So I believe the statement should be - If "Delay" is true, then Filter the values.
So the entries will be made on the "Entry Tab" then the data is filtered for the summary on the Overview tab.
Attached is the link: https://1drv.ms/x/s!ApwNjcg8Ua7Khb1cVaGJo-r3T3deXQ
Thank you!
Jun 07 2022 04:17 PM