How would a macro read if you highlighted an area then run a macro that would cut and paste that area to a specific location? any help would be appreciated...

I see that I can only use 3 conditional formats. I need a few more than 3 is there any way to do this. Kevin

We have a software package from which we can export data to MS Excel. However, when exported it arrives in Excel as text. Even though they are numbers, they...

Is there a way to use a formula to dictate a cell reference? eg. if cell A1=2 then =B(A1) would reference cell B2? I saw someone else with a similiar...

PivotTable formatting changes each time the "Refresh Data" button is clicked. It is very frustrating to have SOME formatting changes each time the data...

When I search for items in the Excel VBA Help system it will return a list of items, many of which do not function as hyperlinks. For example I have noticed...

Is there an easy way to merge information that is currently in different cells so that it's combined all into one cell?

On several, but not all, workbooks, when I save I get a box up with the message: "The file 'filename.xls' may have been changed by another user since you last...

I just installed Office 2003 and transfered excel files from the older version. The comments that I had created before I moved to 2003 look fine in the default...

I have queries set up in an excel workbook to pull data from queries in an Access database. There has never been a problem with this workbook before, but for...

Hi, I have a large spreadsheets which has changed to Itterations and manual calculation. I have just upgraded from Excel 2000 to Excel 2003 and have a...

I am trying to copy a number of cells with comments from one workbook to another, the contents of the cells copy but the comments themselves will not. Please...

I'm working on price books for the company I work for. The vendors just email us the suggested retail price in excel format. I have to put in a formula to...

"Dale Fye" wrote in message ... I have an Excel workbook that contains several...

In both sheet1 and sheet2 I have hundreds of records. 60% of the records in sheet1 are also in sheet2. If I concatenate 2 of the fields "LastName" and...

Hi, I inherited working with this file to make some changes. When I do an Edit|Links it shows that this file is linked to another file but I can't find the...

Hello, Is it possible to create a formula using a cell value to create a formula. basically I have multiple sheets with the name as a month. I have one...

I downloaded a database from an AS/400 and now I need to change numbers to dates. When I format it changes everything because it is reading the number as a...

Worksheet Tabs at bottom of Workbook I have about 80 worksheets in 1 workbook..... These names change...from time to time. And thus, I would like to sort the...