Macro help

[Dan Wilson]

Good day. I'm running Excel 2007 on Windows Vista Business 32 bit. I have a workbook that contains several worksheets, all built in the same format and containing the same Column Headers. Is it possible to merge all of the worksheets into one with a new Column added to identify the genre of the worksheet that the data came from and then to create Macros that will not only sort the merged data by this new column, but show only those items found by the search? The search results could either be in the same worksheet or a blank worksheet created for this purpose.

As always, your help is appreciated.
Dan...

 

[jbeaucaire]

Hi Dan. Sounds reasonable. All of this requires something to work with. You can record a macro of you doing what you're talking about manually, then post the code here and we can analyze it together.

Or post a sample file somewhere we can look at it together. Make sure the sample file, if smaller then the original, still fully demonstrates all the hurdles to overcome.

Interesting your signature says "Visit my web site" but there's no link. My signature links to my Excel site, too, but the link is there, maybe you need to add yours?