I am having a hard time trying to figure how to get the second column (data validation formula) working.
attaching a file so you can see what i'm trying to do. The validation fields are working perfect on the first tab. However,
when I try and recreate it on a new sheet, it generates an error.
I'm trying to put this formula in the
validation list (source) field..
=OFFSET(INDIRECT(SUBSTITUTE($A2," ","")),0,0,COUNTA(INDIRECT(SUBSTITUTE($A2," ","")&"Col")),1)
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
If anyone has a few moments to help me figure it out, it would be greatly appreciated.