View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default consolidating data in a row based on a single identifier

I have a spreadsheet with the following headings:

Song # Song Title Artist Genre

I would like to be able to have all of the data in any row associated with
the Genre name post to a preset sheet within the workbook. Can anyone help
me with this? I assume a masro will work but I'm a novice at Macro writing.
--
John