When I choose a spreadsheet to open, I want it to open a new window. This used to happen but now opens in the same instance, just hiding my...

Hi, I'm pretty new to writing code, so I wanted to ask for some advice. I've got a code which checks to see if cells in two columns are equal, and if they...

I had posted a question titled "sort numbers" late Friday. And I have still not solved my problem. Would anyone be willing to take a look at the file and see...

Is there a way I can format a number so that significant 0's and a letter are conditional? I currently use: ?0"g" ?0"s" ?0"c" - which formats like...

Can anyone tell me if it is possible to do a search to go to a specific worksheet in a workbook. I have many worksheets (about 30) that are linked to others...

Hello, ive got difficulty how to show the column and row headers in Excel worksheets, can anyone help...

I'm currently using Office 97 with Windows XP, it's never problem. But now, when I want to open my file from another location or another folder with MS office...

Hi All Can anyone help me with a formula to calculate the Week Commencing date based on a date supplied? I found...

I need some help… In Excel 2003, I am entering in a column of cells; different numbers that I want formatted a specific way. For example: I enter this...

Hi all - I have built a rather complicated spreadsheet that basically calculates and archives all the stats for a disc golf league. It accommodates 6...

Dave, Thank you. I got rid of my comments (not easy) and that cured it. "Dave Peterson" wrote: The thread has aged off for me, but is this the stuff you...

I'mnot sure if somebody changed my options, what I used to do to select several cells using "Ctrl-Shift-left" does not work. Is there any option that I should...

Hi, I recorded a macro that automatically saves a file then change the formula in cell A1 to today's date, ie =today(), then save the file. I have a...

DataText to ColumnsNext works well if all entries have a "single" first and last name, eg, "Joe Smith". However, if there is a "Mary Joe Smith" listed, how...

I am trying to create a data validation formula. I want it to protect from user input that doesn’t meet the following: • If F50 = “Close� or if F50 =...

Anybody know where I can find a *complete* listing of *ALL* the Excel MVP's? The only info I can find is an abbreviated list of only those MVP's that provide...

In excel you can only have 7 nested if statements in one cell, i need a 10 nested if statement and my if statements are below Cell A1...

Mail merge will not pring envelopes. The same information can be printed in list form. I will appreciate any help. Thank you.

Is there a technique to shorten formulas such as this...

Hi, My brain isn't switched on this morning, this may be more straight forward than I think... I'm trying to do a Countif function, which only counts those...