Hi all.
Picture this if you can, in sheet 1, cell A5 to C6 has a data validation drop down list containing MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY. First of all I want copy whichever day I select in to a set cell on sheet 2, for some reason when I click = cell A5 i get the #VALUE ! error.
Then in cell C17 I will have an Indirect data validation list depending on if I have Monday, Tuesday etc selected in cell A5 to C6, i suspect that once the indirect list is set up I will get the same error when I try copy the data to sheet 2.
I hope this makes sense, any advice would be appreciated.
#onefrustratedtransportmanager
Picture this if you can, in sheet 1, cell A5 to C6 has a data validation drop down list containing MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY. First of all I want copy whichever day I select in to a set cell on sheet 2, for some reason when I click = cell A5 i get the #VALUE ! error.
Then in cell C17 I will have an Indirect data validation list depending on if I have Monday, Tuesday etc selected in cell A5 to C6, i suspect that once the indirect list is set up I will get the same error when I try copy the data to sheet 2.
I hope this makes sense, any advice would be appreciated.
#onefrustratedtransportmanager