I have a super long worksheet on excel (50 pages) that is a price sheet for
labor and materials. It is fairly simple (6 columns including description,
quantitiy, price and notes). For each job that i use it for, I only use about
75 individual rows out of the total 50 pages. I would like to be able to only
print the rows that i am using for that individual job. In other words, I
only want the rows to print that have a number in the quantity column. How do
I create an if then statement that prints the row if a number is in the
quantity column and apply it to the whole spreadsheet?
Thanks VERY much in advance for your help!
Cassie