I've been working with a project that I've asked a few questions about here already. This is part of the same project.

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 with the data 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 exact same 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 in 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? Overwriting any existent data should not be a problem, because the ranges I would copy to should be blank. Thanks!