Hi all,
i'm trying to get a macro going that will consolidate a bunch of data for me.
my example:
i have information in sheet labelled "Jan"
now let's say there's around 5 columns and 5 rows
e.g.
A B C D E
A B C D X
A B C D E
A B C D Y
A B C D E
now what i want to do is grab values for column 1, 2, and 3 where the 5th column is not "E" and then load them into another sheet named "Summary"
so the output in "Summary" tab will look something like this:
A B C X
A B C Y
Hopefully that's clear enough. Appreciate any help i can get on this!
Bookmarks