Absolute References

[Musk Stick]

My problem is a little hard to explain so I hope this makes sense - I have a workbook with a main worksheet where all the data entry and calculations are made and then I have "sub" worksheets which mirror subsets (specific columns) of the information from the main worksheet. When information in the main worksheet changes, or rows/columns are added, I want the sub worksheets to update automatically.

The only way I can figure out to do this is to use absolute references in the sub worksheets. Does anyone know how to change the references to be absolute (using the F4 function) without having to do them one by one? Or can anyone suggest how I can achieve this in another way.

Thanks

[maybelle]

Hey,

http://www.asap-utilities.com/ is cool little add in that would help. Under the "Formula" menu, you can find the functionality to "Change Formula Reference Style". This can change all your references to absolute.

M

[sweep]

Hi,

There's also a macro in this thread

[Musk Stick]

Thankyou Sweep and Maybelle for your speedy help - problem solved!