I have several worksheets that have the same rows and headers but different data and I'll need to add new rows with headers as new projects start. Is there a...

I'm using Excel 07; I need to set conditional format based on dates. Row "C" projects 4yrs 6months from "B"; I need each row to change colors based on: "C"...

I have a list of numbers: 900 1030 830 etc. I need these in the format: 09:00:00 10:30:00

How do I write a conditional format that applies to "=$N$13:$N$22,$N$31:$N$40" where If $L13$N13 fill the cell RED. This is what I have in the Format...

I have a large Workbook with macors. One macro duplicates a template worksheet with mutiple conditiional formats. The Formats in a set of cells has 5...

Hello, I'm using Excel 2003 and I have a worksheet with data in approx 1500 rows and in columns A - AN. There will be approx 8 people making updates to this...

Hi, can any one help me please, I have two workbooks that are linked using special paste and then paste link, but for some reason just lately the links have...

I neeed to merge 16000 rows of data with some duplicate vales. Poor record keeping lead to two lists and each was updated independantly if at all. Some...

Hi there, I have a little problem on arranging a small multi-worksheet excel here. Let me explain in a short way then give some details on it. I am trying to...

How does one set the default comment format (font, etc)?

I have created a "Navigation" tab that has buttons using macros that take you to all the other tabs in my workbook. I used VBA code to hide all my tabs...

I am trying to schedule Teacher conferences at our school. I have each teacher in a column and need to show only the columns that I am scheduling for each...

I want to back up excel and Word onto a stick. how do I do that?

i need to show numbers to 3 significant figures. in one column, the numbers should show as 5.36, 7.56, 20.8, 47.6, 171, 291, 1070. all to 3 significant...

I have 500 rows of data. All row heights are currently at 15. For a given column width, I need to wrap the text for about 100 rows to fit within the column...

Testing

If cell A1 contains a ref EG "C:\ Photos\Pic1.jpg ( this could be up to Pic200).Is it possible to insert so that Pic1 appears in cell "f1" ? I have...

I want to effect a mass change to the sign of numeric values in a range of cells (rows and columns).

What I am trying to do: I have a list of 35 clients (column B), a row of 7 available catalogs (row 1: catalogs 1-7 in columns C-I). We have approximately 50...

What I am trying to do: I have a list of 35 clients (column B), a row of 7 available catalogs (row 1: catalogs 1-7 in columns C-I). We have approximately 50...