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

[lukerogers1987]

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

[lukerogers1987]

Also meant to say, I need the Amount Outstanding to be lifted from the Prototype sheet into the mailmerge sheet also.

On my copy now I have as mentioned above inputed a fourth sheet to distinguish between the ODL and FDL letters. Sheets are now called ODL mailmerge and FDL mailmerge.

I will need to somehow incorporate the date the letter has been sent i think

[pcgeek]

Hello there.

I've been having a good look through your post all day today, I've been racking my brains. I've passed it on to all my friends to see if they could assist me with your issues too.

But unfortunately, on this occasion, none of us are able to assist you I'm afraid.

I shall endeavour to offer any help I can with any of your future posts though.

Regards
PC Geek

[lukerogers1987]

Ah ok thanks very much, do you think it will be possible? :S

[lukerogers1987]

Anyone have any ideas?

[pcgeek]

Morning,

I've had another look into your problem overnight and I've got some good news for you!

I say good news in that I think I've saved you a lot of time and effort in working on this. Having explored all avenues over a number of black coffee's last night I have eventually come to the conclusion that I can't foresee any way of achieving what you are looking to do. Furthermore I would suggest that you look at working on a much more basic scale rather than continuing needlessly or even give up on the idea.

Hope this helps you.

PC Geek