I am using Excel 2007 and here is an simplified example of what I need. Items Price Potatoes 4.35 Apples 5.55 Oranges ...

How can I open a particular workbook at a specified time of day. For instance how could I automatically open a workbook called IRS at 2:00AM every...

HOW CAN USE BATHTEXT FORMULA FOR CONVERT FIGURE IN TO WORDS PLEASE EXPLAIN STEP BY STEP

I would like to set up a formula that uses the text from an adjacent cell to determine the sheet and cell location that is used in the formula. i.e. instead...

I am appliing 2 Codition to add data from excel worksheet howvere it dose work and the result is Zero. Plaese help me throgh...

Hi, I am trying to sum the sales values of months (say Jan to Mar) with the start month being fixed and the end month being a variable. I have therefore...

When filtering: some of my sheets have blank lines inserted & i am still able to filter the data below the blank lines. Sometimes I can not. Why?

Need a Formula for the following: Data Table A B C D E F G H I 1 Tom A W 2 H 30 84 30 2 Peter A W 3 H ...

Hello Does anyone know of a way I can create %s of subtotals in a pivot table - instead of % of grand total. I need to create a table from a cube which has...

Using EW2007. Trying to insert a calculated field into a pivot table. It's not displaying any results besides zero's on the calculated field. I think what...

Hi, Need help please with: I have a data sheet with many columns of data. I have another sheet with a summary of some of the data as follow: Result sheet...

I have 2 separate worksheets with similar information. My Plant column in worksheet 1 has some empty cells. I want to return a value for Plant from my 2nd...

I have first names in one column and last names in a second column and I need to combine them in one column for an import. The formula I usually use is =A1&"...

Could someone provide a macro that would unmerge and of the cell in excel and then delete all of the blank cells. Thank you in advance! Best, David

I have and excel file that has multiple worksheets in it. One of them is a cost and price generator to be able to write up an estimate for a customer and...

I was entering data into a spreadsheet today when all of a sudden when I went to a new row, as soon as I started entering numbers it jumped to some obsure...

i have a worksheet that i want to hide rows based on cell value. if cell B3 is blank, then i need rows 4,5 and 6 to be hidden, B3 contains data than row 4...

I deal with spreadsheets that I create for our customers that involve tracking numbers from both FedEx and UPS. I'm curious if anyone knows how to...

I dont even know where to begin with this one... If Column A has the digits 23, 83, 849, 759 and Column AL has the word "RESEARCH" then provide me a list of...

I'm trying to set up liquidated damages for some purchases. The criteria for days late is as follows: days late 1-7 is $1000/day, then days 8-14 are...