Loop thru rows to copy to another excel spreadsheet
 

Hi everyone. I don't usually deal too much in excel so please excuse
the lack of knowledge. I have a spreadsheet with a fixed number of
columns and a variable for the number of rows. I have added a checkbox

to each row. The check boxes are in column "A"

All I want to do is --- to loop thru each row and If there is a value

in column "B" and the CheckBox in column "A" is true, I want to copy
that entire row from sheet1 to sheet2. If column "B" has no value
(null) then drop out of the loop. I would suppose for someone who
knows their way around excel and VB this doesn't seem very difficult
but I do not have a clue.


Any help would be appreciated.