Excel filtering and sorting question?

Question

I have data with multiple colums. I was to filter all of the items in column 1 that have the value "A". There are multiple "A"'s in the list.

I know I can use the auto filter to get in on the page, but my problem is I want the data to appear on a separate worksheet.!

So when I enter a new row with "A" it appears on one worksheet and all the "B"'s appear on a separate workseet

Any help would be great!

Answer 1

Easiest way I can think of to do what you're attempting would be to write a macro that would clear a pre-existing worksheet, "A", then go back and autofilter the main data table showing only items maked "A", copy everything, switch back to worksheet "A", then paste. Repeat for "B's", "C's", and so on.

Answer 2

I don't know if you can filter it so it can go on a separate worksheet. I do know that if you go to Data, Auto Filter, right click on the column header and click Customer. You can then select "Equals" A and then it will only bring up the A's. You can then manually copy this information over into a separate worksheet.

Answer 3

i suggest that you look up videos on youtube for excel. i learnt most of my office softwares from there.

Answer 4

You could set up a PivotTable...