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

consolidating data in a row based on a single identifier
 

Provide some sample data and describe about your query in breif.

--------------------
(Ms-Exl-Learner)
--------------------


"John" wrote:

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