Hi guys
I need macro to clear any date in column A and but should contain blank cells in range B: H for the same date
the data could be 10000 rows , some data filling whole range and some data are not filled for whole range .
the outcome should be
I need macro to clear any date in column A and but should contain blank cells in range B: H for the same date
the data could be 10000 rows , some data filling whole range and some data are not filled for whole range .
cell.xlsm | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | DATE | CODE | BRAND | BATCH | DEL N | QTY | PRICE | AMOUNT | ||
2 | 26/04/2023 | CCS-001 | CTR-001 | BTR-001 | CDF-00 | 200 | 10 | 2000 | ||
3 | 26/04/2023 | CCS-002 | CTR-002 | BTR-002 | CDF-01 | 200 | 10 | 2000 | ||
4 | 26/04/2023 | |||||||||
5 | 26/04/2023 | |||||||||
sh |
the outcome should be
cell.xlsm | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | DATE | CODE | BRAND | BATCH | DEL N | QTY | PRICE | AMOUNT | ||
2 | 26/04/2023 | CCS-001 | CTR-001 | BTR-001 | CDF-00 | 200 | 10 | 2000 | ||
3 | 26/04/2023 | CCS-002 | CTR-002 | BTR-002 | CDF-01 | 200 | 10 | 2000 | ||
4 | ||||||||||
5 | ||||||||||
sh |
Last edited: