I am trying to build up a YTD value in a cell on a worksheet named YTD. The YTD value is the sum of cell ref "A17" on each worksheet named JAN, FEB, MAR...etc...

I just realized my final sum changes if I use the "sort ascending" function..... How do I fix this ? thank u

I have an excel sheet with 6 columns and 75 rows. I need to input data into the cells, Is there a quick way to go from Row1 Column6 to Row2 Column1? At the...

HOW CAN I GET A LOTUS 123 SPREADSHEET TO AN EXCEL SS WITHOUT HAVING A LOTUS PROGRAM. THE LOTUS SS IS ON A FLOPPY.

Why does the screen move when I accidently click on a cell border? How do I turn this off? Its a real annoyance.

I've just been given instructions to create a process flowchart of one our business units. I see that I can do this in Excel, but has anyone used Excel for...

Does any version of Excel have collumns past collumn IV? What is the last available collumn in Excel v.3?

When I try to select a cell on a particular worksheet, excel will not allow me to select the cell, and instead tries to execute a macro and returns a "Macro...

I need to count the number of entries on sheet where=20 column D=3DROUND and column E=3D.01 AND less than .04=20 and

Hello, Is there a formula I could use to tell me if a cell contains the Letter "C" somewhere within the text. I am familiar with...

I am trying to install the loan analyser that came with Office 2000 0n my XP computer. Program that came With 2000 CD. Windows says to insert year 2ooo...

I'm trying to get the following formula to work. I16 is a data validation list (drop down list) and I keep getting the circular reference error message, can...

Hi, I do not arrive to create this personalized format who is responding to these 3 conditions (number is displayed in percentage). 1) if 0 the colour...

I have multiple databases in Excel with similar data that I need to pull into one large database. The only way I know to combine the information is cut...

I am currently using a spreadsheet and drawing a large number of graphs. I keep getting an error message "No more new fonts may be applied in this...

Format the cell for a date, and if it doesn't have that particular style you can customize it to be your style. -----Original Message----- I want to enter...

IS THERE A WAY THAT I CAN REARRANGE COLUMN ORDER BY SOME SORT OF SORTING. IE: A, B, C, D, E, F BECOMES A,F,C,B,D,E. NOT THAT THE ACTUAL COLUMN LETTERS...

I want to have a way to print the sheet tabs only... If one has a number of sheets .. and each sheet tab a "label".. and you want to print them only or get...

Is there any way to name a column in Excel? I mean where the actual ABC's are. Just sort of rename it. Does this make any sense?

How can I write a code from procedure to some Workbook's ThisWorkbook? With procedure1 a make Workbook with a table. I need to write Auto_Close procedure to...