View 2 workbooks to compare

I have excel 2000  SR-1 
I would like to view worksheets from 2 different workbooks at the same time 
to compare informatin, is that possible with this version?
Thanks
0
Utf
1/17/2010 10:00:01 PM
excel.worksheet.functions 4936 articles. 2 followers. Follow

1 Replies
633 Views

Similar Articles

[PageSpeed] 29

Yes, with one file open you can do File | Open and select the second
file. Then use Window | Arrange | Vertical to see the two files side-
by-side. Each window is independent of the other one, so you can
select different sheets to view etc.

Hope this helps.

Pete

On Jan 17, 10:00=A0pm, Donna <do...@yahoo.com> wrote:
> I have excel 2000 =A0SR-1
> I would like to view worksheets from 2 different workbooks at the same ti=
me
> to compare informatin, is that possible with this version?
> Thanks

0
Pete_UK
1/18/2010 12:47:00 PM
Reply:

Similar Artilces:

I cant view my publisher page choice fromt and back
I am using Publisher 2000. I have used it for four years, quite successfully. I opened one of my two page (front & back) reports to reprint it, and i cant find the page choice blocks (not in my view) that are normally down on the lower left part of the main page. I am unable to edit the second page, but when I print, it prints both front and back. I checked my other reports, and the page choice is not visable in any of the reports. Help view...toolbars...status bar -- Mary Sauer MS MVP http://office.microsoft.com/ http://www.msauer.mvps.org/ news://msnews.microsoft.com &q...

search #2
Can someone tell me why when I do a search and just put in the name thats in the from catagory in the news groups it will not come up with anything. hope you can help steve Hi Steve, Let's start from the beginning because I don't know what you are actually doing. The following link will set you up to search the *Excel* newsgroups using Google Advanced Groups search http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100 into the author field you can enter something like one of the following stevem@luminet.net Tom Ogilvy My webpage to help with such thin...

"The Operation Failed" #2
This is the message I get when I try to open Outlook 2000. I'm running Win2K. I recently had a serious crash and my computer is still not stable. However, I AM able to run Outlook Express. I've had viruses, which are cleaned out. (Bliss, Hacktool.Sechole). And whenever I start up any of the Office programs, they go through the "installation" process as if they were never started before. It's as if the computer has no memory that they've already been installed. Any assistance would be greatly appreciated. Thank you. ...

User not accessed the system since last 2 months
Is there any script available to determine accounts that have not logged in for the past x months. Please provide us the link and and guide line how to use that ? Thanks ...

Unhandled Script Exception #2
Hi, We get the following error when trying to post a G/L batch: Unhandled Script Exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'AVDYN.dbo.glpCreatePostingActivity' We are using Dynamics 8-SP2 Thanks for your help, Marc R. - Avanti Computer Systems recreate or restore the glpCreatePostingActivity stored Procedure will solve the issue. "Marc R." wrote: > Hi, > We get the following error when trying to post a G/L > batch: > > Unhandled Script Exception: > [Microsoft][ODBC SQL Server Driver][SQL Server]Could...

Comparing queries
Hi, I am using a database storing equipment for rooms where I have two queries set up, one listing original equipment and another listing current equipment for room layouts. The two queries work fine independantly, but I now want to compare differences between these where I need to know: 1 - equipment in both original and current rooms. 2 - equipment in original room now missing from current room. 3 - equipment in current room, not required in original room. Regards, Dave. You did not say anything about the table structure so I will go with what you posted. Use a unio...

Condtional format with formula
I have this formula =IF(ISNA(VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE)) =TRUE, "DONOR NOT VALID",VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE)) on cell B17. When the user selects a value in A17 from the drop down, it goes to sheet 'Data-FSList' to retrieve a value. If the value is not there it comes back in field B17 'DONOR NOT VALID' However when A17 contains no value from the drop down and is blank I do not want 'DONOR NOT VALID' to show in cell B17. Is there a way to add to the formula above if A17 is blank then...

Delivery Status Notification (Delay) #2
Hi, I have Exchange 2003. There are some remote user (using POP3)got messages like below from postmaster when sending email: This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed. xxxx@xxx.com Internal user (useing corporate/workgroup mode in Outlook) has no problem. No problem from OWA. The remote POP3 user is submitting the message over an authenticated SMTP connection. We don't allow unauthenticated email to be routed through our se...

View -> Sized With Window (for Excel charts): I want it back, plea
While I appreciate that not every function survives from one version to the next, this is one I sorely miss ! I use Excel 2003 at work, and 2007 at home. I can stand the constant bleating about compatability. I can even (barely) tolerate the highlight colors not matching. But this? Why oh why was it removed? Can you at least recommend a macro / VBA script patch to reurn this functionality to the program ? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" b...

Importing data #2
hi I would like to import data from the web and although this is quite simple in Excel 2003 the new data (that comes in upon refresh) replaces the old. I was wondering if there is a way to keep previous history of the data, make Excel fill in adjacent cells with the new data for example. Thanks for taking the time to read this George hi, if you are using Microsoft query, the answer would be no. The Micorsoft query becomes a named range in excel that is linked to the query. by desing it expands and contracts at refresh to accommidate new data. I think to accomplish what you want yo...

Controlling execution of a Sub Procedure -Part 2 :(
Question:Is there any way to only start a Worksheet_calculate procedure once the iterative sheet with which it is associated is FINISHED? How can you detect when it is finished? Details below In a previous post I was trying to run a lengthy calculation in a Sub Worksheet_calculate() procedure IF certain conditions on a spreadsheet were met. Of course I was developing this outside the ultimate workbook application. I resolved my stack overflow problem by writing out results to a sheet other than the one that had the Worksheet_calculate() procedure associated with it. THAT d...

Counting with 2 Conditions
I created a report and would like to get a count of records with two conditions. Here is what I entered: =Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA") This information is entered in an unbound text. I would like to get a total count where the terminate field (yes/not) is checked and the caseload meets a certain criteria. Thank you! TomP wrote: >I created a report and would like to get a count of records with two >conditions. Here is what I entered: > >=Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA") > >This information is ent...

View Customization Question
My director came to me the other day and asked about customizing his view of his accounts. He had two requests. I figured out the first one, but I'm having a little trouble figuring out if he can do the second one. When he opens up a single account, instead of it opening automatically to the Information section, he would like it to automatically open to the Contacts section. Help is much appreciated! Cammie You can make a new tab pn Account form (contact view and make it the first one on account form). Now you use Iframe . you can get idea from here http://icu-mscrm.blogspot....

crm token #2
some times i track an email in crm sent it to a customer- i got the customer repaly to the mail but i dont see the traking icon in the replay message and it seemed to be un tracked but if i go to the customer history i see his replay inside the history further more if i press track in crm to his replay he'll give me directly the regarding field filled with this customer have some body an idia about this see this http://support.microsoft.com/kb/929385/en-us try to install rollup update 2 and it will work. -- Regards, Imran MS CRM Certified Professional http://microsoftcrm3.blo...

Data Labels on Clustered Column w/ 3D Visual effect #2
Clustered Columns can have Alignment as "Inside End" This doesn't seem possible with 3D Visual effect Is there a way to resolve this? Yes, use 2D charts. They provide a better representation of the values being plotted without the implied false third dimension. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ emwashburn wrote: > Clustered Columns can have Alignment as "Inside End" > > This doesn't seem possible with 3D Visual effect > > Is there a way to ...

XML Insert data C# ASP.net 2.0 Need to know how to insert by speci
Hello, I have the following XML Schema: <?xml version="1.0" encoding="utf-8"?> <Schedule> <Day Name="Monday"> </Day> <Day Name="Tuesday"> </Day> <Day Name="Wednesday"> </Day> <Day Name="Thursday"> </Day> <Day Name="Friday"> </Day> <Day Name="Saturday"> </Day> <Day Name="Sunday"> </Day> </Schedule> I want users to be able to input the following tiomeblocks for a scheduling s...

Address Book View #3
Hi, I'm trying to make use of the Address Book Views in Exchange 5.5 sp4. Currently I can create a Address Book View, but can't add new contacts into it. I can only use Recipient Containers for addressing. I would like to have an Address Book or Recipient Container that is can be sorted by users' company. So far I managed to create a custom Recipient Container called Internet Recipients which houses all frequently contacted internet customers. I have to prefix them with their company e.g., ABC--Al Bob Microsoft--John Doe Microsoft--Mary Jane Is there a better way of doing ...

Convert C:\1\2.exe to c:\1\ shlwapi
Looking a function to do that. shlwapi.lib Maybe someone else here will understand this, but it looks like a typo to me. You want to convert: C:\1\2.exe to C:\1\shlwapi (what?) Is this shortname to long name? I guess what I'm asking is what does 2.exe have to do with SHLWAPI? Tom "roxioxoto" <coco002@gmail.com> wrote in message news:1154971834.120105.234410@i42g2000cwa.googlegroups.com... > Looking a function to do that. > shlwapi.lib > Sorry :) Im just trying to get c:\1\2\ or c:\1\2 >From this path c:\1\2\filename.ordir using SHLWAPI lib or s...

Documentation about CRM 1.2 db structure
Does exist any documentation about CRM 1.2 modules and related underlying SQL tables? Does exist any documentation about mapping between CRM 1.2 SQL tables and CRM 3.0 SQL tables? Many thanks If you install data migration tool, there are some excel spreadsheet contains the fields for the given entity. I don't know if that's what you are looking for. In terms of the SQL table, CRM 1.2 and CRM 3.0 is similar. All the custom attribute will be in the extension table. E.g. AccountBase, AccountExtension. Hope this helps. Darren Liu Crowe Chizek and Company http://www.crowecrm.com On ...

running macro when workbook is openned
I have the following macro it should run when the workbook is opened. I keep getting an error message. Any ideas. Isthere something that is missing Option Explicit Sub Update() With Sheet5 ActiveSheet.Unprotect Application.EnableEvents = False If UserForm4.CheckBox60.Value = True Then Sheet5.ComboBox3.Visible = True Sheet5.Label5.Visible = True Sheet5.TextBox29.Visible = True Sheet6.ComboBox3.Visible = True Else UserForm4.CheckBox60.Value = False Sheet5.ComboBox3.Visible = False Sheet5.Label5.Visible = False Sheet5.TextBox29.Visible = False Sheet6.ComboBox3.Visible = F...

"Global" search in a workbook?
I have a large workbook with several sheets with similar contents. I need to search for various text strings in the workbook and want to find all occurrences, regardless which sheet they're on. The only way I have managed is to open one sheet at a time and search for the string, which is extremely tedious.=20 Is there a way to perform as "global search" in a workbook? That would help me a lot! Thanks, G=F6rel G�rel Do a search for flexfind on google. This is an add-in that will list all occurrences of each find, in a dialogue box. Andy. "G�rel" <gorel@dang.s...

Join Query
Hello, I am using Access 2003 with no ability to switch versions. I have two tables. 1 is the current inventory of Fuel Cards, and the second is the new inventory of Fuel Cards. I want to find all the NEW Fuel Cards that exist only in the second table. SO I have list A and List B. I want to find all the entries in B that are not in A. A has a two field Primary key. (Fuel Card # and FuelCard Provider) B does not have a key but for all intents and purposes, it has the same key ( though it is not defined within access). Here is the SQL code the wizard gave me. SELECT ex_FuelCardInpu...

Public Folder Recovery #2
I had a Exchange 5.5 SP4 installed on Windows NT 4.0 SP6 Server. We got a new server. We installed Windows 2000 SP4 and Exchange 2000 SP3. We joined the site and moved all the mailboxes over. Everything is working except the Public Folders. I just copied and pasted the PUB file from the old server to the new one and mounted the database. I saw all the folders so I didnt think much til the next day people were claiming they could not access the Public Folders. The size of the PUB file is about 7 GB. I already took the steps to delete the Exchange 5.5. Is there a way I can get this to se...

Formatting Numbers Help #2
Hi there! Is it possible to type 1210 into a cell and have it formatted with a decimal automatically placed to make it 12.10. If so is it possible to have it summed in another cell to =Sum(A1:A3) in which you have 1210 entered in all three cells... the total would be 3630 formatted as 36.30 Is this possible? Thanks Craig Using Tools | Options, opening the Edit tab and setting Fixed Decimal ON and set to 2 you can enter 1210 and have 12.10 appear in the cell. However, this will apply to ALL cells in all books that you open until you reset the option As for the SUM() questions...

If Statement Overwhelm #2
Hi All, I said to myself "I can figure this out, don't bother those nice people on the Exceltip board". That was 3 hours ago, I give up, mercy!! Here's what I need: there is a value in cell L2 and a value in cell M2. I am trying to write an IF statement that will do the following: *if L2 <.615 and M2 >.615 then say "YES" making that cell be highlighted green would be an added beautiful thing but not necessary *if L2 > .49 and M2 < .49 then say "NO" making that cell be highlighted red would be an added beautiful thing but not necessary ...