I want to combine multiple worksheets from different workbooks into one. There are text boxes with more than 255 characters that require me to go back and...

I am trying to compare two colomuns of data and produce a report showing the differences. So far non of the formulas will work for what I need and I am...

I want to move older files (excel) to a disc and when I hit save and to where D drive on a disc it say file says read only and won't let me save it. What can...

How do I turn the results of the "if" calculation a certain color depending upon what the formula returns?

I need to know if I can sum cells that contain numbers and text in a cell IE 2C + 4T. I want to ignor the text part of the cell data and sum the...

Hello!, I will try to be brief. A series of Excel spreadsheets were created inadvertently by a secretary using the save as feature. Each has its own name....

I would like to combine two cells into one and do a "carriage return" so that the data from the second cell is started on a new line....ie a1 ...

Count the number of times in multiple rows that column a = sold and column b = 1 Logically Count If A:A="sold" and b:b=1

How can I keep someone out of the "File Print" area on a protected workbook/worksheet? The only cells accessible are the ones that I want used for data entry,...

I would like to have cells put data in if another cell has a certain name appear. Example Nmae appears in cell A1 I want cell A2 insert SSN, Cell...

I have a worksheet that is protected that has places for data entry that works fine. It also has subtotaling to outline the sheet. Is there a way to make the...

I have a paste link cell in a spreadsheet, referring to a source cell in another spreadsheet and cell. Is there a way in VBA to open that source spreadsheet...

Can anyone tell me if their is free software that I can use to find my password to my excel spreadsheet, Thanks Wayne

I upgraded from EXCEL 2000 to 2003 and I see that there is LESS Border Options to use. Is there some way I can Import some of those from 200 or add in any way?

I have a report that is pulled via Crystal Reports and imported into Excel 2000. I pull this every day. I need a way to compare and update the data from one...

I am trying to figure out how I can compare data on 2 different worksheets. Here is what I am trying to do... I have Worksheet 1 (WS1) and Worksheet 2 (WS2)....

Help please I can not figure out a work around. I have a formula in excel 2002 that works fine. =EDATE(AS14,-1) When opened in 2003 it appears #NAME? I...

Hi All Let's say I have a formula in cell c1. It references a number input into cell a1, and does some math with that cell and a fixed number in cell...

I'm stumped. I have a column of data such as the simplified version below. For the example, for the eleven numbers below, the average is 3.0. I want to...

I need away to dynamically change the print range for a sheet that contains a pivot change in which the number of columns and rows may change. I've figured...