Insert a row into an excel tab from another excel tab

Hi,
I have struggled with this to make it work. I did not create the excel sheet it was given to me already done.

If this is not clear please let me know.


the excel sheet with 2 tabs.

one tab contains the following fields (name, dob, ID, dis, nurse, art)
The other tab has fields ( Name, dob, Id, dis, nurse, Ven)

they're same except one has column art and one has Ven

I want to take the field Ven from tab 2 and insert it in tab 1 next to Art using the ID as away to match the patient.

here is an example:

Tab1

Name Dob ID Dis Nurse Art
X xxx 1x NC F 7.28
X xxx 1x NC F 7.24
B bb 1b C m 5.2
c cc 1c N m 6.2
c cc 1c N m 9

Tab2

Name Dob ID Dis Nurse Ven
X xxx 1x NC F 7.30
X xxx 1x NC F 7.01
B bb 1b C m 8.11
c cc 1c N m 1.2

The final result will be:

Name Dob ID Dis Nurse Art Ven
X xxx 1x NC F 7.28 7.30
X xxx 1x NC F 7.24 7.31
B bb 1b C m 5.2 8.11
c cc 1c N m 6.2 1.2
c cc 1c N m 9

Thanks in advance

You do not need a macro for this.

You can use a vlookup.

In tab 1, enter Ven in G1. Then in G2 put this formula which you can drag down to the rest of the column.

Formula:

Please Login or Register  to view this content.

Yes, Ven in G1 is the header.

I didnt know that you have more columns of data. You can put the column at the end of the data and use the vlookup.

Try researching for it in google and you will get a lot of helpful links on vlookup. Its a very commonly used function and very useful too.

Hi, have a look at the following thread I created for the July competition. It will give you some ideas of how to use vlookup. If you need a more basic explanation of vlookup, MS has a good description here, and techonthenet`s explanation is here. This was one of the first functions I truly fell in love with.

Let me know if you have any trouble implementing it.

Good luck.

abousetta