Copying and Pasting formulas to a different spreadsheet

[Pauls123]

Hi, I have a master spreadsheet where there are columns say A to Z. On sheet 2 of that spreadsheet I have formulas where I only look at say columns A C P S Z for example. On a totally different spreadsheet I obtain new data creating a new master spreadsheet. How can I paste the formulas from Sheet 2 of that original spreadsheet onto Sheet 2 of the new one and the formulas stay the same to reflect new data for columns A C P S Z.

Thanks, Paul

 

[chef]

If I’m picking this up right then copy formula from sheet then paste special formula into new one