I was trying to write a macro in which I was copying a selection from a combo box into a second macro which would then be run under instruction from the first...

I want to use roundup formula in a few different rows in a worksheet, anything above .30 will be round up to next nearest number such as 14.30 will appear as...

Is it possible to insert a column in a pivot table and then put in a forumla?

I'm new to functions and formulas in Excel. I need to write a series of functions: If cells A3, A8, and A12 are greater 4, then the result is 3. If cells A2,...

I am self taught in Excel so my knowledge is very limited. I can create simple formulas but I am having trouble with this one. I need to take the daliy hours...

I used the formula for adding number of entries, but now I need to change it to add the amounts that were collected during each...

What formula would I write to lookup a data match from another file that may be in several columns? Example: File #A - Contains "RF01" in cell F6 File #B -...

Hi Folks! Anyone know where I can find info on the argument values for GET.CELL? I saw a post a couple of wks ago that had a link for a help file from MS but...

Values versus Formulas in a spreadsheet? Thanks...

I have an Excel problem and I was wandering if anyone could give me their 2 Cents worth. Let me explain. I will have 2 worksheets Lets say A and B. ...

How can I go directly to the cells in another worksheet that are linked to a specific cell (so as to not navigate a large spreadsheet to find them)?

Hi I have a column of phone numbers e.g. 1555-555-1212. What formula do I use to change all the numbers to e.g....

Column A contains material name and Column B contains usage. I would like to choose the name and the total usage of materials that were used. For explanation...

Hi All, I have compile a spread sheet which among other columns has one with contains numbers. These numbers are not unique and may appear several times in...

Hi I have a am trying to count occurrences of someone entering data into my table. The below function counts every occurrence where Maximo A2 to A1398...

Hi, My iserted images and trace precedents lines move around with the scroll bar and the latter can give me some erroneous cell links when vertical. Can anyone...

In a cell I would like to have a function that makes appear the last save date (as it's possible with word insert/field/savedate). Does someone know if this...

Can I move my Xmas card address list which was created in a Word 2000 table (and then used to print address labels) to an Excel 2000 spreadsheet (Excel allows...

when I am adding a combo box from the forms toolbar, I get a message that says "no more fonts can be added to this workbook", I click OK and excel closes...? ...

Hello, I am encountering problems with de VLOOKUP function. I have a database with prices and company names. I have calculated the max. price per product and...