Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 506
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find earliest record based on unique identifier from a list ofdata Lee Excel Discussion (Misc queries) 4 July 24th 09 09:08 PM
Return a list of cells based on data in a single cell. Tim G. Excel Worksheet Functions 4 May 15th 08 06:29 PM
Adding a unique identifier to a column of data Holly[_2_] Excel Worksheet Functions 2 December 9th 07 07:01 PM
Consolidating Macros Into Single Workbook [email protected] Excel Discussion (Misc queries) 2 May 4th 07 07:58 PM
Macro that will hidden columns, rows and worksheets based on an identifier [email protected] Excel Discussion (Misc queries) 2 November 27th 06 03:49 PM


All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"