Marco that can quickly generate / print receipts from spreadsheet

Do you want to generate a receipt for all the Paddle numbers in column F of the Silent Auction sheet all at one go?

Try the attached file. I have made some changes I hope will work for you. You will notice 2 new tabs. One is a blank receipt template. The other holds the Paddle numbers used for the drop down in B7 of the Receipts sheet. On the Receipts sheet, when you select a Paddle in cell B7, the receipt will be populated automatically. Then you can click the "Print Single Receipt" button to print that one receipt. If you click the "Print All receipts" button, a receipt will be created and printed for all the Paddles listed in Silent Auction sheet. If you want to test the macros before printing, comment out the "Printout" line of code in the "PrintAllReceipts" macro.

This is perfect. You even cleaned up some stuff outside of the receipt printing. Thank you so much!!!!

PS when selecting someone who did not participate, a message pops up saying so. How do you go about editing the message's contents?

Also instead of having a seperate "Paddles" sheet, would it just be possible to have the dropdown running off the paddle numbers from the "Guests" sheet?

You are very welcome. To change the message, right click on the tab name "Receipts" and click "View Code". You will see the current message near the bottom of the macro. Change the text between the quotes to suit your needs. You can do away with the "Paddles" sheet by changing the reference in the data validation for cell B7 to the range in the "Guests" sheet.

Can you clarify in more detail what you mean by "when I change to paddle #s"?

I'm sorry but I still don't follow. When you select a Paddle from the drop down in B7 of "Receipts", the sheet is populated with the data for the chosen Paddle. What changes are you making? Please be specific referring to specific cells. When you say " it doesn't change all of them", what do you mean by "all of them"?

Another issue that I found was that when "Print All" is selected, it generates a sheet for the receipt for every paddle number. Is there any way to get rid of this?

Secondly, when print all is selected, the "winning bid" column is cut off, so it prints out 2 pages per receipt. This does not happen when Print Selected is pressed however.

Try the attached file.

Delete the desired rows and if you need to re-format the cells, just do so on the "Receipts" sheet and "Blank Receipts" sheet. Replace the previous 2 macros with these and save the file.

Please Login or Register  to view this content.

In the worksheet code module, delete this line:

Please Login or Register  to view this content.

In the "PrintAllReceipts" macro, delete this line:

Please Login or Register  to view this content.

Just right click on the row number on the left and click "Delete" on the menu that pops up.

Try the attached file.

You are very welcome. I forgot to mention that you should avoid merged cells at all cost because they create havoc for Excel macros.

What dummy info are you changing (in which cells)?

What does not change when you select PRINT ALL?

I don't follow. I ran the "PrintAllReceipts" macro and stopped so I could see the receipt for Paddle 107 and it displayed exactly as the "Blank Receipts" sheet with the data starting in row 19. What do you mean by the "dummy version"? There is nothing in the macro to link your non-dummy file to the dummy file so I don't see how anything that you change in the non-dummy version reverts back to the dummy version.

Is it working properly now?

My pleasure.