An Excel Macro To Find match & Copy Rows IN COLUMN

November 5, 2017 at 01:54:34
Specs: Windows 8
HI,
I have an excel sheet with numbers in column A1 , column B1 , column c1 up to column p1
like this
500 1000 2000 3000 etc..
and i have a table with numbers in rows starting at AA1 ,AA2 , AA3 like this

AA1....: AB1......AC1...........AD1
25..........30.........40.............60 ......... ...500... 60...... 2000
AA2.... AB2...... AC2.............AD2
50.........60...........70...........1000 .........500.....60........ 70....... 3000
AA3.....AB3.........AC3...........AD3
70..........80...........90..........3000........2000.... 90......... 80

i need a macro that would search and match the
numbers in column A1 B1 C1 with each ROW in the table starting at AA1 UP to AA15 and paste the remaining numbers from the row that as the matching number under the column A1, B1 C1
for example the result would be

A1........................... B1 ..................C1
500....................... 1000 ...............2000
-----------------------------------------------------------
25.............................50..................25
30................... .........60 .................30
40...... ......................70 ................40
60............................500.................60
60........................... 60..................500
2000... ................... 70...................60
50 ........................3000 .................70
60..................................................80
70...................................................90
1000............................................3000
60..................................................90
70..................................................80
3000.....................................................

Column A1 500 is this way Because 500 is found in row AA1 and row AA2

message edited by Ricky777


See More: An Excel Macro To Find match & Copy Rows IN COLUMN

Reply ↓  Report •

#1
November 5, 2017 at 05:02:50
First, a posting tip:

Please click on the How-To link at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.

Thanks!

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question