automatically sorting from a master sheet to other sheets

[CMoore12]

Hi,

I am having problems with automatically sorting from a master sheet to other sheets. I need to figure out a code or a way to have the master sheet automatically sort things by date for one sheet, by code for another, etc. I can't just use the auto filter because this is a project I am working for my internship and it has to automatically sort, each time new data is entered into each sheet by a specific row (date, code, etc.) I was wondering how I could go about this. I am still new to excel so any step by step directions would be much appreciated thanks!!

[FDibbins]

have you played around with =large() or =small() to see if that will help?

[CMoore12]

Thanks for responding. know I have to make a macro and my friend came up with this code for me (listed below) so that after every time I put in some new information and click out, the info will be organized by date from column I. When I tried this code though, nothing happened. I am new to excel and only know the very basics but any help will be much appreciated! (particularly step by step directions or finite details) Thank you!

Please Login or Register  to view this content.