for some reason my data validation wont let me select a list from another worksheet in the same workbook.
im running the newer version of excel.
i do this all the time on my work computer - however on my home computer after i select the 'Source' option clicking another tab just gives me an error sound.
no idea whats going on.
help me obi won, youre my only hope...
hi there. try to just type in the source. for eg. if you're in Sheet2 & want to refer to Sheet1
=Sheet1!A1:A5
if that doesn't work, go to Sheet1!A1:A5 & put in a Name in the name box below the ribbon & on the left of the formula bar. say you name it "RangeX". then do the data validation
=RangeX
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
nope...
that doesnt fix it.
excel 2007 wont allow you to reference another sheet for DV or CF, you have to create a named range on the other sheet, and then use that name in the DV window.
1. highlight the range you want the DV to refer to
2. right-click into the range, and select "name a range"
3. give the range a (simple) name - avoid using spaces
4. where you want the DV to be, select DV, select LIST, under SOURCE type in =rangename
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks