Hi Sorry for the late reply, I added the code above and it appears not to do anything.
sorry, where do I put this?
oh that's great, it is working perfectly now ... is that all that was wrong with it, just some spaces..... doh!! so fustrating. thanks for taking a...
Hi Jessica thanks for your reply. Sample worksheet attached. on the "CPB Doc Request" tab, in E3 I need the drop down to list the correct corres...
ok thanks, that's what I thought.
Hi thanks, but that is not the problem... I just omitted the quotation marks above when typing, but I tried again just in case, and still get the ...
Hi Again following your example above, I tried to create another drop down as per below. =INDIRECT(IF($D3=“Corporate”, “tbl_Non”, IF($D3=“M...
Hi, Yes I have already watched all the tutorials etc, and I still couldn't make it work. but your code above worked perfectly!!! so grateful ...
thanks Mynda, this worked perfectly thanks so much for your help.
Hi thanks for your response.... I read everything and was good, but did not solve my problem I experimented with the Filter Function which ...
ahh ok thanks but there needs to be no value in P6 for this one. how do I write the formula. for the following. If C6 = Drawing or Document ...
Hi Mynda yes I thought that too... that P6 is not empty, even though it appears to be empty. see attached sample file. on sheet "CPB Doc Reques...