im having trouble sorting out this vba formula I can handle an if formula in the sheet but really struggling in vba
I have this list on sheet1
sheet1 column P is tickboxes (True/False for that column)
if there's nothing in sheet1 column O then skip it
if there's something in sheet1 column O I want to check if sheet1 column P is "true" and lookup the word from sheet1 column N in sheet2 column D put value "sold" in sheet2 column F (offset 2?) if false do nothing
then replace the word from sheet1 column N in sheet2 range D:D with sheet1 column O
I have this list on sheet1
sheet1 column P is tickboxes (True/False for that column)
if there's nothing in sheet1 column O then skip it
if there's something in sheet1 column O I want to check if sheet1 column P is "true" and lookup the word from sheet1 column N in sheet2 column D put value "sold" in sheet2 column F (offset 2?) if false do nothing
then replace the word from sheet1 column N in sheet2 range D:D with sheet1 column O
NFO New Jot.xlsm | |||||
---|---|---|---|---|---|
N | O | P | |||
29 | List | Merge | Rear | ||
30 | A | M | FALSE | ||
31 | B | ||||
32 | C | ||||
33 | D | ||||
34 | E | ||||
35 | F | ||||
36 | G | ||||
37 | H | G | |||
38 | I | ||||
39 | J | ||||
40 | K | ||||
41 | L | C | |||
42 | M | ||||
Sheet1 |