Hello,

I have recently started working with VBA, but I'm still pretty new to it. I need some help writing a code that copies a range of values from one sheet to another, but I only want to return the values that have the following criteria:
  1. The cells from the first sheet must be visible
  2. There must be a value (The number "1" for example) in a different column within that row.

Input Page.JPGOutput Page.JPG

I have attached an example of what I am trying to achieve. I would want to select the range shown on the input sheet, and copy/paste the correct values from columns "B" and "C" (from the input page) onto the output page as shown. Note that the values in row #3 wouldn't be copied because they're hidden. The values in row #4 wouldn't be copied either, because there isn't a number 1 in column "A". Any help would be greatly appreciated.