smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
In Sheet1 (starting from row3, A-X columns) I have a data summary (product's mark and product's prices) and Sheet2 is only for the raw data.
Product's mark is characteristic which contains one to six letters (always to the left of price).
I need a Macro to copy/append data from Sheet2 to Sheet1 in an appropriate column (based on identical products columns). // something like hlookup function in macro
Also, I need to remove (if there are) duplicates based on mark columns (cells which already contains the same marks as marks in Sheet1).
Example.
Sheet1 (before update)
<tbody>
</tbody>
Sheet2 (obtained new "raw" data)
<tbody>
</tbody>
Sheet1 (after update/append from Sheet2, with removed duplicates/same dates)
<tbody>
</tbody>
Product's mark is characteristic which contains one to six letters (always to the left of price).
I need a Macro to copy/append data from Sheet2 to Sheet1 in an appropriate column (based on identical products columns). // something like hlookup function in macro
Also, I need to remove (if there are) duplicates based on mark columns (cells which already contains the same marks as marks in Sheet1).
Example.
Sheet1 (before update)
A | B | C | D | E | F | ... | |
1 | |||||||
2 | |||||||
3 | Product1 | Product5 | Product4 | ||||
4 | a | 13 | b | 21 | s | 11 | |
5 | b | 8 | f | 16 | pq | 31 | |
6 | c | 12 | rd | 11 | |||
7 | w | 9 |
<tbody>
</tbody>
Sheet2 (obtained new "raw" data)
A | B | C | D | E | F | ... | |
1 | |||||||
2 | |||||||
3 | Product4 | Product1 | Product5 | ||||
4 | w | 12 | b | 10 | f | 18 | |
5 | d | 34 | c | 13 | g | 31 | |
6 | e | 28 | |||||
8 | .... | .... | .... |
<tbody>
</tbody>
Sheet1 (after update/append from Sheet2, with removed duplicates/same dates)
A | B | C | D | E | F | ... | |
1 | |||||||
2 | |||||||
3 | Product1 | Product5 | Product4 | ||||
4 | a | 13 | b | 21 | s | 11 | |
5 | b | 8 | f | 16 | pq | 31 | |
6 | c | 12 | g | 31 | rd | 11 | |
7 | e | 28 | w | 9 | |||
8 | .... | ..... | d | 34 | |||
9 | .... |
<tbody>
</tbody>
Last edited: