I am trying to automate my first VBA macro. It is the printing of the current sheet (SHEET2) based on a VLOOKUP value on another sheet (SHEET1). If the value is 0 then move to the next record on SHEET1 until no more records. I can perform the lookup no problem but then I am having trouble formatting the IF statement.
SHEET2 is an empty form that would be populated with data calculated based on the returned value from SHEET1
Can anyone assist me?
SHEET2 is an empty form that would be populated with data calculated based on the returned value from SHEET1
Can anyone assist me?