I am looking for a VB code to perform the following:
If text in Column C is "DDC" or "VOID".... I would like column K, M, O, Q, S and T to auto populate with the same wording and leave blank if any other text is in column C or if it is blank. A formula will not work for this because of the end use of this spreadsheet.
C K M O Q S T
DDC DDC DDC DDC DDC D DDC
VOID VOID VOID VOID VOID V VOID
so it would look similar to the above but in excel obviously.
Please help!
Bookmarks