Very Basic Question (problem)

[Willmonbo]

I imagine this to be a very basic issue but since I don't have the answer I'm posting it with the hope that one of you can help me.

I have developed over time a few utilities that i routinely use in my business, but all of them are located mainly on sheet1, and I constantly find myself scrolling back and forth depending on where on sheet1 that particular utility sits, it would be much easier to just distribute the utilities between the other sheets, can I easily move a block of cells with all it's components (i.e., formatting, functions) without messing up it's functionality, in other words some of the cell references will still refer to data on sheet1 and I need a way to move data and preserving the cell references.

 

[AlphaFrog]

can I easily move a block of cells with all it's components (i.e., formatting, functions) without messing up it's functionality, in other words some of the cell references will still refer to data on sheet1 and I need a way to move data and preserving the cell references.

For the cell references that you want to always refer to on Sheet1, create Named Ranges for those references and use the Named Range in the formulas. Then when you copy\paste to a new sheet, the Named Ranges in the formulas will still reference the cells in Sheet1.