Hello Again,
I am looking for a VBA Macros where I can compare the data and apply formula until last row.
Example:
Look for Item code from column B in column G and if the code match then go for another item code within the same column.
If the code not found within the same row in column G then insert 3 cells i.e. column B, C & D until the item code match in column G.
The scenario is vice versa.
I am looking for a VBA Macros where I can compare the data and apply formula until last row.
Example:
Look for Item code from column B in column G and if the code match then go for another item code within the same column.
If the code not found within the same row in column G then insert 3 cells i.e. column B, C & D until the item code match in column G.
The scenario is vice versa.
Excel 2012 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | List 1 | Item Code | Item Description | Price | Price % (+) | List 2 | Item Code | Item Description | Price | ||
2 | Old List | Not In Old List | New List | 1159 | Description - 102 | 16 | |||||
3 | Old List | Not In Old List | New List | R-031 | Description - 106 | 33 | |||||
4 | Old List | AMT001 | Description - 001 | 100 | 200.00% | New List | AMT001 | Description - 001 | 300.00 | ||
5 | Old List | AMT002 | Description - 002 | 100 | 300.00% | New List | AMT002 | Description - 002 | 400.00 | ||
6 | Old List | AMT003 | Description - 003 | 200 | 650.00% | New List | AMT003 | Description - 003 | 1500.00 | ||
7 | Old List | AOT006 | Description - 004 | 900 | 0.00% | New List | AOT006 | Description - 004 | 900.00 | ||
8 | Old List | AOT007 | Description - 005 | 300 | 0.00% | New List | AOT007 | Description - 005 | 300.00 | ||
9 | Old List | AOT008 | Description - 006 | 100 | 0.00% | New List | AOT008 | Description - 006 | 100.00 | ||
10 | Old List | Not In Old List | New List | DRT001 | Description - 100 | 85.00 | |||||
11 | Old List | Not In Old List | New List | DRT001 | Description - 100 | 85.00 | |||||
12 | Old List | DRT002 | Description - 007 | 155 | 0.00% | New List | DRT002 | Description - 007 | 155.00 | ||
13 | Old List | Not In Old List | New List | DRT002 | Description - 007 | 155.00 | |||||
14 | Old List | DRT003 | Description - 008 | 180 | 0.00% | New List | DRT003 | Description - 008 | 180.00 | ||
15 | Old List | Not In Old List | New List | DRT003 | Description - 008 | 180.00 | |||||
16 | Old List | DRT004 | Description - 009 | 150 | 100.00% | New List | DRT004 | Description - 009 | 300.00 | ||
17 | Old List | Not In Old List | New List | DRT004 | Description - 009 | 300.00 | |||||
18 | Old List | DRT005 | Description - 010 | 320 | 0.00% | New List | DRT005 | Description - 010 | 320.00 | ||
19 | Old List | Not In Old List | New List | DRT005 | Description - 010 | 320.00 | |||||
20 | Old List | DRT006 | Description - 011 | 500 | 0.00% | New List | DRT006 | Description - 011 | 500.00 | ||
21 | Old List | Not In Old List | New List | DRT006 | Description - 011 | 500.00 | |||||
22 | Old List | LBT227 | Description - 012 | 240 | 0.00% | New List | LBT227 | Description - 012 | 240.00 | ||
23 | Old List | LBT232 | Description - 013 | 110 | Not In New List | New List | |||||
24 | Old List | LBT235 | Description - 014 | 300 | 0.00% | New List | LBT235 | Description - 014 | 300.00 | ||
25 | Old List | PH-1 | Description - 016 | 0 | Not In New List | New List | |||||
2 |