Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2009

    Question Unanswered: Adding 1 value to specific formula in many cells


    Well I need to add a specific value to a formula in many cells at the same time...and that formula is linked to another workbook
    Doing it manually is taking a lot of time

    for example:
    ='[01 Time Sheets.xls]02'!$BJ$8 and I need to make it multiplied by a specific cell to be ='[01 Time Sheets.xls]02'!$BJ$8*B6
    for around 700 cell without changing the formula itself as the $BJ$ does vary but the B6 doesn't...

    Please help that's urgent...

    I really appreciates your help, Thanks in advance...
    Last edited by Rozza; 02-19-09 at 10:38. Reason: Long title

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts