Hi,
I have an invoice on sheet 1. There are carton numbers listed in the A
column on random rows. The rows that do not have a carton number are blank
in the A column. How can I create a checklist of the Sheet 1, column A
values on sheet 2 with no blank rows on sheet 2? In addition, some of the
carton numbers are 5 or more digits and I want these separated from the 4 or
less digit carton numbers.
Any suggestions would be much appreciated.
--
moviestar