Populating a form by search criteria

[Terry Scull]

I have a weekly download of data in Excel. I want to
populate cells based off of search criteria. For
instance: I have a name column, date column and location
column. I want to populate all cells matching:

Name X and Date X by location.

Location 1
data

Location 2
data

Can this be done in Excel within reason?

 

[Bernie Deitrick]

Terry,

After you've downloaded your data, you can apply an Autofilter based on the location column - your example wasn't specific enough
for me to help on that account. If you need to keep only the cells of interest, then once you've applied the filter, use Edit | Go
To... Special | Visible Cells Only to select the filtered cells, copy them, and paste them to a new location.

HTH,
Bernie
Excel MVP