View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chungacs chungacs is offline
external usenet poster
 
Posts: 1
Default Copy and paste a name list across worksheets

I have an excel worksheet which is a name list of some 50 names. I also have
a workbook which is a collection of some 50 worksheets. Now I want to insert
these names, one by one, into cell A1 of each of the 50 worksheets. Is there
a way to do so in one go, instead of having to copy and paste each name, one
at a time, into cell A1 of each worksheet. Thanks