LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Don't Replace existing Cell Pete Excel Programming 2 July 23rd 07 11:16 PM
Replace Existing File Lynn Excel Programming 5 August 26th 06 06:30 PM
Replace an Existing File Jim Skrydlak Excel Programming 2 August 8th 06 09:52 PM
How do I paste to append instead of replace existing data? Joel Thomas Excel Discussion (Misc queries) 1 October 3rd 05 01:32 PM
Do you want to replace existing file? Tony Excel Programming 3 July 15th 04 11:21 PM


All times are GMT +1. The time now is 08:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"