Copying data from one workbook with drop-down options to another workbook

[toaksie]

I am trying to create a macro that will allow me to take data from one workbook and ammend it at the bottom of the other. I am not a programmer and so I have been creating it through keyboard shortcuts however I have hit a particular issue where I get a runtime error 1004 and a message saying application-defines or object defined error. I tried the macro before including the headings of the sheet I was taking data from, but when I try without i.e. starting from the second row it fails. There are drop down menus in a number of cells, if this helps. the code no doubt is messy but looks like this:

Please Login or Register  to view this content.

[arlu1201]

You can actually get rid of all your select and activate statements. Can you specify briefly what data from which file needs to be copied to which file? I can provide you the code or you could alter the following example to suit your needs -

Please Login or Register  to view this content.

This code will copy the data from the book titled "First book", sheet1, range A2:J10 to the workbook titled "Second book", Sheet1, next available row.

[toaksie]

Thanks for the reply

I basically need to take data from a worksheet called "WON" within a workbook called "current", and amend it to the end of a worksheet named "a leads" in a workbook called "ALeads," the idea eventually is to run it to collate individuals results for a month and amend them to the bottom of the main database.

[arlu1201]

Whats the range in WON that needs to be copied?

[toaksie]

The range is strange (I think it's due to drop down options in many of the cells). When I select the area it simply goes blank however if I see it manually it is A2:T9 although this will change on a month by month basis depending on the number of entries

[arlu1201]

You can first find which is the last row. Use this -

Please Login or Register  to view this content.

[toaksie]

Thanks so much for your help, being a real newb what are the dim statements, the previous post you made?

[arlu1201]

Sorry, i cant reply to you till you change your title as per the admins request - post 7.

[toaksie]

I've changed it now sorry all!

[arlu1201]

At the beginning of your code, you need to put the DIM statements which are used to declare the variables you are using. Just below the sub test(), you can put the DIM line.

[toaksie]

I'm getting an error that '9' Subscript out of range:

Please Login or Register  to view this content.

[arlu1201]

Why are you using the copy code twice? All you need is this -

Please Login or Register  to view this content.

I missed out some ".", have included those here.