I am looking to find a way to on one worksheet to get data from another worksheet based on criteria.
IE.
On worksheet 1
I have columns A thru D and multiple rows varying each time used.
On worksheet 2 I want to be able to pull and display the contents from Worksheet 1 Column A when the data in column D matches a criteria...
So if WS 1 has
A B C D
abc 1 2 3
cde 1 2 1
efg 1 2 4
ghi 1 2 2
I would like WS2 to display the contents of Column A when the value in Column D is greater than one. Which would then be
WS2
abc
efg
ghi
Any assistance would be greatly appreciated.