Hi all,

I have a masterworkbook and I would like to copy a range of data/formulas and then paste it into another workbook.
Why I would like a macro/;

I have 180 workbooks and each 53 worksheets.
The data I copy from my master workbook needs to be pasted into all workbooks 53 worksheets.
All the workbooks sheets are identical in name i.e. w01,w02,w03 etc. and is the same as my master workbook except for the part I need to copy and replicate across the other workbooks.

Copy and paste may work but I am 100% sure VBA will assist me not to sit and paste 180 x 53 times the same formulas

appreciate your assistance.

Thank you kindly.