I want to copy row no 2 many times as required. I don’t want to allow to edit or type in Celll B2, D2 & G2, H2. they can copy the cell but delete.
allow only input D2 (drop downlist) and F2 only
allow only input D2 (drop downlist) and F2 only
A | B | C | D | E | F | G | |
1 | S.No | Item description | No | Unit | Order QTY | Rates | Total Amount (QAR) |
2 | 1 | Project Director | 1.1-W | day | 4.00 | 2,500.00 | 10,000.00 |
Vlookup formula with Cell C2 | Drop down List | Vlookup formula with Cell C2 | need to enter | Vlookup formula with Cell C2 | E*G |