Dear Steve,
If you want to get a drop down list for data that is in Other sheet, First set the cursor or ur position where u want the list to appear then go to the sheet which you have the data then select all the Data and give a name to the range of cells you have selected or in other words create a named range.After that go to Data Validation in the DATA menu and in the Options available select List and in the Cell reference give the name of of the Named range that you have named before. then you can have you list in you required cell.even though you data is in other sheet. Regards, Vijaykumar On Thu, Dec 30, 2010 at 7:20 PM, Steve <stevebwea...@comcast.net> wrote: > Each month I must compare monthly expenses to the budget (forecast). > To do this I have created a spreadsheet with a drop down list where > the user selects the appropriate month to analyze. I would then like > the data to be pulled in from another tab using the appropriate column > based on the month selected. However, I am having trouble doing this > via the lookup function and ask for your help. I have uploaded the > spreadsheet "Copy of Actual vs Forecast FY11.xls". > > Any help or advice offered will be appreciated. > > Thank you! > > Steve Weaver > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- P.VIJAY KUMAR -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
