Macro which copies data into an invoice if values are true

[Chihiro]

Hello
I'm doing a project and I have come across a problem I cant fix no matter how hard I try. I have been fishing around for answers but I don't know what I'm doing that keeps mucking them up!

So what I need is for items that have been ordered to be pasted into an invoice. However, I need them to only be pasted if the value is true.
I cant attach the spreadsheet to this because its too large so please let me email it to you if you can help me

I want the rows that are true within the 'Order Summary' sheet (B7:F51 < data) (H7:H51 < column in which it says True) to be pasted into the 'Invoice' in the correct area (rows B21:F21 and so on), which I cant seem to do, so can anybody help me with this please!

Many many thanks in advance!

[rscsmith]

Hi Chihiro

Try this:

Please Login or Register  to view this content.

Let me know if it doesn't work, in which case I'll PM you my e-mail address and you can e-mail the sheet to me.

Cheers, Rob.

[Chihiro]

Oh my it worked just perfectly! :') Thank you so so much Rob! I really appreciate it!