It sounds like you want to use *relative* references. Hard to say without
seeing your formula and an explanation of what the formula is supposed to.

--
Biff
Microsoft Excel MVP


"Roy" wrote in message
...
Hello group
I have some problems with my excel because when I tried to do absolute
reference in getting the percentage and dragging it down it will just
copy what is on the first cell down to the end ..
This what not what it used to be before.
Can anybody tell me how to troubleshoot this?
TIA
Roy