you could sort by that column with the numbers, blanks would go to the bottom

"Keeter" wrote:

I have 2 workbooks. One I log in soils and plants with for different tests.
I click on generate labslips (macro) and it opens another workbook that
lists all the corresponding numbers with the test that I do. When I look at
labslips I could have 25 plants in a row for a NO3n test but then it will be
blank for maybe 15 or 20 spaces until my next set of numbers come. How do i
write a formula or macro that will get rid of empty spaces so i don't waste
alot of paper? Thanks for any Information or help.
Keith