Good Morning All,
I'm wondering if someone can help me with the attached sheet i have created. I am looking to hide rows on the "Specification" Sheet when column 'E' shows "N".
By doing this i also need Excel to hide the linked Word Document Object in each row.
To have column "E" change to "Y" the 'Quantity' in Column "D" on the "Site Survey" sheet needs to be changed to 1 or greater.
The sheet is used as a template so there is no reason to un-hide the cells, however it would be beneficial if possible.
Please note that i have removed a lot of the objects from the "Specification" sheet due to document size reduction, the file is available here due to the attachments failing to upload.
https://ufile.io/hpwbq
if anyone can help it will be greatly appreciated.
Many thanks,
I'm wondering if someone can help me with the attached sheet i have created. I am looking to hide rows on the "Specification" Sheet when column 'E' shows "N".
By doing this i also need Excel to hide the linked Word Document Object in each row.
To have column "E" change to "Y" the 'Quantity' in Column "D" on the "Site Survey" sheet needs to be changed to 1 or greater.
The sheet is used as a template so there is no reason to un-hide the cells, however it would be beneficial if possible.
Please note that i have removed a lot of the objects from the "Specification" sheet due to document size reduction, the file is available here due to the attachments failing to upload.
https://ufile.io/hpwbq
if anyone can help it will be greatly appreciated.
Many thanks,