I am trying to create a spreadsheet that will be used for billing purposes.
Part of the print out page needs to show equipment used for the job. On
another tab I have the list of all of my available equipment. When I begin to
create the bill I want to go to the tab that lists all of my equipment and
hourly rates and either put a "Y" or "n" or somehow note which items were
used in this case. I then want to be able to go back to my main sheet (the
one to be printed) and see in my equipment section, only the pieces used and
not all of the other ones. I have been able to get the active pieces of
equipment to display using if statements but I want to delete the rows
automatically which are left blank due to the IF statement. Is this possible?