excel 2000 drop down from other work sheet

I cannot get my named range to work in a siuation where I am trying to do a 
drop down list form another work sheet in the same work book.

I am in 2000 after working with xp and 2003 and I am hitting a wall.

I want to be on sheet 1 and when in a cell click for drop down list with 
source data on sheet 2 

what is the problem here why does it not see the named range.
0
ToddF (23)
11/4/2004 8:10:01 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
338 Views

Similar Articles

[PageSpeed] 48

Thanik you but I resolved this issue with mr excel site






"Todd F." wrote:

> I cannot get my named range to work in a siuation where I am trying to do a 
> drop down list form another work sheet in the same work book.
> 
> I am in 2000 after working with xp and 2003 and I am hitting a wall.
> 
> I want to be on sheet 1 and when in a cell click for drop down list with 
> source data on sheet 2 
> 
> what is the problem here why does it not see the named range.
0
ToddF (23)
11/4/2004 10:40:05 PM
Reply:

Similar Artilces:

Pasting data from Excel
Hello everyone, I'm not sure if I should be posting this question here or in the Excel forum but here goes. Is it possible to copy data from multiple cells in Excel and then paste them into multiple lines of the criteria section of an Access query? For example, Given cells and values: A1- 1 A2- 2 A3- 3 I would like to be able to copy this data from Excel and paste it into an Access query like : Criteria: 1 or: 2 3 I am using Access 2002 SP3 and Exc...

Excel Drop Down Box
I'm trying to edit an excel worksheet that has drop down boxes. However, the drop down boxes are not typical forms. These drop dow boxes appear to be normal cells (They contain text). When I click o the box, a little gray box shows up w/ a down arrow to the right of th cell. However, if you right click on the cell, there aren't an property options that are displayed. I was wondering if anybody had any idea what kind of drop down box thi is. How can I edit or create one -- Message posted from http://www.ExcelForum.com It sounds like it's under Data|Validation. chris313 wr...

Outlook 2000 under Win98
Hi, Have a machine with Win98 and Outlook 2000. I am giving this machine to another user. The problem that I have is that when I start Outlook 2000, it has the previous user name in the splash screen. here are the things that I have tried. 1. Uninstall Outlook 2000 (twice) 2. Delete all occurances of Outlook in Registry 3. Reinstall Outlook 2000 (twice) 4. Delete .pwl files And still when I reinstall again, I entered a new user name in the installation process. After that, I start Outlook and still have the previous user name. Note: Don't really want to reinstall Win98. Any s...

How to use outlook address in Excel
Hello, I have an Excel sheet which I use as an invoicing-application. I would like to retrieve address-data from Outlook where I keep all my contact-data of my customers. So, I want to select a customer from my Outlook contactlist when I am writing a new invoice in Excel. In Word, I have a macro which does this, but unfortunately the Application.GetAddress does not work in Excel. Can somebody help me ? "Henny Slokker" wrote: > Hello, > > I have an Excel sheet which I use as an invoicing-application. I would like > to retrieve address-data from Outlook where I...

how to select multiple text boxes in excel for formatting
I am trying to select multiple text boxes for formatting the font but seem unable to select all of them other than to click on each one individually. Is there an easy way to select all of the text boxes at once? To select multiple objects on the sheet -- Click on one object Hold the Ctrl key, and click on additional objects To select all the objects on the sheet -- Choose Edit>Go To, click Special Select Objects, click OK Or, to work with specific objects, you can add the 'Select Multiple Objects' tool to one of your toolbars: Choose Tools>Customize Select the Commands tab...

excel margin issues on landscape
When I print a spreadsheet I cant get it to print to the full page - it prints smaller unlike older excel program. Also when i set the margins for a spreadsheet the left hand margin wont move over to the edge of page like right hand side? In Page Setup: If you are using the Scaling option to print to a certain number of pages wide by pages tall and/or you are using the columns to repeat at left, try: - clearing the number of pages tall value (so that it is blank), and/or - if you are printing to one page wide, remove the columns to repeat at left Simon "Peter MB" wrote: >...

How do i navigate between sheet tabs from my keyboard?
It would help my data entry immensly by not having to use the mouse. Ryan CTRL + PageUp and CTRL + PageDown to cycle through sheet tabs. Gord Dibben Excel MVP On Mon, 2 May 2005 17:02:02 -0700, Ryan T <Ryan T@discussions.microsoft.com> wrote: >It would help my data entry immensly by not having to use the mouse. ctrl-pgup and ctrl-pgdn will cycle through the worksheets. ctrl-F6 and ctrl-shift-F6 will cycle through the open windows. (As will ctrl-tab and shift-ctrl-tab.) Ryan T wrote: > > It would help my data entry immensly by not having to use the mouse. -- Da...

produce list automatically from choice of drop down list
I have a drop down column where the choices are say 1 to 100 From the choices listed, I want to create a list automatically from the results so I can set up if formulas against the choices selected. Column A Column B Column C Choice (drop down box) Automatically adds look up selections from column A formula using column B 1 to 100 ...

Can I only allow printing to pdf in Excel?
I have created a template in Excel which has been set up so that the layout is perfect when printing to pdf (which is how the document will mostly be used) but the layout changes if printing direct to our printer. Is there a way that I can ONLY allow printing to pdf from this document? Hello You may consider using some VBA to achieve this. One way is to use the Workbook_BeforePrint event and specify the pdf printer in the PrintOut method, eg: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PrintOut copies:=1, ActivePrinter:="CutePDF Writer on CPW2:" End Sub Pl...

Excel macro list
In Excel 2003 I used to be able to list all macros in a workbook by pressing Alt+F8. Now all I get is a series of ribbon help letters... What's changed? Is there still a way of accessing macros via Alt+F8? Any suggestions appreciated. Hi, ALT+F8 works for me in E2007. What do you mean by 'I get is a series of ribbon help letters' Mike "pbaker6" wrote: > In Excel 2003 I used to be able to list all macros in a workbook by pressing > Alt+F8. Now all I get is a series of ribbon help letters... What's changed? > Is there still a way of...

Hlp! Requery Cbo Not Working
Hello, I'm using Access 2000. I added a combo box to enable users to select an existing employee name. The source of the form is a query that contains the last&", "&first to concatenate the two fields so they show correctly in the combo box. Everything is fine until I add or delete an employee. The combo box doesn't update automatically, so I added the following event in the form's After Update: Private Sub Form_AfterUpdate() Me!cboName.Requery End Sub However, now the combo and the employee records no longer are in synch. Nothing at ...

query will not write to excel
I have set up a query to a Foxpro .dbf file in a database from excel. When I tell Excel to import the data it it appears to be working but never seems to return the data. Running the same query via msquery.exe returns the data with no problem. Can anyone tell me what the problem is ? ...

Amex/Costco account update not working
Wondering if anyone else is having issues update and Amex/Costco account in 2006 version. It was working on 2004 version but has been broken since the upgrade. Andrew, Downloads from Amex/Costco work fine here. Explain what "issues" are you experiencing? Kevin "Andrew" <justme@nowhere.com> wrote in message news:42efdc69_1@newsfeed.slurp.net... > Wondering if anyone else is having issues update and Amex/Costco account > in 2006 version. It was working on 2004 version but has been broken since > the upgrade. > > Kevin, I had problems wi...

Hiding and Unhiding Rows.. Unhide does not work..
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I use this formating feature quite often. But, on this one worksheet which is a rather large data list (6000 Rows) I can NOT unhide rows that I have previously hidden. It just does not work. <br><br>I have other workbooks open and I have no problem hiding and unhiding in the normal way. <br><br>The workbook is NOT protected. The cells are not locked. But the file was originally a windows file. <br><br>Is there some switch I do not know about? This is possibly a rare occurren...

Reminder is not work in default folder #2
I used as follow coding to send email to outlook client(outlook 2000): ''''''''''''''''''''''''''''''=AD'''''''''''''''' Dim ll As New CDO.Message Dim bb As New CDO.Configuration bb.Fields(cdoSMTPServer) =3D "nc80012" bb.Fields(cdoSendUsingMethod) =3D cdoSendUsingPort bb.Fields.Update Set ll.Configuration =3D bb ll.Fields.Append "urn:schemas:mailheader:x-mess=ADage-flag", adBSTR _ ...

EXCEL FORMULA #28
Good afternoon, I'm trying to fine a formula which would show me how much money I would save on a mortgage if I were to pay additional principal each month--in addition to paying the additional principal how long would it take to pay off. I'm looking at a 160k mortgage at 7.5 for 30 years. I'll like to pay this off as soon as possible by paying additional principal each month. There are tons of free templates at: http://office.microsoft.com/en-us/default.aspx Maybe you'll find something you like. Kam1999i wrote: > > Good afternoon, > > I'm ...

OLE: Excel.Application
Hello, in VB.Net, I use Excel to display results : dim xl as new Excel.Application // creates an Excel process // snip (putting values into cells) xl.Visible = true If the user closes the Excel file and then my program, the Excel process is killed in memory, which is good. If the user closes my program first and then the Excel file, the Excel process remains in memory ! How can I make sure the process will be killed ? Thanks ! Hi You need to set xl.quit (and before that ensure that excel doesn't halt and ask things like "save changes?" on quitting) somewhere in your p...

Export relationship information from Visio to Excel
Hello all, Is there a way to export information regarding relationships from a visio diagram to an excel spreadsheet? In addition, is there a way to tell the excel spreadsheet to eliminate or change a relationship and for that action to be applied onto the visio diagram? thanks, ivan as a general answer I'd have to say "no, not without custom code". You didn't define what you meant as a relationship. al "Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message news:6332A594-E4AF-4E8B-BA2D-7A4BC17962B3@microsoft.com... > Hello all, > &...

startup excel euro symbol
when i digit € symbol inside any application excel 2007 automacic startup and for me is impossible to use this symbol anywhere, i use windows xp professional ..have you a response to solve this problem? thanks ...

Excel 2003 Print Issue
I have created a spreadsheet to help with a university engineering assignment and I have added a worksheet that is basically an automatically generated report of all the calculations. I have set the Print Area up in such a way so that the results are printed out in well defined pages (e.g. page 1: title page, page 2: summary of input variables, page 3: summary of calculation results etc). The report is arranged vertically in the worksheet, so the pages are 'stacked' on top of each other. It prints out fine in Excel 2000 and 2002 but I recently upgraded to Excel 2003 and now find tha...

Size of sheet
I have created a small spreadsheet in Excel XP. I have hidden all the unwanted columns and rows and it prints ok. However, when trying to email, all the unused columns and rows are still present (though hidden) creating a very large file too large to send. How do I limit the size of the sheet? Unhide the columns/rows, select the first row (the whole row) that you want to hide, press ctrl + shift & down arrow, then do edit>delete, save the workbook. Repeat for the columns but press Ctrl + Shift & right arrow, finally hide the column/rows again -- Regards, Peo Sjoblom ...

Sorting Multiple Sheets
I have a workbook with multiple sheets. The main sheet has 2 columns, 1 for first name, 1 for last name. The remaining sheets all have formulas to pull the first and last names automatically from the 1st sheet. If a user sorts the names on the first sheet, they will sort on subsequent sheets, but the information that goes with those names on subsequent sheets will not be included in the sort, thereby misplacing information. Is there anyway to remedy this, short of sorting each sheet each time there is an addition to any one sheet? ...

Linking multiple sheets
I need to set up a spreadsheet that links to 12 others. On each of the others there may be 100 rows(or less) of information to bring in to the master. Is it possible to write a formula that enables the link to pull in only rows that contain information? I don't want blank rows between each of the 12 groups of information I'm sure an expert will chime in with something better, but I've done similar with lookup functions. don't do it direct or it will be slow. I let everything come over to one master workbook, then use a lookup page that consolidates the data. "...

Word problems 2003 and 2007 version
hey everyone both on my main computer and my brothers laptop word isnt working! its so annoying! on my desktop PC i have windows xp and word 2003. after getting a virus which stopped the internet from working i had to do a system restore - which got rid of the virus. but when i click on word it says that "this shortcut only applies to installed products", and when i go to word through program files it says "this product is not installed on this user" - but there is no setup thing i can press - will i need the disc maybe? on my bro's laptop he got the sa...

excel 2000 message
excel 2000 message - 'cannot use object linking and embedding' Were they hit by the MSBlast worm? One poster (Lutz Meyer) guessed that this was the cause of his problems. I haven't seen any confirmation/denial, but you may want to read his post: http://groups.google.com/groups?threadm=3F3971AF.FA4490F5%40msn.com Post back with your results. I'm curious if that was the problem. (It's come up quite a few times since MSBlast hit.) bill bootle wrote: > > excel 2000 message - 'cannot use object linking and > embedding' -- Dave Peterson ec35720@msn.c...