Hi experts,



I have written a form for entering my travelling expenses. I have used a
list of destinations and round trip miles, (I4:J25) to avoid retyping.

E4 = VLOOKUP(D4,$I$4:$J$25,2,FALSE)

I have set column D, validation to list, in-cell dropdown, $I$4:$I$22

This works well until I try to put my list on a different worksheet. It
seems that I cannot validate across worksheets.

Is there a workaround for this?



Please be gentle

I am a new bee.



Regards,

Stan. S.

Hi
you have to define a name for your source list ('Insert - Name -
Define'). e.g. listsource
Now use this name as data source in the data validation dialog. e.g.
=listsource

--
Regards
Frank Kabel
Frankfurt, Germany


Lidia Simmons wrote:
Hi experts,



I have written a form for entering my travelling expenses. I have
used a list of destinations and round trip miles, (I4:J25) to avoid
retyping.

E4 = VLOOKUP(D4,$I$4:$J$25,2,FALSE)

I have set column D, validation to list, in-cell dropdown, $I$4:$I$22

This works well until I try to put my list on a different worksheet.
It seems that I cannot validate across worksheets.

Is there a workaround for this?



Please be gentle

I am a new bee.



Regards,

Stan. S.

Thanks Frank & Bob,
It works perfectly. Isn’t it easy when you know how?

Regards,
Stan Simmons


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Yes, you have to give the list a workbook name (InsertNameDefine Name..)
and use that name in the list definition instead of a range.

--

HTH

RP

"Lidia Simmons" wrote in message
...
Hi experts,



I have written a form for entering my travelling expenses. I have used a
list of destinations and round trip miles, (I4:J25) to avoid retyping.

E4 = VLOOKUP(D4,$I$4:$J$25,2,FALSE)

I have set column D, validation to list, in-cell dropdown, $I$4:$I$22

This works well until I try to put my list on a different worksheet. It
seems that I cannot validate across worksheets.

Is there a workaround for this?



Please be gentle

I am a new bee.



Regards,

Stan. S.