Copy same formula to all worksheets in a workbook

[JABAgdl]

Hello guys!

I have a table with some formulas saved in workbook "A". Once a month, I
receive workbook "B" and it has several worksheets in it (sometimes almost a
thousand). I need to copy the table with formulas from workbook "A" and paste
it into every-single-worksheet in workbook "B". In the same cell address (C25
for example). As of today, I copy the table and then I go to each worksheet
to paste it but I am pretty sure there is a way to do it with a macro or a
instruction and save me all that pasting over and over and over again... :S
as always, any and all help will be highly appreciatted!

JB

 

[Gord Dibben]

Copy the formula. from workbook A

In workbook B right-click on first sheet tab and "Select all sheets"..
Paste the formula to C25 on active sheet and will be done to all sheets.

You can copy/paste the entire table range at one go if you want.

DO NOT FORGET to ungroup the sheets when done.

If you screw up, close the workbook without saving.

Better yet............practice on a copy of the workbook.


Gord Dibben MS Excel MVP