View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JABAgdl JABAgdl is offline
external usenet poster
 
Posts: 4
Default Copy same formula to all worksheets in a workbook

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