I need to write macros to do two things...
1) I need to delete all records in a worksheet for which column F contains a comma OR a specific substring, "Dwl:" (which is part of a longer string..."Dwl:Hse,Tlr,Apt, Dup").
2) I have worksheets in which column A contains house address numbers. I need to append the road name to the address number for each record. All records in the worksheet need to be updated with the same road name. Essentially, I need the macro to prompt for the desired road name and then update the address field by adding the road name to the address number.
Any/all help is appreciated!
1) I need to delete all records in a worksheet for which column F contains a comma OR a specific substring, "Dwl:" (which is part of a longer string..."Dwl:Hse,Tlr,Apt, Dup").
2) I have worksheets in which column A contains house address numbers. I need to append the road name to the address number for each record. All records in the worksheet need to be updated with the same road name. Essentially, I need the macro to prompt for the desired road name and then update the address field by adding the road name to the address number.
Any/all help is appreciated!
