sort data automatically

[verisme]

Here the deal, i have input some data in sheet1
INPUT.JPG
[img]61143[/img]
and in the sheet2 , i want the data that i've been input look like this, without using manual sort , sort based on column A and D
RESULT.JPG

and everytime i updated or inputed new the data in the sheet1, in sheet2 the data automatically updated, what function that i must used ?
thanks in advance

P.S : sorry for my bad english

[teylyn]

Hi verisme

welcome to the forum. However, I'm afraid ....

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

also: if you need help with pictures, post pictures. If you need help with Excel files .....
Nobody feels like re-typing your data to test a suggested solution.

[teylyn]

thanks for changing the thread title. I've made a few corrections.

With only screen shots at hand, it is hard to suggest a solution, because I don't feel like retyping your data. I think the easiest way to organise your data would be a pivot table.

Here is a link to give you some background:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

[verisme]

thank for the answer ! anyway, is there another way, that is not using pivot tabel , macro , or something that must be clicked before, i want to avoid that ?
so what i meant is, everytime i've input or updated some data in sheet1 the data transfer into sheet2 sort based on item and conditon , just like sumif function, but sumif its only sum number based on the criteria that we put, it doesnt transfer a single/multiple row into another sheet with the same group. i've been thinking of using if and loop and cell function (is there a loop/ do while function in excel but not using vba script ?)

[teylyn]

but sumif its only sum number based on the criteria that we put, it doesnt transfer a single/multiple row into another sheet with the same group.
Edit/Delete Message

That's why pivot tables will be your ticket!

Also, your expected result will need to have the separate sections shrink and grow depending on the amount of data for reach section. Again, something that is a no-brainer for a pivot table, if you would just spend a few minutes learning how they work

A solution with macros and convoluted formulae is possible, but most here won't feel like duplicating native Excel functionality.

[verisme]

okay, i try to read about it first, but if someone else have any idea how to do it another way do please give some point and clue, thanks.