dynamic chart- curve drops to zero ( Line) Hi all i using following formula and description for the dynamic chart. Please do the needful In B1 = Project start date , C1= Mar-10 In B2= Project duration , C2= 30 ( which may vary) In B3= Project Cost , C3= 10000000 In C6=+IF(ROW()-ROW(C\$6)+1<=C\$2,DATE(YEAR(C\$1),MONTH(C\$1)+ROW()-ROW(C\$6),DAY(C\$1)),"") T... 2 Feb 2010 17:31 date help Ive been trying to use an if statement to put a static date in a cell when a certain condition is met. I do not want that date to change(update when the workbook is opened in the future) how can this be done?? ... 2 Feb 2010 17:31 moving entries between workbooks I'm self employed, for record keeping I have an invoice, expence report and balance sheet. I fill out the invoice, then the expence report moving the invoice amount to it so I get a snapshot of the week, then the totals from there to the balance sheet. How do I get excell to make those moves for me? -- Steve ... 2 Feb 2010 17:31 CAN A VALUE BE RETURNED WHEN TEXT IS ENTERED IN A DIFFERANT CELL? I am trying to get one cell to return a specific value when another cell has a letter entered into it. example: If R is typed in a column serveral times on differant rows the next column would return 15 as a value each time. Does anyone know how I can do this? If something other than R is entered in the colu... 2 Feb 2010 17:31 Excel 2007 ate my fields When I try to update a pivot table (created in Excel 97, later updated in Excel 2003) in Excel 2007, some of the fields from the source database are not available. (Plus it offers fields from other sheets in the workbook, but that's another issue.) It's the same when I try to create a new pivot table - all th... 2 Feb 2010 17:31 Using Popups to supply variables Hi All I sue this macro to find and replace a number in column I Columns("I:I").Select Selection.Replace What:="5.95", Replacement:="2.95", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False I'd like to replace the val... 2 Feb 2010 17:31 #REF! error with Multiple Documents I keep receiving a #REF! error when I try to use VLOOKUP to find data in one document and bring it to another. If both documents are open all the numbers are fine. However when I close the book with the data I receive the error, or when the vlookup book is opened it does it. If tell it to update the data error,... 4 Feb 2010 22:30 Copy sheet to new sheet I am having a problem with excel 2007 with copying sheets. I can copy a sheet repeatedly until I rename the sheet and then copy again. I get a message that says the sheet I'm copying contains the name 'M' which already exists in the new sheet. First, the sheet has not copied yet. Two, I have searched the sh... 2 Feb 2010 17:30 Insert file last save date into excel 2007 footer How to print the excel 2007 file's last save date as part of the footer? Google search found only http://uk.answers.yahoo.com/question/index?qid=20081104112053AAnWFdY, which does not work for me. ... 2 Feb 2010 17:30 repeat entry from previous column Is there a function key that will repeat the value entered in the previous column similar to access with out having to copy down? ... 2 Feb 2010 17:30