Copying & Pasting formulas

[lukerees83]

On sheet 1 of my spreadsheet I have lots of data and formulas entered, representing the month of January. On sheet 2 I wish to do exactly the same calculations with the formulas in the same cells, except of course I need to paste in different data for February.

If I copy all of sheet 1 then click paste special on sheet 2 and select 'formats', the cells all appear at the same size with same borders and colouring etc. That is fine, however I also want to paste the formulas into sheet 2 in the same places they were on sheet 1, but if I click paste special and select formulas it pastes both the data and the formulas from sheet 1. Of course I then have to delete all the data bit by bit, leaving only the formulas behind, before I can then paste Februrary's data in to get the right results.

Is there a way to tell excel to paste the formulas only from sheet 1, put them in the same place on sheet 2 & await new data before doing the calculations?

 

[Mike Blackman]

Hi Luke,

Only with VBA, will you data/formula always be in the same columns? If so let me know where the formula will be and I can write some code to do this.

 

[lukerees83]

The first formulas start in cells K4, L4, M4 & N4 and I have dragged them down to row 1000. They will always be in these columns.

The other formulas are in cells S3&4, T3&4, U3&4, V3&4 and finally V7 but these don't need to be dragged down any columns, they will be in these cells only and won't move.

Is this enough info for you? I have no idea how VBA works so if you need more info let me know.