Changing a range of cells to an absolute reference

I have a spreadsheet with two worksheets in it and one uses cell values from the other. 'Data Entry' is where the data is entered and 'Summary Final' is where the information ends up. I need to be able to change the reference in the 'Summary Final' sheet to Absolute ($). I know I can change one cell at a time by using F4 (I learned that here) but I need to be able to do a large number of cells at one time. I have 15,000 cells to do and doing it 1 cell at a time is not practical.
Thank you in advance for help, I hope I have used the correct terms for this problem as I am not well versed in Excel.

Post the workbook, or an example of the workbook which accurately portrays the formula and cell locations.

mew!

Might take a look at this link and use the code there.
Convert Excel Formulas from Relative to Absolute

Try this:

Please Login or Register  to view this content.