Need help with filtering & inserting information :(

  • Thread starter Thread starter Desper84AnAnswer
  • Start date Start date
D

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: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.
 
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
 
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).
 
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
 
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.
 
Back
Top