Exporting data to a different worksheet database

[namialus]

Hi all,

I'm need your assistance for following problem,
I need to export (for example) data from cell = BI25:BM43
to other database file (for example) = Database.xlsx (in the same directory or folder).
The every new data i'm exporting , new line will be created.

Thank you

[natefarm]

I'm a little vague on some specifications (How do you designate which range you want copied? Which sheet in the database should it go in? Where should it go in the sheet? Do you want the db saved and closed?) so I made some assumptions. Adjust as needed, or let me know.

Select the range you want copied, and run the code. In the database, Sheet1, it will go to the bottom of the first column you selected and copy it there.

Please Login or Register  to view this content.

[namialus]

dear natefarm,
The range i want to copy are the value result of an inspection (in vertical)
The database shall start from cell A1 in sheet 1 and in horizontal condition.
And yes i want the db to be saved & closed.

I did run the code but i need the data start in cell A1
then, the 2nd time running in A2

thanks for your help

[natefarm]

Ok, try this:

Please Login or Register  to view this content.

[namialus]

Dear natefarm,

Thank you for your assistance, but the result come out as "#Ref!".
FYI, the selection range comes from different cell & not in order.
And I would appreciate it if you can assist me to make the result comes out in rows
and not in columns.

Pardon me for my English.

Thanks again :-)

[namialus]

Dear natefarm,

I have this vb script from my other workbook, but it copy from worksheet to worksheet in same workbook.
Can you assist me for this worksheet to workbook topic?

Please Login or Register  to view this content.

Thanks again

[natefarm]

If that code does what you want, other than copying to a different workbook, then just change the following line:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

It requires Database.xlsx to already be open, and then you run the code and save and close manually, but that's it. You could add the code to do that part if needed.

[namialus]

Thank you natefarm for your help