View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stratis stratis is offline
external usenet poster
 
Posts: 32
Default Duplicate a Formula in 1000 Spreadsheets

I do have 1000 spreadsheets which keep the data in the same structure.
I do have a number of Cells lets say A1,B1,C1,D1, E1 that include some
functions by calculating the same numbers in each spreadhseet
like Average, Sum(A:A), SUmif etc. Is there a way that that I can insert
this formulas into every workbook in the folder without haveing to open it
copy, paste and svae it every time.