So I have 2 work sheets. On sheet 1 column A if it is filled out then a few column A cells are skipped then another column A cell is filled, on sheet 2 they won't skip rows. This was obtained by an INDIRECT formula. Now what I'm wanting is any information added to the B cells of sheet 1 that are...