Copy from a filtered cell and paste into a validated ( by dropdown ) cell

[BrainFuzz]

Hi , i have a filter from a table. I would like to be able by pressing for example a button copy the cells value to a data validated cell. I’m struggling at the paste , paste special part where the cell is not taking the value. Seemingly it’s removing the validation rule too. Does anyone have examples of doing similar. ?

 

[BrainFuzz]

Hi , i have a filter from a table. I would like to be able by pressing for example a button copy the cells value to a data validated cell. I’m struggling at the paste , paste special part where the cell is not taking the value. Seemingly it’s removing the validation rule too. Does anyone have examples of doing similar. ?

Please forget this question . I had a break , Coffee then it worked faultlessly

 

[Peter_SSs]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.