General

Importing data from another spreadsheet to a different format
Hello. I'm trying to take a list of items in a simple array and import them into a second excel file. This second file is formatted much differently, and is incredibly large. I was using a simple copy and paste for a while until I realized that this process would likely take me a month or two to get through ... 3 Jul 2008 17:40

Importing unopened worksheet into an open Workbook
Hi Dave or Anyone out there: I was wondering if you could help me. I have 3 sets of workbooks in 47 different languages. Workbook A has the following: A header row that displays the following ColA = Country ColB = Language ColC = Section ColD = Phrase ColE = Num ColF = New ColG = Country Specific Then sever... 3 Jul 2008 17:40

How do I suppress repeating data in Excel
I am importing data into Excel and there are many rows where the first column repeats 3-4 times. For example, the first column lists a patient name, while the other columns list different payors and related information for that patient. I would like to print the name of the patient the in the first row it ap... 3 Jul 2008 16:38

Date Formula
Column A has an investment date Column B has a redemption date I need column C to tell me how long the investor was in the fund. I know I can subtract column A from C and divide by 365 days, but isn't there a more direct formula for this? ... 7 Jul 2008 09:24

Referencing Path
Currently I'm working in an excel sheet with a summary page that is linked to a number of tabs that support it. In the 2003 version of excel I would be able to double click the cell and it would take me to the referenced cell on the appropriate tab. However in the new version Vista it does not do this, but inst... 3 Jul 2008 18:41

Print Page #'s
Is there a way to get the page numbers "Page 1,2,3" to print across the center of the page as it does when in page break mode? -- Deb ... 3 Jul 2008 16:38

Change font in portions of cell with many characters (1000's)
In a "normal" cell, I've been able to go in and change the font color/bold/etc. for several characters in the cell as desired. I'm trying to do the same thing programmatically for a cell with 1000's of characters and it's not working. I've tried it manually as well with no success. Is there a limit on the... 3 Jul 2008 18:41

Background
Is there a way to print these like a watermark across the page as they on the screen? -- Deb "Dave Peterson" wrote: View|Normal You see the page numbers when you're in View|Page break preview mode hubbyhub wrote: Someone sent me a excel file and in the middle of the worksheet it ... 3 Jul 2008 16:38

Possible Array Solution Needed?
So here is my current formula: =(((((((((((((((((((((((J32-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))- I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L $10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10))- I33/12)*(1+$L$10))-I33/12)*(1+$L$10))-I33/12)*(1+$L$10)+I33-J32 J32 is my Endi... 7 Jul 2008 11:28

Search for multiple strings in a list (w/in 1 cell) w/ Advance
Thanks for the reply Jim, Currently, I can search in 2 ways , I search for *german *french OR *french *german (2 rows of criteria) or I search for french first and filter the results for german. (By the way *german* *french* work exactly the same) But what I wanted to do is to just search for (german, french), ... 7 Jul 2008 13:32