Copy row, find in another worbook and paste

[Infish]

Hello Everyone,

Please apologise me for my English in advance, cause it is not my native speech.

I am new here and also a beginner in VBA, so I would like to ask for help.

I am trying to solve a problem to copy exact data in row to another existing workbook. (database)

Lets say column A1 in workbook1 includes the same word as workbook database in (A:A).

I need to find in database this word, and copy the selection from workbook1 (B1:H1) at the same row as this word.

Another issue is I need to paste not in the first free cell, but it have to start copy from column E.

If my explanation is not understandable, please ask or I can create a sample in excel.

Many thanks for any reply.

[Infish]

Please Login or Register  to view this content.

I have no idea how to setup to find the the word in one workbook and paste the selection at the row that includes in first column same word.

Any idea?

[cs454]

If you post an example workbook, it will be much easier to help you.

[Infish]

May I need any special right to post the attachement? Or could you advise me how to proceed?

[cs454]

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[Infish]

Thank you.

I will have many workbooks like source1, source2....

The layout will be same everytime, but with different values and with different name in A column.

I need a button that find the workbook database (N:\database.xlsx) find the same inquiry nr. in column A and paste the raw in appropriate place.

That means, my inquiry nr is FLSAU779 in A2 source1. That macro have to find the FLSAU779 in database (4th raw) and paste.

I hope that the attachement help to understand my issue.

[cs454]

In your source workbooks open a new module and paste the following code

Please Login or Register  to view this content.

Keep in mind this assumes you are only using the first worksheet in 'source', and that every inquiry number is unique.

HTH

[Infish]

Awesome, that works! But do you think, there is possibility to copy, if the database workbook is not open?

[cs454]

You cannot copy from a closed workbook, but you can add a line to open the workbook in your VBA. Something like:

Please Login or Register  to view this content.

[cs454]

Infish,

If I have answered your question please mark the thread as solved, and if I helped please be kind and add reputation in the bottom left of my post

[Infish]

No problem, I will do anything you want if you could help me with last question.

I use everyday the clasic formula, but in VBA I am still noob

What if I little change the layout at database? There will be written minimum 4 columns (see attached file). So the copied text will be inserted to the 5th column (DATE).

Do you think you can change the VBA code for this? And if is possible leave me in VBA note thich values are changeble for this.

An also please implement the code to open database, insert text, save and close the datase. If it is too complicated, implement only open database.

Once again thank you very much!

[cs454]

To insert in 5th column:

Please Login or Register  to view this content.

I have literally given you the code above to open the database, I'm sure you can figure out how to copy and paste.....

As for the rest, google what you're looking for and try it for yourself.

Edit: If you still can't figure it out, come back and show us your attempt. We aren't here to do your work for you, we like to see that you have tried to do it yourself first.

[Infish]

You are right. I told you I am a beginner in VBA, but I will try to understand the code and implement the changes.

Give me the time and I will show you the result.

[cs454]

You are right. I told you I am a beginner in VBA, but I will try to understand the code and implement the changes.

Give me the time and I will show you the result.

Great, even if you can't get it working show us your work and we will help

[Infish]

Seems that works It was't so hard to understand.

Please Login or Register  to view this content.

[cs454]

That's great! And now you have learned to do it yourself

Please mark the thread as solved if you are done!

[Infish]

I am finally done. Thank you very much for your efforts and patience with me. I am little bit smarter in VBA now

[cs454]

I am finally done. Thank you very much for your efforts and patience with me. I am little bit smarter in VBA now

No problem