Code Required To Use Condition To Copy Data From Different Worksheets Into Another Sheet

Hello guys,

I'm new here, really really could do with a hand. I am trying to create a new debtors for the company I work for. Any help would be really appreciated, The workbook basically has three sheets.



1 - Prototype is the list of the current debt overdue

2- Mailmerge, a list of customer data for what letters need sending which will be used to transfer into mailmerge in word

3- Customer List, file containing details of all customers names and addresses.

On the prototype sheet there are two columns called odl and fdl sent, these are tick box's and i basically need code sorting out so that when these are ticked the code looks at that row for the company name, then gets the data from sheet three (company list) for that company, i.e the address etc and copies it onto the mailmerge sheet.

Another problem is i need to distinguish between the fdl and odls being sent I may possibly need to input a fourth sheet and label the mailmerge sheets ODL mailmerge and FDL mailmerge.

And another issue is that I will be adding to the number one sheet each month so that there will eventually be January - December sheets and not just one called prototype so not sure if this will cause a problem with the coding as obviously i do not want the mailmerge picking up old data from previous months.

I have included a copy of the workbook and one of the mailmerge word docs i will be using.

As i said i know this is a bit messy really but i've hit a brick wall and any help would be great.

Cheers Guys,

Luke