Need help with filtering & inserting information :(

[Desper84AnAnswer]

I've tried V-Lookup but dont think its the function I should be using.
I need to Filter a column for specific information & then I need the results
to be entered on a different worksheet.
E.G: (SHEET1)
A1 - "Billy", B1 - "Tolin", C1 - "AEA750", D1 - "Grey"

Sheet1 D1 - "Grey" (Word to be searched)
Sheet1 D (Column that needs to be filtered)
Sheet2 - I need all the information inserted from: A1 to C1

So, I need anyone with the word "Grey" in Column "D" to be inserted on
sheet2 with all the other information in the same row.

 

[Per Jessen]

Hi

One way:

Insert headings in row 1 of sheet1, then apply an autofilter, filter
by column D="Gray". Copy the result to other sheet. Remove autofilter.

Hopes it helps

 

[Desper84AnAnswer]

Thank you for the feedback.....
Im already aware of Autofiltering etc... I deal with thousands of customers
each month & was hoping there was a way of possibly automating it so I didnt
have to manually do anything. (Speed up the process).

 

[Debra Dalgleish]

You can use an Advanced Filter to extract specific data to a different
sheet. There are instructions here:

http://www.contextures.com/xladvfilter01.html

You could record a macro while you apply an Advanced Filter, then add a
button to run that macro when required.
There are sample files here:

http://www.contextures.com/excelfiles.html

Under Filter, look for FL0001 - Product List by Category

 

[Per Jessen]

Then we are looking at a macro.

More information are needed:

Layout of Target Sheet, Destination Sheet(s). Shall we sort by all
unique entries in column B or ?, etc...

Regards,
Per

 

[Fred Smith]

Then you want a macro.

Start by turning on macro recording, manually do all the steps you want,
then stop recording and save the macro. Typically you will have to tweak the
macro afterwards, but start by recording it, and go from there.

Regards,
Fred.