02-19-09, 10:32
|
|
Registered User
|
|
Join Date: Feb 2009
Posts: 4
|
|
Adding 1 value to specific formula in many cells
|
|
Dears,
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
|
dBforums
>
Need to add 1 value to specific formula in many cells at the same time
Linear Mode
