Sort large list of data from a pulldown menu and reorganize it on another sheet.

walruseggman- this is what i am looking for..... if i might be able to burden you just a little more....... I have attached the new workbook that contains your macro.


Lets say that on Sheet1 J1 has a date in it. It will be the same date that will be used for all 4 colors on Sheet2. Lets say then J2 is $100.00, J3 is $500.00, J4 is $600, and J5 is $900.

What I would like to do it after the macro is run….
If looks at col J to see if there is anything in it. If so.. it puts the data from Sheet1 J1 and J2. Then it checks L on Sheet2 to see if there is anything there and so on. If there is not anything in the column then it does not put anything there.

Thank you so much!!!!!