Please Help...

I have a spreadsheet I am using for inventory numbers and costs. I
have several worksheets that link to this the inventory sheet. I know
when I link to a cell and put "$" in front of the cell, it will make
the formula fixed on the inventory sheet. My problem happened when I
added new rows and sorted my data. None of the cells that I had put
the "$" in front of the cell followed the data to the new cell after
sorting.

How can I fix my formulas so I will be able to sort and have the
formulas stay fixed?

Thanks so much,
LB


--
LBDuperon
------------------------------------------------------------------------
LBDuperon's Profile: http://www.excelforum.com/member.php...o&userid=24971
View this thread: http://www.excelforum.com/showthread...hreadid=384971