Copy records automatically to another sheet based upon constantcriteria

  • Thread starter Thread starter skiing
  • Start date Start date
S

skiing

I have 1000+ address lines (name, address, phone) in a single sheet.
I would like to make a copy, which will update, based upon constant
criteria.
Ex: I would like to copy all records which have 561 area code and
place them on another sheet, all 856 on another and so on.
Changes made to the "master" sheet would automatically update on the
appropriate sheet - additions, changes, etc...
Can anyone assist? Thank you in advance.
 
I have 1000+ address lines (name, address, phone) in a single sheet.
I would like to make a copy, which will update, based upon constant
criteria.
Ex: I would like to copy all records which have 561 area code and
place them on another sheet, all 856 on another and so on.
Changes made to the "master" sheet would automatically update on the
appropriate sheet - additions, changes, etc...
Can anyone assist?  Thank you in advance.
Click to expand...

take a look at this. make sure you create it as an array formula (ctrl
+shift+enter), not just a formula (enter). then you can drag/fill it
down.
http://office.microsoft.com/en-us/excel/HA012260381033.aspx

a formula that i use that does essentially what you want ended up
looking like this. It pulls data from the QB sheet. Cell A1 is the
reference cell that i am searching for within the array A1:B200 of the
QB sheet,

=INDEX(QB!$A$1:$B$200,SMALL(IF(QB!$A$1:$A$200=$A$1,ROW(QB!$A$1:$A
$200)),ROW(3:3)),2)

hope that helps...
 
Back
Top