Moving Duplicate records to new sheets

Hi h2holbro22,
_ I cannot help you with Formulas or Pivot Tables.
_ Would you be interested in a VBA Solution?


_ If so please supply me with similar test data again but do it a bit differently:
_ I need to see what you have initially before anything is done ( again with reduced test data as you have done )
_ we call this typically the “Before” or “Befores”). But then importantly I want to see hand filled result, which is what everything should then look like after running of the macro. We would call this the “After or Afters.
_ I a clear picture (BUT NOT IMAGES ) of what you have before and what you want after with reduced test data.

. So simply provide a clear before and after ... ( For example a "Before" and "After" sheet in an Excel File )

To summarise.

. The Before or Befores, should look just as it / they does before running of any macro.
.
. The After or Afters, should be hand filled by you so that it they / looks exactly as you want it to After running of any macro, based on the actual sample data in the Before / or Befores
. Make sure there is just enough data to demonstrate your need. Remember to desensitize the data if necessary, but use the typical Format type and choose your data carefully so that it can be used to test all possible scenarios.
...

Alan

P.s. some ways to provide that info: ( Most people use . 2 )
. 1 ) use the Forum Tools in my signature to produce screen shots we can copy to a spreadsheet ( NO IMAGES ! )
. 2 ) Post Files
To Attach a sample workbook:
View Pic
http://www.excelforum.com/members/da...ch-a-file.html
http://tinyurl.com/oenwprw

. 3 ) - Up left in the Thread editor is a Table icon. Click that, create an appropriately sized table and fill it in. (To get the table icon up in the Reply window you may need to click on the “Go Advanced” Button next to the Reply Button)

. 4) Only as a very last resort, P.M. me and i will reply with my Email Addressee so you can send me a file
** To PM me, click on my name in the left hand margin when you are logged in, the rest should be obvious.
Alan