Hi all,

I'm new to VBA so bare with me. What I need to do is access data from multiple user workbooks which will have the format "name_position" and a sheet named "won" where the data to be copied will be. I then need to paste this to a Workbook named "ALeads" on a worksheet called "leads" However the the data will be updated each month and so copying all the data and pasting will cause a lot of dupes. I would like to check for duplicates in a column named "Company" on the main workbook "Aleads" and avoid pasting if it already exists. Another possible solution is to make the selection based around date but this is going to change month by month, unless there is an option box that could allow the input of the month required (a field that we have in all data sets), before the macro ran. Any help much appreciated,

Thanks,

Tom