I have a workbook with 11 worksheets. The first worksheet is the Fruits followed by Apples, oranges, grapefruit, grapes, plums, kiwi, cherries, peaches,...

is there a function which would calculate new date from a given date? e.g. column A row 1= 07.03.2009 I would like column B row 1 to show= 01.03.2010 - which...

Hello I know that I can do a formula like: $B2$K$1 in the formula box to apply a DF all cells in column B where the value is higher than the value in K1....

I have a list of Sales (column A) and a list of closing dates (Column B). On a separate sheet, I have a summary page showing total sales closing within...

Hi there, I am working in Excel 2007. My worksheet tabs are cut off and I can only see the first top half of the name/title. Also I cannot even see my status...

Hi, See code below. When I run macro I get 'compile error: Sub or Function not defined'. What am I doing wrong here?! Regards, Basta1980

How can I get Exel to display every (eg) 35th row only?

I am counting in one sheet, the rows of data that fit my criteria in another worksheet across multiple columns. See below: =SUMPRODUCT(--('Battle...

I need help on figuring out what formula to use. Here is what I am trying to do: My sales reps need to submit a date of when they found a prospect. With that...

I thought this wouldbe simple, or maybe I'm just missing it. I have a client's logo on Sheet 1 and the same logo on Sheet 6. I can't seem to find a way to link...

I want to copy a formula from one spreadsheet to another. I have copied it and selected Paste Special. When I do that, this is what I get. ='McPherson...

When using two or more "sheets" in a workbook, how can I email one sheet without sending the entire workbook?

I need some help. I am trying to turn a number in a specific range into a date I have a date and a value of the data for that date. I need to know how to...

I thought this wouldbe simple, or maybe I'm just missing it. I have a client's logo on Sheet 1 and the same logo on Sheet 6. I can't seem to find a way to link...

I've searched the previous posts trying to find an answer to this question - no luck. Is there a way to get spell check to work when the text is in a text...

i have this problem: i want to sum all the sales of one person but occurred many times using the SUMIF function. But i am not sure how to do it since i am new...

Can someone help? I have a workbook with 2 spreadsheets. 1 sheet is data and the other is the report. Both sheets have Rig no., Income and Expense Columns....

Hello, helpful people. I am not very familiar with Excel 2007, but I am gradually trying to become familiar. I'll try to be clear with my complicated...

Hi All: Is there a way to lock formulas in Excel 2007 so users can't change but can view original formula? I can lock/protect a selected group of cells within...

Does anyone see what's wrong with this formula =INDIRECT(""&DealPlatformType&" Platform'!C11") I am referencing Cell B4 in my worksheet (DealPlatformType)...