Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find earliest record based on unique identifier from a list ofdata | Excel Discussion (Misc queries) | |||
Return a list of cells based on data in a single cell. | Excel Worksheet Functions | |||
Adding a unique identifier to a column of data | Excel Worksheet Functions | |||
Consolidating Macros Into Single Workbook | Excel Discussion (Misc queries) | |||
Macro that will hidden columns, rows and worksheets based on an identifier | Excel Discussion (Misc queries) |