140790 Excel VB Macro creation

I have only one goal for this project: to completely automate the collection of foreclosure property data and post it on a web site. I currently have various pieces working but need to complete the project. I am highly skilled in Macro Express but know nothing about VB. DATA COLLECTION 1) i use macro express to automatically log into [login to view URL] and download a spreadsheet titled [login to view URL] which contains a list of properties which will be sold at a foreclosure auction. This sheet contains some property information, sale date & time, who is doing the selling etc. 2) this sheet is automatically saved to my desktop. 3) macro express now opens the file "foreclosure to [login to view URL]" 4) i need a vb macro to take the data from "[login to view URL]" and place it into "sheet1" tab of "foreclosure to [login to view URL]". currently i place the data by hand and the sheet is set up to use a different source of data which was ver dirty data so we had to run a macro to delete much extraneous data. this macro will also delete all records which do not meet the criteria set forth on the "settings" tab. basically the settings should be used to delete any records which have a sale date of today + 4 days or more. therefore i need to remove the zestimate criteria from the settings tab and only use the auction date. 6) i would then like to use the three estimates of home value ([login to view URL], [login to view URL] and [login to view URL]) and create an average estimate and then delete records from the spreadsheet which are under $600,000 DATA MANIPULATION 1) the data from sheet1 then gets placed into sheet2 2) once the records are placed into sheet2 the vb macro should detect the city of each property and fill in sheet2 columns "email" "homepage" and "posting url" 3) once this is complete, the vb macro should place all this data onto the "adbomber" tab 4) most of the properties will be located in san jose and therefore san jose is split up into 5 areas. east, west, north, south & downtown. the "sanjose" tab has a list of zip codes for san jose and the area each zip is located. depending on the area, different domain names and email address shall be used. DATA OUTPUT 1) now the vb macro should use the html template located on the "html" tab and output text files like "sample html [login to view URL]" based on the data located on sheet2 AD POSTINGS 1) once the text files are complete, macro express will utilize the data located on the adbomber tab as well as the .txt files to post foreclosure advertising on the website. in the end i hope to run macro express to oversee the whole process and eliminate the need for human participation in the process. any and all suggestions you may have are greatly appreciated. if you are also handy with macro express, i would love to have you do work on those macros as well. regards todd