I made a spreadsheet I use as an order form. The first sheet is the order form where I enter in quantities but instead of printing out the whole invoice which makes it difficult to pull the items from the shelf, I made a second sheet named "Print" that mirrors the "Invoice" sheet but only displays the cells that have quantities entered. The problem I would like to fix is on the "Print" sheet there many empty cells. Is there a way to fetch the data from the "Invoice" sheet but consolidate it so it only takes up as many cells as there is data for? If there are 20 items entered, then it would be a list with 20 rows, 1 for each item. Attached is the file so you can better see what i'm talking about. The third sheet titled "Objective' is the goal i'm trying to achieve. Thank you.
Bookmarks