Select mutiple entries and copy matching cells onto Invoice sheet

[Yorksboy]

I'm trying to find some code which will seach down column A on 'Invoice Data' sheet for a particular reference number (may be multiple occurances) and then copy the corresponding values from columns D, E, F & G on to the invoice template.

In the first instance, the reference number will be selected by the user, but my aim eventually, is to enter a date and for Excel to produce the invoices for all order references on that date.

Any help would be appreciated.

Example attached.

[peterjuhnke]

Hello Yorksboy
Were did you want the search number to go?
Can you give an example please
Regards
Peter

[Marcol]

This basic code might give you a starting point

Please Login or Register  to view this content.

Assign this to your button.

Click on the invoice number you want to print on the Inputbox prompt

Hope this helps

[Yorksboy]

Peter,

The search number is purely used to select which rows needs to go onto the invoice, so you could say that it's a temporary variable.

[Yorksboy]

Thanks Marcol,

That's certainly got me started.

regards,

Mark

P.S. Just had a thought, this will work OK as long as as I don't have too many tickets for one order ref!

This basic code might give you a starting point

Please Login or Register  to view this content.

Assign this to your button.

Click on the invoice number you want to print on the Inputbox prompt

Hope this helps