View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
 
Posts: 184
Default give cells the same name

Hi Christian,

On every sheet I want to name the cells "A1" with "customer".


include the sheet name when creating the name, eg. type sheet1!customer
and sheet2!customer. However, I would recommend, that you create one
template sheet with all the names etc. then you can simply copy that
sheet for each new customer and you'll get the same with less work.

arno