Create New Worksheet using Copy and Paste - Formulae only NOT data

bikequipsteve 

Hi there. If you want to copy only formulas instead of constant data, you can delete constants after you copy all. So copy all sheet and then select all of your copied data which includes formulas and constants.

Then Find&Select and Go to special. Then choose constants and delete them. And you can fill those cells to see which data you delete. You can see detailed screen shots below respectively.

and you can delete them.