General

Auto fit text in cell of a protected worksheet
Good afternoon. I have a form with protection and validation in several cells; some are left unlocked/no validation to allow for free form text entries. My problem is that when i protect the sheet, Excel doesn't auto fit the text in the column/row and the user is not able to either. (I don't want to allow F... 8 Jul 2008 15:10

Can't find answered question.
Well, I accidently just stumbled upon an answer myself. Although those links are to the right place, one needs to be logged on to the site in order for them to work. If you go to the Communities site first and log on then the link will open properly. I'm wondering if using the "Save my email and password" optio... 7 Jul 2008 13:32

Does anyone have a generic 'warranty approval' form/document?
I am looking for a form (preferably in Excel or word) that is used to document and approve/deny a warranty claim from a customer? I work in the Industrial/commercial business arena and need an approval process for handling warranty claims. Thanks, ... 7 Jul 2008 17:39

FREQUENCY FUNCTIONS
I'm using excel 2003. When i join the content of two cell, using the & formula, i want to perform a frequency function on the new cell, but it gives back a result of 0, although if i type the data of the two cells into one manually and perform the task it works fine. Any ideas on what i can do so it will recogni... 7 Jul 2008 13:32

Customize macros Very urgent
Hi Excel folks, Stuck with a huge problem here. I have huge list of columns with First name, last name , middle name, mailing address , e-mail id ..... etc, Now when i pull any data, i need a macro which shows only the content with data, for instance if there is no mailing address, the macro should disable the... 7 Jul 2008 14:33

Lookup formula to return all instances of match?
Hi there Please can you post how you were able to achieve this? Or can you email at anthony.vaz(a)pirean.com, as I need to do the same thing Many thanks "CParker" wrote: Nevermind -- I figured it out! THANKS SO MUCH!! "RagDyer" wrote: Say your list is on Sheet1. In A1 of Sheet2 enter... 1 Aug 2008 10:57

Linking Text
Is it possible to link text in Excel? I keep track of admissions and discharges for residences and I would like to be able to link the names of individuals from one spreadsheet to another. I keep track of number of days in a residence, pass requests, and also when a resident is eligible for dental work. It s... 7 Jul 2008 13:32

remove duplicates from one cell that has been combined
I have 50 columns. In column 51 I combined the data of each row into one cell using the concatenate function. I now want to remove the duplicate data from each cell. Should I use something else besides concatenate. I will also have to combine the data of specific columns and then remove the duplicate da... 7 Jul 2008 13:32

XML File Opened In Excel is Missing Header Row
I have a vb.net console app that creates an XML file with a corresponding XSD. My users open the file in Excel 2007 or Excel 2003. If the XML file only has 1 record, the header row does not appear in the spreadsheet. When I have more than one record, the spreadsheet is perfect. Is there some way to configur... 7 Jul 2008 12:30

Macro to insert an object in a specific cell 2007`
I am trying to insert an object in a specific cell. i can get it to work in 2003, but not in 2007 does anyone have any insight as to what i am doing wrong....here is the code that i am using Sub test() ' ' test Macro ' Macro recorded 7/7/2008 by mspears ' ' Range("B30").select ActiveSheet.Pictur... 7 Jul 2008 14:33