How to copy data from one workbook to a specific worksheet of another workbook

Hi all,

I have tried a lot and could not achieve what i want. Need some help with this.

I have a sheet named sheet9 and i want to copy the data from this workbook-sheet9 to a workbook called importdata and sheet named "database".

Please Login or Register  to view this content.

The above code prepares a sheet9 which i want. Now i need to copy this sheet9 to thisworkbook(workbook which contains macro) sheet database

Can any one help me?

Maybe:

Please Login or Register  to view this content.

You would have to change your references to reflect the variable you're using.

ie.

Please Login or Register  to view this content.

In your code I don't see a workbook or sheetname for the destination.

Please Login or Register  to view this content.

Note: I used file extension ".xls" you may need ".xlsm" or ".xlsx"

Originally Posted by VidyaVallaba

Thanks for replying but it gives over writes when i perform the above for more than 1 file!!

How can i find the next empty row a paste the values?Please help me i have been working on this since many days cant find a way out

For your destination:

Change this:

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

I am using this

Please Login or Register  to view this content.

problem with this is if only one column is matched then it gives error while copying.
Error is the destination does not match the copied range.