Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi All,
We have the following sheet
In column A, we want to automate creating code with new entry if condition meet with C2:C="In Store"
We have the following sheet
| Book1 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Code | Date | Store | work | ||
| 2 | $$KJ1000** | 10-08-2020 | In Store | Test 1 | ||
| 3 | 11-08-2020 | Out Store | ||||
| 4 | 12-08-2020 | Misc | ||||
| 5 | 13-08-2020 | Out Store | ||||
| 6 | 14-08-2020 | Misc | ||||
| 7 | $$KJ1001** | 15-08-2020 | In Store | Test 2 | ||
| 8 | $$KJ1002** | 16-08-2020 | In Store | Test 3 | ||
| 9 | 17-08-2020 | Out Store | Test 4 | |||
| 10 | $$KJ1003** | 18-08-2020 | In Store | Test 6 | ||
| 11 | 19-08-2020 | Misc | ||||
Sheet1 | ||||||
In column A, we want to automate creating code with new entry if condition meet with C2:C="In Store"
