You can use a cell in the current workbbok to reference the cell in the other
workbook, then tie your validation to the linked cell
"Neo1" wrote:
Hello I tried performing a validation check so that a value is less than
or equal to a value in another workbook, but it doesnt let me choose the
cell from the other workbook I guess it has to be in the same worksheet
your applying the validation check in right? isnt there a way i can
choose the cell from the other workbook?
Thanks a lot
From John
--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=523656