Need help with filtering & inserting information :(
 

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.

Need help with filtering & inserting information :(
 

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.

Need help with filtering & inserting information :(
 

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.

Need help with filtering & inserting information :(
 

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

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 he

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

Under Filter, look for FL0001 - Product List by Category


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.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Need help with filtering & inserting information :(
 

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

On 12 Jan., 02:13, Desper84AnAnswer
wrote:
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.- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -

Need help with filtering & inserting information :(
 

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.