Printing Only Rows With Values

[FourNines]

I am currently using a simple Excel workbook with 3 sheets. One sheet is called Quote, the other Receipt and the final one is my customer list that I have named Clients.

On my order sheet, I have a list of 25 items (on separate rows with pricing) that I regularly purchase from my clients. I am in the metal recycling business so on this "Quote" sheet I have 4 grades of copper scrap, 3 grades of aluminum scrap, 6 grades of iron, etc. When a customer comes in, I use a drop down menu in the Quote sheet to bring up the customer info and populate the customer's info from the Client sheet. I then proceed to enter the quantity of different scrap that they have brought in and use the Quote sheet to figure what I will pay for the scrap. If the customer agrees, I click over to the Receipt sheet and print out the receipt that I have designed using the data from the Quote sheet. The receipt shows weight, type of scrap, price per pound, total per item and grand total.

My problem comes when I print. My Receipt sheet looks identical to my Quote sheet except it has my company name at the top and logo. All 25 rows with the different types of scrap are on there (and being printed) whether they are part of that particular purchase or not.

My question is, using the descriptions and pricing from my Quote sheet, how can I populate my Receipt with just the items that I am purchasing instead of all 25? In other words, if the quote has only 3 items one it, I want to just print those 3 items with their corresponding data.

I appreciate the help.
Thank you,
Joe

[Palmetto]

Hi Joe,

You should upload a sample workbook (fake the data) that is duplicate in structure of the real workbook and show an example of the desired output (use another sheet if necessary to show a "before" and "after" example so it is clear to those who will help with the solution.

Depending on the workbook, it may just be a formula solution. If VBA is required, is that an option for you?

[dangelor]

Possibly running this code before printing...

Please Login or Register  to view this content.

[FourNines]

Thank you for taking the time to answer my question. I have uploaded a similar workbook.

Scrap Quotes.xlsx

[dangelor]

I took the liberty of reformatting the receipt to accommodate the code I wrote for populating the form.

Please Login or Register  to view this content.

[FourNines]

dangelor,
That's perfect. I really appreciate the time you took to solve my request. Kudos!
Regards,
Joe

[dangelor]

Glad I could help. Enjoy the season!