Hello, my quesiton is about formula auditing. When I audit a cell that references another cell in a different workbook, I get a line that ends in an icon of...

How do I set my defaults in Excel 2007 so that the text I put into a word art text box resizes automatically when I change the size of the text box. Right...

From Excel, I would like to test if a txt file is in a certain folder. For example, I would like the simple code to know if mytext.txt is in folder...

Hello, I have a basic pivot table in which I inserted an outside filter to provide the top 10% of the grand totals. Now, I would like to do chart of some...

Excel 2002 help on filling a series of numbers refers to "Use the Series command on the shortcut menu". Nowhere are the series command nor shorcut menu...

Hi, How do i transfer data from one excel file to another excel file? Is it possible to use a data connection or what other possibilities are there? Ivan

I created a pivot chart in one worksheet. I did some formatting on the chart. Then I made a 2nd copy of the worksheet wanting to re-use the same format....

I am trying to create a worksheet layout in excel 2002 where the bottom portion of the worksheet changes based on the type of device being evaluated. The...

In my spreadsheet I have two values which lead to a certain formula, the type code and shape code to be specific. Like I said these values lead to a formula,...

Hi Everybody, I'm trying to merge 2 databases (both in .csv files) using Excel, each having about 8 fields. I need to merge them by 2 Fields "SerialNumber"...

Column A and column C are both 10 positions long. I need to create list E with all entries in A that are not in C based on the following conditions: If A and...

I have two worksheets one for attendance and one for terminations. I want to create a macro where I will have a text box that the person will fill in...

On the bottom of the sheet I show a summary from the sheet itself. How do I automatically display all unique values listed from certain column. In second...

Would one of you please explain the following code to me step by step? Sub test() Dim x As Range On Error Resume Next Set x = Application.InputBox("Select the...

Hello, When we run the following VBA to open the password protected workbooks, it will prompt us to fill in the password. FileNameXls =...

Hi, I am using Excel 2003 and have three types of Work in my Pivot Table: Erect Alter Dismantle This work type is my outer row in my pivot table but it is...

Hi I have noticed that there are a few posts showing how to calculate somebody's current age by inputting their date of birth. However, what I am after is...

I made a macro on the excel and at the end of the macro I save it on a new file. Can I put the date when I save the file as part of the file name? Here is...

I'm a genealogist building a database using Excel 2007, but I can't sort by dates in chronological order as Excel does not recognise dates pre-1900. I want to...

Hi guys and gals I have a problem concerning the TypeGuessRows Registry entry. I know that i have to set it to 0 to be sure that mixed types (stris, int)...