hi
I have this data in sheet1
sheet2 before result
and expected result in sheet2
so it should copy theses values are in sheet1 (b5,d4,f5) to sheet 2 repeatedly in COLS (A,B,G) based on what filled in COL C
I have this data in sheet1
1.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ||||||||
2 | INVNO | |||||||
3 | QW12 | |||||||
4 | date | CUSTOMER | ||||||
5 | 01/01/2021 | ASD1 | ||||||
6 | ||||||||
7 | ||||||||
SHEET1 |
sheet2 before result
1.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | ITEM | DATE | COMMEDITY | MADE IN | INV NO | PR | CUSTOMER | ||
2 | 1 | AA-12 | CHI | ASS1 | |||||
3 | 2 | AA-13 | JAP | ASS2 | |||||
4 | 3 | AA-14 | THI | ASS3 | |||||
5 | 4 | AA-15 | TR | ASS4 | |||||
SHEET2 |
and expected result in sheet2
1.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | ITEM | DATE | COMMEDITY | MADE IN | INV NO | PR | CUSTOMER | ||
2 | 1 | 01/01/2021 | AA-12 | CHI | QW12 | ASS1 | ASD1 | ||
3 | 2 | 01/01/2021 | AA-13 | JAP | QW12 | ASS2 | ASD1 | ||
4 | 3 | 01/01/2021 | AA-14 | THI | QW12 | ASS3 | ASD1 | ||
5 | 4 | 01/01/2021 | AA-15 | TR | QW12 | ASS4 | ASD1 | ||
SHEET2 |
so it should copy theses values are in sheet1 (b5,d4,f5) to sheet 2 repeatedly in COLS (A,B,G) based on what filled in COL C