We need a code to put zillow "houses sold" data into an excel file that can be converted for use in stata or matlad. Copying and pasting of each observation is quite tedious so we are looking for something that can be applied to many different searches. We need the address, dollar amount the house sold for, number of bedrooms, bathrooms and square feet. We need to do this for 20 different cities, with each one having ~100,000 observations. I'm not sure if a code can be written for this, but hopefully!