Hello:
I need to match data in 2 specific columns and align/and add a space/row where needed. Is there a formula or a macro that will do this? I want to match Columns A and F (name match) and align B and G, if no match the cells are shifted down until the next match is found and aligned. I hope this makes sense
Example:
Headers: Name, Item, Qty, etc
A B C D E F G H I
1 Name Item ID Qty Amount _____ Name Item ID Qty Amount
2 AGI DROPSHIP 2.00 20.00 AGI DROPSHIP 3.00 30.00
3 AGI FLT 1.00 24.00 AGI 1338 33.00 1,881.00
4 AGI 1338 36.00 2,280.00 AGI 1438 6.00 342.00
5 AGI EC18 16.00 443.68 AGI 13V-38 3.00 228.00
6 AGI EC24 6.00 166.38 AGI 1354 8.00 864.00
7 AGI EC6 5.00 138.65 AGI BT3E 2.00 39.28
8 AGI G36200 3.00 288.00 AGI DW1117 2.00 178.84
7 AGI GLPD-36 2.00 168.00 AGI DW8511 2.00 89.82
8 AGI IJ-60 1.00 240.00 AGI BLF36 7.00 567.00
9 AGI IMDFB 3.00 144.00 AGI CWV38 7.00 982.80
20 TS BF36 36.00 3,159.00 ADI CAN24 1.00 40.95
11 TS BF50 5.00 610.35 ADI SPP36 2.00 148.20
12 TS BF60 10.00 462.50 ADI TC-50 6.00 192.00
13 TS TC-50 5.00 479.55 ADI FLT 2.00 96.00
14 TS BLF 10.00 1,542.90 ADI SPP42 9.00 504.00
15 TS PRO 2.00 110.00
16 TS SLPB 1.00 60.00
Bookmarks