Hi All,
I want to create a macro which will basically refer say Cell E5 for value say A and keep 4,5 & 6 rows unhidden & hide rows 7,8,9 and rows 12,13,14. Incase the value is B then it should hide 4,5,6 & 12,13,14 hidden and keep 7,8,9 unhidden. Incase of value C then it should hide 7,8,9 and 4,5,6 hidden and 12,13,14 unhidden.
I have attached a sample sheet for reference.
any help would be highly appreciated,
Thanks
@Jerry
?
Please Login or Register to view this content.
@jerry:
It is funny that the cells that you described as the focal cell i.e. E5 is actually not the focal cell in your spreadsheet. I opened your spreadsheet and the focal cell is actually E3, and the conditions that you specified for hidden and unhidden are different for the conditions that you specified in the spreadsheet. Hence I will proceed with the conditions that you specified in the spreadsheet to hide and unhide rows.
Also note that I have re-routed the link for your “data validation” cells (E3) to include a blank cell. With a blank cell selected, all row will be visible, until you select either A, B or C.
I have attached a spreadsheet here with the code. I will also paste the code below for you. You can modify and change the rows depending on your preference.
If you find this helpful don’t forget to mark your thread as solved and also add a reputation to the person that helped you.Please Login or Register to view this content.
Cheers
Last edited by vnzerem; 01-28-2014 at 12:01 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks