I have a master spreadsheeet that has formulas in it to analyze data that is in different workbooks.

The workbooks with the data on them are in the same folder. The spreadsheets are named Book2 - Book174. xlsx.

I wanted to either select a range, or identify a range in a code then have it copied and pasted into the same exact location in all the other spreadsheet files. Is there a code that can do this?

For example, I have a column full of formulas, say J:J that I would like to copy to every one of the workbooks, Book2.xslx through Book174.xslx. I would like to paste all the formulas to the same column in every spreadsheet.

Is this difficult? Can the code be made flexible so that if I copy a range then I could paste it a different range I determine, given they are the same size? Thanks!