How to copy selective rows?

  • Thread starter Thread starter guy
  • Start date Start date
G

guy

In Sheet2, a cell value.is entered. After this, I need to search Sheet1 column A with the cell value
entered. For each match, Sheet1 row is copied to Sheet3. Effectively, Sheet3 is a filtered display
of Sheet1, based on ctiteria entered in Sheet2. How do I do this?
 
Hi,

This can easily be done using Advanced Filter or a formula approach.
Which one are you interested in?
 
After re-reading your post, it seems that Advanced Filter is the way to
go. Assuming that your data in Sheet 1 starts at A2, and assuming the
cell value enter on Sheet 2 is contained in A2, try the following:

1) on Sheet 1 where your table is located enter the following formula in
a cell, let's say A21,
=A2=Sheet2!A2

2) leave A20 blank

3) select A1 on Sheet 3

4) Data > Filter > Advanced Filter

5) select "Copy to another location"

6) enter your "List range" on Sheet 1

7) enter your "Criteria range" on Sheet 1, which would be
Sheet1!$A$20:$A$21

8) enter "Copy to", which would be Sheet3!$A$1

9) click ok

Hope this helps!
 
Back
Top