Reply:

VLOOKUP- Multiple sheets
I am trying to VLOOKUP in multiple sheets. Can it be done?? =VLOOKUP(B2,SHEET1!$A$3:$M$1001,13,FALSE) I need to include sheets 1-8, not just sheet 1. Joe Not possible, do a search for morefunc online and download it, then use vlookup with a function called THREED (ample description is on the help file) -- Regards, Peo Sjoblom "joec" <joec@this_is_not_an_email_address.com> wrote in message news:OaE9M4eKEHA.3084@TK2MSFTNGP11.phx.gbl... > I am trying to VLOOKUP in multiple sheets. Can it be done?? > > =VLOOKUP(B2,SHEET1!$A$3:$M$1001,13,FALSE) > > I need...

Multiple Chart on Single Page
I'm having a lot of trouble arranging multiple charts on a page. Actually I'm doing 10 charts that are all the same size on 2 pages with 6 on the first page, then 4 on the last. I'm having a heck of time trying to get this right. I select all 10 charts and stretch them this way and that and adjust some row and column widths between the charts to make adjustments, but I can't get it right. There has to be a better method that this trial and error approach. I've search the web, but almost everything I've found is for some fancy charting program to do this. It...

Sorting multidimensional tables/multiple selections
I have several big matrices (1200*50) on different worksheets. It is a time-series data, so row headings are dates and column headings are firms. Cells are stock earnings, every worksheet using a different principle for calculating them. I need to sort this data like this: every row (daily revenues) in the first matrix (1. worksheet) in a descending/ascending order and all the other matrices should sort accordingly. This is because I need for example the smallest five values from the first matrice's rows and then the according values of those five firms from the other matrices. So I sh...

linking multiple sheets to a summary sheet
Please help! I have a workbook that has multiple sheets (one for every day of the week) that records data in the same place on every sheet (Each day is a copy of a master sheet - so the cell placements are the same) My question is 2 part: 1.) Is there a way to link the sheets so that if the format of the sheets needs to be changed, that I do not have to change every sheet (every sheet would change to reflect the same master sheet). For instance add a couple of rows to 12/01/04 sheet and it will add rows to every other sheet. 2.) I summarize the data on a summary sheet for groups of da...

Sumproduct accross multiple sheets
=SUMPRODUCT('Deacon, Carrie'!B4:B35,'Deacon Carrie'!C4:C35)+SUMPRODUCT('Deacon, Carrie'!B4:B35,'Deacon Carrie'!D4:D35)+SUMPRODUCT('Deacon, Carrie'!E4:E35,'Deacon Carrie'!F4:F35) I'm using the formula above to calculate some stats for a call center. On a master "group summary page", I need to get the sum of the result of this formula from 20 worksheets. Other than duplicating the formul and changing the names, is there a faster way to do this? The cel references are identical for all, worksheets just the names change. The only ...

Setting Up Multiple Users for Outlook 2003 with windows XP
Hi Kathleen - I originally installed office (Small Business Edition) over a year ago. I entered my name and accepted the EULA at that time. Outlook has run just fine since then for my original account with supervisor rights. I created the new XP user account a few days ago, and would like to be able to get Outlook running with this account using a separate .pst file and email account. When I try to run Outlook when I am logged in to the new account, I am not given the opportunity to enter anything. The Windows Installer box runs for a few seconds and then closes, and the second box ope...

Waiting for domain controller while on foreign nets
Hi, Scenario: Win2008 domain controllers and XP and win7pro clients. The clients are used in three different network environments, at their own office, at foreign domain network locations and at home. They are only connected to our domain when being in their office. We want these client computers ONLY to search / wait for response from their default domain controller when connected to our office network. A simple check of its leased IP address should tell windows if it currently is connected to the office network and therefore should try to connect to the DC. How can...

multiple SMTP under X.400 Queues
to whome it may concern: I also notice that my newly installed Exchange 2000 server has 2 SMTP Queues under the X.400 Queues. Is this right? most of my Exchange Server has only 1. thank you. ...

Multiple issues!!!!GRRRRR!
Hi All! So here is first issue. Little note in bottom right hand side of Outlook window frame says, for example"receiving 1 of 4 messages"...cool...but then I don't get 4, I will get less or none at all. I went to MS for their fix..it said to turn the filters off...yeah well, they were off, so I turned them on and then right back off again just incase it had become confused somewhere along the way. Still the same. Then I called my IP to see if it was an issue with them. Went through the whole rig-a-marole...nope, not them either...then on to F-Secure, they had me turn off all...

Plotting Multiple Values per System in Chart
Hello, I need to chart 3 components for systems on a chart as follows: System A Current Capacity Current Utilization Planned Capacity System B Current Capacity Current Utilization Planned Capacity And so on... I set up a chart to display the first item over the course of 12 months, so I have Jan - Dec on the horizontal access and the capacity unit of measurement on the vertical. My data looks like this: System Jan Feb Mar... A 1000 1000 1000 B 2500 2500 2500 C ...

Workflow: Wait for Subprocess being finished
Hello, in a Sales Process Workflow, I run a subprocess that checks certain conditions. How can I let the Sales Process wait for the subprocess to be finished? All I see is that I can wait for Activities. Regards, Martin ...

Multiple Address Lists
I have a very large .ldf file which I exported from another exchange server. It's over 100,000 addresses and 17,000 distribution lists. They are all of type "contact" (I used Address Magic to export them). I did a test import of a couple of them using LDIFDE and they are put in my new GAL as foreign recipients. I would like to put them in a seperate address list so my users don't have to wade through them when they want to send local email. I've not been successful in figuring out how to do this or if it is even possible. Any help would be appreciated. ...

how to instantiate a proxy class that has multiple instances
I have a class built from the following XML: <tag1> <tag2> <tag3 item="1"/> <tag3 item="2"/> </tag2> </tag1> On the client side I can populate tag1 and tag2, but I don't know how to instantiate instances of tag3. I read the values in from external file and I want to keep adding tag3 instances until no more found on input. Hello Doug, According to your description, what you need is to create a XML file which includes multiple instances of Tag3. Please don't heisate to correct me if I misunderstood anything her...

multiple select from the drop down list in excel. list in one sheet and drop down in
Hi, i want to include multiple select in my drop down list which is created in excel. i have the list in sheet 2 and the drop down appears in sheet 1. i got to know this can be done with a macro and there was some information but it wasnt useful for me. can any one please help me with this , if i need to write a macro, how do i go about doing that. -The steps i followed to create the drop down are. (i followed the below link) dhttp://spreadsheets.about.com/od/exceltutorialsandtips/ss/blexdropboxes_6.htm 1. Used a new worksheet for lists. Entered the data for the list in a column. ...

How do I pull in multiple data sets at once?
Hi. Using Excel Office XP. I have a lot of data on webpages that I want to import. It works great for one webpage at a time to use the Data/ Import Query/New Web Query. So I how do I do it if I have many webpages? I have found software to download all the hmtl pages into one folder. Is there a way to automate the importing of these? I tried macro, but my skills are weak there, and the macro just opens the same page each time. Ideally, I'd like to have the data on each page (they are all alike) put in one worksheet, just one chunk of data below the other. Thanks for any ideas!! ...

Multiple Sheets in Excel
I Had posted some time back about creating custom class for excel spreadsheet and how i should go about it. From the suggestions that I got from the group I created a custom spreadhsheet class that handles the spreadsheet. And I am well on my way to create a basic spreadsheet application. Anyways Now I wish to implement the feature of adding sheets to the spreadhsheet. Like the one which is present in excel with Sheet 1, Sheet 2, and Sheet 3 tabs and ability to add more tabs. How Do I do that? Also i am currently saving the documents in csv format when user saves them. What format should be us...

selecting multiple sheet tabs and open another workbook
I often have to move or copy data from multiple worksheets at a time and paste them in a new workbook. My problem is that when I have multiple sheets selected, and then open another workbook, Excel 'forgets' about the multiple sheets I have selected, and remembers only the first sheet. The result is that when I think I am copying data from mutliple sheets at once (which is what I want to do), I am actually only copying data from the first sheet. This is extremely annoying - why does Excel think it knows what I want to do better than I do? If I select multiple sheets I expect the...

Multiple Formulas in same Cell
I am having trouble trying to make a formula work. what I am trying to do is this. I have text in one cell ie Townsville, Sydney, Brisbane. If I have Brisbane in the cell then I need the worksheet to take the value from an adjacent cell and *0.44%*50/25. If the value of the cell is Townsville then I need the worksheet to take the value from the adjacent cell and *0.44%*35/25. If the value is anything else I need the worksheet to take the value from the adjacent cell and *0.36%*35/25 Can anyone help me with this delimar =IF(OR(A1="Brisbane",A1="Sydney"),B1&...

Rounding Multiple Numbers
I have 4 percentages which together = 100%. They change and can includ long decimals. I want to produce a rounded version that still equal 100%. However when I use ROUND, ROUNDUP, CEILING,MULTIPLE etc. I do no always get the right results. Example 1): Source 33.3333%, 33.33333%, 33.33333%,0% = 100%. Rounde result 33%, 33%, 33%, 0% = 99%. Example 2) Source 24.5%, 24.5%, 25.5%, 25.5% = 100%. Rounded resul 25%, 25%, 26%, 26% = 102% Does anyone know a solution to this please? Adria -- Message posted from http://www.ExcelForum.com Just use whichever one you want on the first 3 values and then...

Multiple file handling, updates and closing...
I have an application I inherited that's programmed in Excel VBA (not my idea - over 5K lines of code) that has an update function and a file copy function. I consider myself rather astute and well-versed in VBA, but am a little rusty - but only a little. Anyway, I have a problem pulling what little hair I have left out. Update function Theory: The update function checks for a specifically named xls file, opens the workbook if exists, makes this active, copies a module to a .bas file, activates original workbook, closes previous workbook, imports module from .bas file, kills .bas...

Multiple selections from a list
Is it possible to construct a dropdown on a form that allows people to pick more than 1 value from a list? For example, if the values on the dropdown are "Bill", "Bob", and "Sue", and I wish to select both "Bill" and "Bob", and have both values stored together on the same record, is this possible? -- Cloudbuster What version of Access? It's not possible in Access 2003 or earlier. It's possible in Access 2007, provided you're using the ACCDB file format. -- Doug Steele, Microsoft Access MVP http://I.Am/DougStee...

Multiple hyperlinks in a dropdown list ?
I want to add a drop down list (combobox?) or whatever you want to call it in our business process flowchart, to access multiple documents on our network. (the page will be included in our intranet). I've tried a lot of MS form objects but I can't seem to : 1) fiind the right object 2) assign multiple hyperlinks in a list Is that a limitation of MS Visio 03 ? Or I didn't found the way to do it right ? If you add multiple hyperlinks to a Visio shape, they show in the right-click menu. Is this good enough? -- Hope this helps, Chris Roth Visio MVP "Junkyard Engin...

mail merge letter with multiple entries
I'm trying to set up a mail merge letter to be addressed to individual companies that have been nominated for an award by one or more nominators/companies. It reads like this: �First Name� �Last Name� �Company� �Address� �City�, �ST� �Zip� Dear �First Name�: You have been nominated by �Nominator Name� of �Nominator Company�, by �Nominator Name� of �Nominator Company� and by �Nominator Name� of �Nominator Company� to &#8230;.. I haven't seen any posts that directly address this type of arrangement of set up. Any help in setting this up would be greatly appreci...

Applying Freeze Panes to Multiple Worksheets
Is there a way to select multiple worksheets within a workbook and appl a freeze pane or split to the same line in all? (I'm using Excel 2002 ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com Yes, Yes, Select the first sheet you wish to format, then hold the CONTROL key down while you click the tab of each additional sheet you wish to freeze panes on. When all sheets are selected, go to Window|Freeze Panes to freeeze all of the panes... and then right click on any se...

Multiple Views Without Splitter
Hi All, Can you tell me how to create a 2 views of type CViews without splitter? Sample code will be of great Help.. Thanks in Advance, Prash Is this for an MDI or SDI app? Do you want the same view or different views? Why is it that you don't want to use a splitter? Here is one way: m_pView1 and m_pView2 are CWnd * declared in CChildFrame class. BOOL CChildFrame::OnCreateClient(LPCREATESTRUCT lpcs, CCreateContext* pContext) { // default create client will create a view if asked for it if (pContext != NULL && pContext->m_pNewViewClass != NULL) { m_pVi...