New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Excel Data Validaton


Post Reply New Thread Subscribe

 
Thread Tools
dekalaked

 
Member Since: Apr 18, 2008
Posts: 1
dekalaked is on a distinguished road

dekalaked is offline
HI,
The data validation below works on MS Excel 2002 on a PC.
ie. a list of names is displayed in a drop down box.
But on Mac Excel the drop down list is empty.

Data Validation
Allow: List
Source:
=OFFSET(INDIRECT("[Tracker.xls]Roster!dbROSTERname"),0,0,COUNTA(INDIRECT("[Tracker.xls]Roster!dbROSTERname")),1)

where
dbROSTERname
=Roster!$D$7:$D$1223
QUOTE Thanks

Post Reply New Thread Subscribe


« iTunes question | Too powerful for games? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
exporting iTunes playlist data to read in Excel thaman669 OS X - Apps and Games 1 04-16-2008 12:27 AM
excel data import on Mac OS X dtkachov OS X - Development and Darwin 9 12-12-2007 03:10 AM
transfer pc->mac acash0902 Switcher Hangout 10 11-14-2007 12:58 PM
Transfering Movies and Music from a pc to my iBook rollershoer4MAC OS X - Operating System 6 04-21-2007 04:08 AM
Mail to Excel data merge/macro? Small giraffe OS X - Apps and Games 1 01-29-2007 10:55 AM

All times are GMT -4. The time now is 04:31 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?