Hello
I want to copy the data of a sheet containing an error mark and ignoring a valid mark based on column D with the same formats.
with a note that the update in the output sheet must be based on the update in the input sheet when the code is run every time without duplicating copying the data that has already been copied , but if The data was changed in the input sheet, which was previously copied to the output sheet, then it is changed in the output sheet.
before
after
note : XL2BB tool doesn't show tick right, wrong
I want to copy the data of a sheet containing an error mark and ignoring a valid mark based on column D with the same formats.
with a note that the update in the output sheet must be based on the update in the input sheet when the code is run every time without duplicating copying the data that has already been copied , but if The data was changed in the input sheet, which was previously copied to the output sheet, then it is changed in the output sheet.
before
CO.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ITEM | BRAND | QTY | CONDITION | RESULT | ||
2 | 1 | 15W40 12x1L | 18 | ü | 0 | ||
3 | 2 | 10W40 12x1L | 40 | û | 39 | ||
4 | 3 | 10W40 4x5L | 11 | û | -11 | ||
5 | 4 | 10W40 4x1L | 9 | ü | 0 | ||
6 | 5 | 5W40 4x6L | 4 | û | -40 | ||
7 | 6 | 5W40 4x4L | 4 | û | -16 | ||
8 | 7 | 5W40 4x5L | 45 | û | -5 | ||
9 | 8 | 20W50 4x4L | 8 | û | -1 | ||
10 | 9 | 10W40 208L | 1 | û | -54 | ||
11 | 10 | 15W40 208L | 33 | û | 13 | ||
12 | 11 | 5W30 208L | 21 | û | 11 | ||
13 | 12 | 5W30 12x1L | 10 | ü | 0 | ||
14 | 13 | 20W50 4x1L | 4 | û | 4 | ||
INPUT |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2:D14 | D2 | =IF(E2=0,CHAR(252),CHAR(251)) |
after
CO.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ITEM | BRAND | QTY | CONDITION | RESULT | ||
2 | 1 | 10W40 12x1L | 40 | û | 39 | ||
3 | 2 | 10W40 4x5L | 11 | û | -11 | ||
4 | 3 | 5W40 4x6L | 4 | û | -40 | ||
5 | 4 | 5W40 4x4L | 4 | û | -16 | ||
6 | 5 | 5W40 4x5L | 45 | û | -5 | ||
7 | 6 | 20W50 4x4L | 8 | û | -1 | ||
8 | 7 | 10W40 208L | 1 | û | -54 | ||
9 | 8 | 15W40 208L | 33 | û | 13 | ||
10 | 9 | 5W30 208L | 21 | û | 11 | ||
11 | 10 | 20W50 4x1L | 4 | û | 4 | ||
OUTPUT |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2:D11 | D2 | =IF(E2=0,CHAR(252),CHAR(251)) |
note : XL2BB tool doesn't show tick right, wrong
Last edited: