Many thanks for you quick responce.
--
Big Rick


"David Billigmeier" wrote:

It will create an absolute reference. Let's say you have a cell reference
pointing to A1... If you drag that down to the next cell the reference will
change to A2. However, if you put dollar signs around the reference (i.e.
A$1) and drag down it will still reference A1.

--
Regards,
Dave
<!--


"Big Rick" wrote:

Please can someone explain in laymans terms why the $ symbol before a cell
reference in a formula makes a difference.

Thanking you in anticipation.
--
Big Rick