Use EntireRow to hide / show rows

[Autoeng]

Hello,

I'm trying to figure out how to use EntireRow to hide and show rows. In the attached example if an Ingredient is selected I want it to show on the Shopping List but if an ingredient is not selected I do not want there to be a blank line. The list as it is now has the blank rows that I want to hide. I can't seem to get it to work.

Thank you,
Autoeng

[Winon]

Hello Autoeng,

How to attach a sample Workbook.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

[Autoeng]

Thank you Wilson,

I've uploaded an updated spreadsheet with Before and After pages. I thought the file uploaded in my first posting but I guess I didn't hit the Upload button.

Thanks,
Autoeng

[PCI]

What about a Pivot Table in a new sheet and data from sheet Order

[PCI]

In sheet code

Please Login or Register  to view this content.

in a module put

Please Login or Register  to view this content.

[Winon]

@ PCI,

You are almost there!

Try:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Regards.

[PCI]

Absolutely, full test was not completely done ...!
Thx Winon