Hello once again, hoping to get some help, and hoping I could explain things better for you guys.
I'm going to have a variable range such as the one below.
On Sheet 2 I will have relevant order information such as the one below.
Now here is a simplified version of what I would like to accomplish.
I'm going to have a larger customers list( 2-3k rows) and essentially I would like to find the most efficient way to get excel to look at "sheet2" find the match and insert extra columns such as above where the digit "2" was added to primary orders. Digit 3 was added to Secondary orders and Digit 4 was added to the extra orders.
Would you guys suggest a macro for this or should I be looking at some formulas. Any help in getting started would be helpful.
I'm going to have a variable range such as the one below.
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Customer Orders | Address | Phone # | Delivery Method | |||||
2 | John Doe's Order | 127 Go MrExcel | 123-456-7894 | Next Door Neighbor | |||||
3 | Jack Hanma's Order | 123 Send Help | 123-456-7890 | In person | |||||
4 | John Hanma's Order | 124 Please Help | 123-456-7891 | Front Door | |||||
5 | Joe Hanma's Order | 125 I Mean it | 123-456-7892 | Mailbox | |||||
6 | Jane Hanma's Oder | 126 You Rock | 123-456-7893 | In Person | |||||
7 | |||||||||
8 | |||||||||
9 | |||||||||
10 | |||||||||
11 | |||||||||
12 | |||||||||
13 | |||||||||
14 | |||||||||
Sheet1 |
On Sheet 2 I will have relevant order information such as the one below.
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Customer | Number | ||||
2 | Jack Hanma | 10001 | ||||
3 | John Hanma | 20001 | ||||
4 | Joe Hanma | 30001 | ||||
5 | Jane Hanma | 40001 | ||||
6 | John Doe | 50001 | ||||
7 | Jack Doe | 60001 | ||||
8 | Jane Doe | 70001 | ||||
9 | Jose Doe | 80001 | ||||
10 | ||||||
11 | ||||||
12 | ||||||
13 | ||||||
14 | ||||||
Sheet2 |
Now here is a simplified version of what I would like to accomplish.
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Customer Orders | Address | Phone # | Delivery Method | Primary Order | Secondary Order | Extra Orders | |||
2 | John Doe's Order | 127 Go MrExcel | 123-456-7894 | Next Door Neighbor | 500012 | 500013 | 500014 | |||
3 | Jack Hanma's Order | 123 Send Help | 123-456-7890 | In person | 100012 | 100013 | 100014 | |||
4 | John Hanma's Order | 124 Please Help | 123-456-7891 | Front Door | 200012 | 200013 | 200014 | |||
5 | Joe Hanma's Order | 125 I Mean it | 123-456-7892 | Mailbox | 300012 | 300013 | 300014 | |||
6 | Jane Hanma's Oder | 126 You Rock | 123-456-7893 | In Person | 400012 | 400013 | 400014 | |||
7 | ||||||||||
8 | ||||||||||
9 | ||||||||||
10 | ||||||||||
Sheet1 |
I'm going to have a larger customers list( 2-3k rows) and essentially I would like to find the most efficient way to get excel to look at "sheet2" find the match and insert extra columns such as above where the digit "2" was added to primary orders. Digit 3 was added to Secondary orders and Digit 4 was added to the extra orders.
Would you guys suggest a macro for this or should I be looking at some formulas. Any help in getting started would be helpful.