View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Morin[_2_] Jason Morin[_2_] is offline
external usenet poster
 
Posts: 24
Default Copy formulas to certain sheets

My problem: I need to copy certain formulas from a
worksheet sheet called "SERDC Cover" to the same cells in
several other worksheets. However, I only want to:

1) Copy only those cells whose formulas start
with "=Input!"
2) Only copy to those worksheets whose name
contains "Cover".

For example, A1 on "SERDC Cover" has "=Input!B22". I would
like to put "=Input!B22" in cell A1 for all other
worksheets in the wb that contains the "Cover" in the name.

Thanks!
Jason