Replace existing rows or add to end

C

Chulius Caesar

Hi

I have an excel sheet which downloads data from the web on house price
etc based on the suburb input which then gets stored in a master table
The information gets stored with suburb, state and postcode in the firs
3 columns as identifiers with following house price data etc

1 ............. 2 ............ 3 ................ 4 ............
...........
Suburb ..... State ....... Postcode .......Various house dat

Basically, when I do a search on a suburb, I want it to check the maste
table to see if the combination Suburb and Postcode already exist (som
suburbs might be listed under the same postcode) and then overwrite th
data. If the combination [suburb, postcode] do not exist in the shee
anywhere, I want the data to be added to the bottom of the list
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to download house prices from web 0
Question for John Vinson 5
how do i use VLOOKUP to find text and return a number? 8
Postcodes 1
linking fields 1
How to Split the contents of cells across multiple cells 5
Add an Supplier to Table 1
creating relationships 5

Top