Hello,
What I am trying to do is create a Data Validation using the List Option in settings. <-Easy
But I then want to fill that down the whole column however when I do it adjusts my source formula. It adjusts it by one each filter down I do.
Here is what my start looks like: (i hope this works)
Data V.jpg
(my source reads: ='kit codes'!A1:A205)
This returns what I want. But if I fill down or copy and paste the columns in my formula also move.
So if I copy and paste the cell with the data validation in, for example, 5 lines down, the source formula changes to ='kit codes'!A:A209
How do I stop this? I have tried "$" in there and this didn't help. I have tried googling and have yet to find something that helps.
I know its doable as a guy I use to work with found a solution but that was years ago.
Look forward to hearing from you.
Thanks
AP
Bookmarks