Getting Data from another sheet? #3

WHere do I save it to

bludovico's Profile:
View this thread:

10/7/2004 3:17:27 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 28

Hi bludovico

The manual is not ready yet (First version of the Add-in)

Save the file where you want on your PC.
Then in Excel go to Tools>Add-ins.. Browse to the file..OK
You see it in the list now (Select it)

Regards Ron de Bruin

"bludovico" <> wrote in message
> WHere do I save it to?
> -- 
> bludovico
> ------------------------------------------------------------------------
> bludovico's Profile:
> View this thread:

rondebruin (3790)
10/7/2004 3:59:10 PM

Similar Artilces:

Find MAX data in sheet (Cell)
How would one go about finding the cell that contains the MAX info, o say any/all cells that exceeds 8,000 characters/spaces in a Excel page -- confuzedagai ----------------------------------------------------------------------- confuzedagain's Profile: View this thread: 1. Highlight the entire document 2. Select Format->Conditional Formatting 3. Select "Formula Is" 4. Input this formula =LEN(A1)>8000 5. Format with something obvious like green bac...

.NET 3.0, 3.5 SP1, Media Center Issues
Well, I managed to download .NET Framework 3.0, in lieu of 3.5 simply DISCONNECTING non-stop, and though it (3.0) tells me that it has been successfully downloaded and you can now disconnect from the internet", "setup is proceeding to install it" etc., and not more than a few seconds elapse before it tells me that "an error occured, all files are being removed from the computer" icon is on the desktop, and I'm advised that when I click on the install icon it will be installed...again, and nauseam. 3.5 SP-1 will not even complete downlo...

duplicates #3
Dear People, Does anyone know how to delete duplicate entries from excel? With conditional formatting it seems ezy enuf to find dupliates but how to delete them ... apart from one at a time that is. Ok when the list is short but when its long as your arm, that can seriously cut into ones drinking time. John One way .. Take the sample data below assumed in A2:A5: > Mark Davies > John Smith > David Jones > Mark Davies > David Jones > John Smith Put in B2: =IF(COUNTIF($A$2:A2,A2)>1,1,"") Copy down to B5 This'll mark any duplicates in col A with a &quo...

Newsgroups in Outlook 2003 #3
I know this sounds stupid, but I cannot find out how to get my newsgroups integrated with Office 2003 Can anyone send me the directions [ eg. files ->...]? Thanks //Andreas You cannot. Newsgroups require Outlook Express to read. "Andreas" <> wrote in message > I know this sounds stupid, but I cannot find out how to get my newsgroups integrated with Office 2003. > > Can anyone send me the directions [ eg. files ->...]?? > > Thanks! > > //Andreas Is that a n...

mailbox size #3
hi, I want to decrease the size of our users mailboxes to decrease their limits. To do this, I need to justify that any mailbox size over 500mb needs to be revised because ...(good reason). Does anyone have a MSFT document that explain something like that? Thanks I dont think you will find anything like that. What is your SLA in case of disaster and you need to do a full restore? On Fri, 04 Jun 2004 18:20:51 -0200, Marcelo Moraes <> wrote: >hi, >I want to decrease the size of our users mailboxes to decrease their limits. To do this, I need to just...

Can a macro open another worksheet?
Hello, I've got a macro that I need to run on about 200 spreadsheets. Is there a way to get it to select and open all 200 spreadsheets? Thanks, Art. Are they all in the same folder? In fact, do you need to open all the workbooks in a folder? Or all the workbooks in multiple known folders? If you have files in one folder--but you want to choose (click on the first and ctrl-click on subsequent in the file|open dialog), you can do something like: Option Explicit Sub testme() Dim myFileNames As Variant Dim iCtr As Long Dim wkbk As Workbook myFileNames = Ap...

Export data in XML through Web Services
I have a WebMethod that retrive data from a DB and I want to return this data in a XML format. I try to do with the TextWriter class but I wasn't able to do, because I didn't found any example thet explain how to use the Stream attribute. Can I use the TextWriter or I have to use the XmlDocument class? Thanks in advance -------------------------------------------- Massimo Rizzotto -------------------------------------------- can you show us the code now, and show us what you are getting on the wire and show us what you would like to get on the wire? This article http://www.15secon...

Share Workbooks and Comments #3
Can anyone help me with this one... I have a simple spreadsheet which is shared and resides on a server. Apprx 6 people access and modify the sheet and save their modifications back to the server. No 2 people ever change the same cell so there are never any conflicts. The problem I have is that often the comments in a cell do not upload to the server. The user is unaware of this util he closes and re-opens the workbook to find that all of his changes have been saved but none of his comments. I have been getting the users to make their own copy at the end of the day and if they e-mail that c...

Number format #3
Ah, works perfectly. Thanks -- carg ----------------------------------------------------------------------- carg1's Profile: View this thread: ...

Where do I get Visio 2003 electronics template?
On Wed, 4 Feb 2009 13:06:52 -0800, splendidbcpgm <> wrote: >Where do I get Visio 2003 electronics template? Would you like to have a look at my -- Regards, Paul Herber, Sandrila Ltd. ...

how do i search an excel sheet for links to another spreadhseet?
Is there a Find function that allows me to look for links in a sheet? When I can't find links, I'll use Bill Manville's FindLink program: Flutie99 wrote: > > Is there a Find function that allows me to look for links in a sheet? -- Dave Peterson ...

Open & update another file (through macro) while running macro
I am using MS Excel 2003 and I need help to solve my problem. One excel file (suppose A.xls) in which I’ll update my graph and the data is available in another file (suppose B.xls). What I am doing (through macro) is that I have created one button (in A.xls) and when I pressed it; its open the file B.xls (the data file) and at their I select month from drop down from which its update the pivot table based on the selection month and then same I was doing with another data excel file (suppose C.xls). Query : Is there any solution that when I pressed button from file A.xls its ...

data labels in charts
This is a probably one of the simplest questions but I'm just starting to chart again. I have entered a category title "year" in cell A1 and entered from 1995 to 2000 from A2 to A7 that I want to appear on the horizontal axis. I have entered a title in B1(unemployed) and 5 values B2 to B7 directly below. When I choose a "column" chart my vertical axis appears correctly but the horizontal axis does not include the years as labels. The labels that appear are the numbers 1 to 6 instead of 1995 to 2000. How do I make the chart pick up the data labels from colu...

Cell Reference #3
In a workbook, is it possible to know all the cells where a particular cell is referenced in a calculation. Specifically, if I make a change in one cell, what are all the cells that will be affected. ...

how do I get old versions of modified files?
I made a mistake and modified a file, how do I get back the old version? Thanks From your backup, which, of course you take every evening !!! John G "Power Image" <Power> wrote in message >I made a mistake and modified a file, how do I get back the old version? >Thanks ...

data extraction from excel
I need to pull information from one collumn. If the collumn is comprised of yes's and no's, can excel create a list of just the yes's? Try something like this: Assuming your list is in A1:B100, with A1: Question B1: Response C1: Response C2: Yes D1: Question (the same col heading as A1) E1: Response (the same col heading as B1) Select your list (A1:B100) Data>Filter>Advanced Filter List Range: (already selected) Criteria Range: C1:C2 Click the [OK] button to filter the list in place. OR To copy the matching records to another area: Click: Copy to another location Copy...

QUESTION- Simpler Way to Add a Data Series to Other Graphs?
Hi- I'm using Excel 2002 and I've got a lot of XY (Scatter) graphs. When I add a new data series to one graph, it is defined by 3 values (Name, X Value and Y Value) If I want to add this data series to 7 or 8 add'l graphs, I know that I can copy/paste these 3 values to each of them. Is there a simpler way to accomplish this? thnx ...

Compare two Sheets with Conditional Formatting #2
I'm going insane I'm trying to compare two sheets using Walkenbach's approach but for some reason when I use it...certain values don't show differences. Example: Sheet 1 (Range Name is Grid) has 18000 on Cell A1 Sheet 2 (Range Name is OldGrid) has 18000 on Cell A2 So if I change Cell A1 on Sheet 1 to 1 it should show me change but just does nothing. However if I type shows change. Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=COUNTIF(OldGrid,A1)=0" Selection.FormatConditions(1).Interior.ColorIndex = 40 Help really appreciate...

cannot copy from one pub to another
all of a sudden, i cannot copy and paste from one ms pub publication to another ms pub publication. here's what i've done: i ran disk cleanup. i ran norton live update. i ran windows update. i ran office 2000 update. i ran detect and repair inside help in pub 2000. none of the above helped. you said "is clipboard set to automatic in computer services?" can you tell me where computer services is? i looked in control panel, administrative tools, component services and computer management. I ended up in console root, component services, computers, my computer, found ms pu...

pasting excel data in a powerpoint slide
I am attempting to paste an excel data table in a powerpoint slide but once pasted, the data is cut off. If I double click and enter the excel data table and resize the window from Powerpoint, the same data shown simply stretches to the new size. I have tried numerous ways of pasting from the excel sheet and it still acts the same. I tried a new workbook and was able to resize correctly. But to recreate all of the data and formulas in a different workbook would be difficult. Is there a setting or something in excel that is not allowing me to resize this particular workbook? Thanks...

"Message Tracking Center" showing incorrect time #3
I have applied all of the DST patches for the OS and Exchange Server. OS is Server 2003 Standard (latest patches) and Exchange 2003 Standard (latest patches). I noticed today that when I go into the "message tracking center" teh defult end log time is one hour ahead of the computer time. Also, all of the sent times being tracked are showing as being sen one hour in the future. (i.e. real time is 3:00 PM, messages in tarckign center show having been sent at 4:00 PM). Any ideas? Thanks, Bob I don't have an answer, but I'm seeing the same thing on my system. "Bob...

many sheets from "master data"
Hi guys, In the last few days, ive posted some questions with some success, bu not being able to completely work though my problem. Given that I a novice/intermediate in relation to VBA, I am having extreme difficult augmenting the code to do what i like. Attached is the file so you can visualize what I am talking about. What I want to do is to put each "page" of data on a new slide. As yo can see, all the data is found on the first page. In column T, you ca see where each new page starts (as indicated by the data and pag number). I having trying tirelessly to get the code su...

Prevent equation from skipping data when referencing import data?
I am referencing data that is being imported from access in table on a seperate worksheet. When the data is refreshed, only the last new entry is placed in my seperate table, not all of them. How do I fix this? ...

Input formulas in a defined data range and convert results as valu
Hi, I have a dataset for users to view data. It has the following format till year 2010 and have portions of topics like forecast, shipment, aging .... and the whole dataset can go very long vertically. Within each topics is the type of products measured, below is an extracts of my dataset: Forecast Accuracy Jan 2007 Feb 2007 Mar 2007 Apr 2007 Prod A x x x x Prod B x x x x Prod C ...

Can't get out of selection? Assistance would be most appreciated...
Perhaps I have done something inadvertently. I am in an Excel workbook and I appear to be in the middle of selecting a block of cells. Everytime I move the cursor, the cell selection area changes. I can't Esc out, or use the Enter key. Mousing over the menu, the menu does not respond. Rather silly really, but I desperately need to use this workbook and nothing seems to function. Even when the cursor is moving over the menu items, the cells selected in the workbook area still seems to be changing. I can't use the menu - the arrow keys don't work. Does anyone know how to &quo...