View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default create sheet based on value in string

Column A on active sheet has contains a list of one or two values.
"abc"
"def"

For each value of abc, create a sheet entitled "product of abc" and
opy the entire row (or at least a:g) to that sheet.

For each value of def, create a sheet entitled "product of def" and
opy the entire row (or at least a:g) to that sheet.