I am trying to see if it would be possible to automate my workbook to create custom dropdown lists in the manner which I am describing below. Unfortunately I have not had much luck so any guidance would be greatly appreciated!!
I have sheet where I paste in a table from my output starting in Cell D4
There are multiple rows in Col D which contain a colon (“ : “) This may vary by job as some could have 5 and some could have 50.
For each row in Col D that has a colon, I need to format Cells B & C in the same row
In B I need a dropdown list with the options for Weekly and Monthly
In C I need a dropdown list with the options No Flex, 5% Flex and 10% Flex
I would also like the cells B & C in those rows to be colored yellow
I have sheet where I paste in a table from my output starting in Cell D4
There are multiple rows in Col D which contain a colon (“ : “) This may vary by job as some could have 5 and some could have 50.
For each row in Col D that has a colon, I need to format Cells B & C in the same row
In B I need a dropdown list with the options for Weekly and Monthly
In C I need a dropdown list with the options No Flex, 5% Flex and 10% Flex
I would also like the cells B & C in those rows to be colored yellow