Receipt Generation

**narrowgate88** · 09-18-2009, 03:05 PM

In the attached file, I want to have the user select a receipt # and have it copy the information, for that receipt from the log, to the receipt tab. Then I want it to print the receipt. The macros that are in the file already, were created before I added a column for Receipt No., and don't ask for user input. File is attached.

**Leith Ross** · 09-18-2009, 06:02 PM

Hello narrowgate88,

I have added the macro shown here to the attached workbook. The macro is called when you click "Print Receipt".

Please Login or Register  to view this content.

**royUK** · 09-19-2009, 04:34 AM

Why use code when this can be doen with a Data Validation list, VLOOKUP & a couple of Dynamic named Ranges

**narrowgate88** · 09-21-2009, 09:44 AM

Both of these suggestions work. I personally like the macro better in this case because it's easier for the end user. Less steps to get the end product they are looking for.

Thanks much!

**dilipchallani** · 01-31-2011, 02:02 PM

hello guys...

i need the solution for this.

i have two excel sheets

1.contains the actual method procedure to work with
2.contains the receipt which is needed to be changed as per it displays.

pls provide the soluting asap. am in need of it

thanks