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
='[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 11:38.
Reason: Long title