View Single Post
  #1   Report Post  
Chulius Caesar Chulius Caesar is offline
Junior Member
 
Location: Melbourne
Posts: 5
Default Replace existing rows or add to end

Hi,

I have an excel sheet which downloads data from the web on house prices 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 first 3 columns as identifiers with following house price data etc.

1 ............. 2 ............ 3 ................ 4 ............ 5 ........... 6
Suburb ..... State ....... Postcode .......Various house date


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