Guys help me find the most efficient way to retrieve and insert information. Macro or Formula?

[Coyotex3]

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.

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.

 

[gitmeto]

To clarify, is seems as though you are trying to group all of the orders based on the name of the customer? If so, it seems like this is a task for Power Query. You would need to add the tables to the data model and while I haven't tried it, it seems as though you could pivot on the customer name and then add a custom function column that adds the extra digit. However, this would be the easiest and would not require any macros, and a simple formula of adding 1 for each column from the primary order, secondary order, etc.

 

[Coyotex3]

To clarify, is seems as though you are trying to group all of the orders based on the name of the customer? If so, it seems like this is a task for Power Query. You would need to add the tables to the data model and while I haven't tried it, it seems as though you could pivot on the customer name and then add a custom function column that adds the extra digit. However, this would be the easiest and would not require any macros, and a simple formula of adding 1 for each column from the primary order, secondary order, etc.

Thank you I will give this a try and see how it goes.