you just saved me so much time.....thanks a bunch....wont forget that trick

"Tyro" wrote:

=B3 * $W$5

Tyro

"Chrj15" wrote in message
...
Doing this causes the next cell to multiply by W6, and the next by W7...so
on.....

"Gord Dibben" wrote:

In C3 enter =B3 * W5

Drag/copy down to B12


Gord Dibben MS Excel MVP

On Mon, 4 Feb 2008 20:13:01 -0800, Chrj15

wrote:

I'm trying to multiply column B3:12 by cell W5. B3:12 contains a set
number
and I'm trying to multiply that number by the formula result in W5.
I've
tried every special paste option and combo. Also W5 is connected to a
spinner. I need B3:12 to adjust as W5 does. So far I've had to
manually
link all the cells to W5. Uggh.
Any help appreciated.