I am trying to have a formula populate into Column A and a data validation populate in column J based on the data validation list that is selected in column M. I have highlighted the areas (tab "Jobs") that have the correct formula in column A and the correct data validation in column J. I would like to be able to select my Press- in column M and have the correct formula automatically populate into column A and the Print Mode data validation to populate into column J. I'm not sure if this is possible, but if it is I would appreciate any help in figuring it out.
Thank you in advance,
Adam
Bookmarks