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.

"Desper84AnAnswer" wrote in
message ...
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).

"Per Jessen" wrote:

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

--
Per

On 12 Jan., 01:03, Desper84AnAnswer
wrote:
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: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:D" to be inserted
on
sheet2 with all the other information in the same row.