Excel spreadsheet copying cells unless formula

Hello   I'm having another issue with an Excel spreadsheet, it's 2 separate sheets which I'll call Spreadsheet1 and Spreadsheet2.  I know how to mirror cells in both sheets but need help with the b...