VBA code to Hide or Delete Rows

[mgchurch77]

Description of the worksheets:

For simplicity sake I'll describe my workbook as only having two worksheets.

A "source" worksheet and a "destination" worksheet. The "source" worksheet consists of column A which are names of customers and column B consists of the result of a calculation fusing data from other sheets which could be any number from 1-12.

The "destination" sheet has a certain cell (we'll call that the target cell) where the user "me" can input a number from 1-12. Column A of the destination page matches the number from the target cell to column B of the source page to determine whether or not to pull the customer name from column A of the source page into column A of the destination page. If the number from the target cell matches column B of the destination page, the name is pulled, if there is not a match the answer returned is false.

Code needed:

The code would run on the destination page as outlined above. What I need it to do is to hide the rows where the answer for that certain row in column A of the destination page is "false". Thanks in advance for anyone's help.

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=576229

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).