If you highlight the labels at the top of each column, then click on the data tab, and the big filter button.. you’ll be able to sort out which ones are from New Jersey. (Assuming that this is a separate data column in your spreadsheet)

After applying the above “autofilter” you can then click on the arrows next to each column header and filter it out so you only see “New Jersey” records for example… Once you have those filtered you can simply highlight>copy>and paste those into a new spreadsheet.

Without actually seeing an example of your spreadsheet this is my best guess.

I agree with @digitalimpression I would use the filter function and just pull those from NJ.

If the worksheet isn’t protected (or if it is, but you know the password to unprotect it), then it’s very simple.

Make sure the sheet is unprotected.

Highlight the row containing the column headers / field names.

Click the menu choice (depending on your version of Excel, the menu choices are different) for Data / AutoFilter.

Select the column that contains “State” and hit the drop-down arrow on the right side of the field name.

Click on “New Jersey” (or “NJ”) OR (again, depending on your version of Excel) click “off” the “Select All” check box, and THEN click “NJ”.

Now (assuming you have a well laid-out flat file database where all of the information for the client list is laid out in single rows) you have a list of client names and addresses that all share the “New Jersey” address.

You can Select all of the visible rows and copy them to another file.

Easy as pie.

Thanks for everyone’s responses!

Yes, use filter. How is your data? Are states listed in a separate column? If yes, filtering is easy solution. If not, you may use text to columns to separate them depending on its position within the text; and then use filter.

Just to add a tip to make sure filter works the way you want, check if the filter is applied to all the data. Sometimes, when there are blank rows in your data, filter stops there; it doesn’t jump and go down. In that case, first turn off your filter. Select all the data (you may use ctrl + a shortcut or press ctrl + end and then ctrl + shift + home). Apply again the filter. Now, it will show blanks too.