pcarmour
01-08-2013, 02:14 PM
Hi,
I have a large database named 'Holdings' with over 26,000 rows.
Then I have about (a changing number) 200 rows of data in columns K-N.
My task is to find and match the CLT REF in Column K with the CLT REF in Column A, Then find and match the ISIN in Column L with the ISIN in Column C.
Once both fields have matched I need to copy the data from the relevant row columns M and N and paste this data into Columns F and G of the matched Row. Please see attached with CLT REF's 1141, 2498 and 2705 as an example of how it should look.
Any help would again be very much appreciated.
I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)
I have a large database named 'Holdings' with over 26,000 rows.
Then I have about (a changing number) 200 rows of data in columns K-N.
My task is to find and match the CLT REF in Column K with the CLT REF in Column A, Then find and match the ISIN in Column L with the ISIN in Column C.
Once both fields have matched I need to copy the data from the relevant row columns M and N and paste this data into Columns F and G of the matched Row. Please see attached with CLT REF's 1141, 2498 and 2705 as an example of how it should look.
Any help would again be very much appreciated.
I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)