I receive a document in a htm format. I then export the data I need to an excel spreadsheet. I want to creat a macro to save this excel doc to a shared...

Reposting... I have a table with 3 columns of text where column A maps to multiple values in col B which maps to multiple values in col C. e.g. X Y Z X ...

Is there a way to perform a summation expression in Excel? For example, I need to sum 1 + 2 + 3 + 4 + 5. I can easily type 1 through 5 in five cells and use...

I posted earlier as a Novice, but have since reduced myself to idiot status. Working on our budget for 2006, which up to now is largely a manual process. We...

The regresssion tool says the limit is 16 x's. I have 30.

There has to be a way to hold the numbering format in excel spreadsheet when it converts to data source for mail merging. Help!

I would like to have an auto updating date for a timesheet. At the start of the week the date would show the date at the end of the week. At the start of each...

I have a small but frustrating problem with an excel formula. I have a formula that is adding a bunch of cells (cells are not in a range). The original...

I have got something like: =IF(OR(AND(J3B3,J3C3),(AND(J3E3,J3F3)),(AND(J3H3,J3I3)),TRUE,FALSE)) In words, I am trying to say: IF the value in X is...

Hello, I want to add a range of values, but they are formatted differently: some of them are formatted with the dollar currency, others with the euro...

Hi all, I would like to use autofill in a macro, but the length of the range is changing every time when I open the workbook. The task would be that when I...

Bernie, sent me a macro (Jim macro) that automatically sets the row height based on text length, given the column width. The works well. Unfortunately I have...

What function or macro would I use to return the last list information in a given range of row even when some cells are left blank?

Is it possible to transfer data between worksheets within the same workbook. E.g. if I wanted to track holidays and have the dates entered into...

I want the user to select a workbook and have that workbook name and values used in a macro. I'm trying to update it weekly with new totals etc ON the...

i have random numbers generating from 1-100 on the same number of cells (h:1-h:100). what i would like to do is see how many times a number comes up in those...

is doing a SUMIF over multiple columns not allowed? This formula works =SUMIF(C:C,J5,E:E) but this does not: ...

I am making a new spreadsheet to record daily blood pressure readings. Each day's readings go into a row below the previous day's readings. I can...

Does anyone know the expression to format text, say in cell A5, to blue if the value of cell A4=0 and to red if the value of cell A40? I know how to do...

I am trying to enter a formula in a worksheet. I want the formula to do the following: IF A1=40 then enter 1, if less that 40 enter 0, OR IF A1=45 enter 2,...