Thread: copy data of different range to other sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sutha sutha is offline
external usenet poster
  
Posts: 9
Default copy data of different range to other sheets
I HAVE A SHEET WITH P&L FOR 100 COMPANIES ONE BELOW ANOTHER. EACH P&L IS SAME
IN SIZE( 20 RAWS)

Can someone please help with a sub that will copy each p&l in different
sheet and name each sheet with the 1st word found in the begining of the
range (Eg; raw 1
company name "xxx")
Reply With QuoteReply With Quote