Validation rules

[Khalil Handal]

Hi,
I have posted this 2 days ago but didn't see it in group! don't know Why?
Posting for second time.

Two workbooks (of different names) that has the same worksheets with the
same names. Adjustments in formulas were made to one worksheet in book1.
Instead of dowing the same adjustment to the same sheet in book2. I thought
of copying that sheet only to the second workbook.
No matter what I tried, I had the following error message:

"You may not use references to other worksheets or workbooks for data
validation criteria"
Any ideas???

 

[Guest]

This didn't answer your question?

http://www.microsoft.com/communitie...dcf4&mid=8991ca08-d3f3-479d-9c80-ade01c57dcf4

 

[Khalil Handal]

Hi,
It explanes what is happening, but not resolving it.
I make changes in that sheet and need to put it instead of another sheet in
a different workbook with a different because the second book have data .