View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sam.fares@cmcsg.com is offline
external usenet poster
 
Posts: 20
Default perform the same calculation in several spreadsheets

Hello;



i have several sheets in a work book. the sheets names that i am
intersted in using are 20, 25,30,40,45, 55..... . there are other
sheets with names like 20S, 20R..... the ones that i want to apply
the calculations in are the ones that have numbers only. i would like
to be able to perform certain calculations in sheet 20, then perform
the same calculation in sheet 25 and so on. how could i write the code
for it? Thanks very much!