Template required in Excel that includes macros and VB to format spreadsheet. Please see the file attached, the first tab (data) contains the original data and the second tab (output) the desired results.
Template must contain the current headers on the first tab and a format button built in VB. Once the data is pasted in and the format button is clicked the desired results should appear on a new sheet (2nd tab)
First tab (data) formatting includes -
Street field - street number must be separted from street name.
Street field - If the cell contains a "-" in the street name it must be replaced by " ".
Street field - remove the world "Lot" please see tab 2 output for example.
Surname field and Initial field must be merged - =intial&" "&surname.
Address would need to be de-duplicated and the final address contains the phone numbers. Please see the highlighted cells in the second tab (output).
This template will be used on a ongoing basis.
26 freelancer đang chào giá trung bình $60 cho công việc này
Hi, can do this quickly, however need some additional clarification about some clearing rules (regarding Lot removal and de-duplicates criteria as there could be some risks of misleading)
Hello sellforce, I work as a project controller and have to do similar jobs very often. If you decide for me, you can be sure to get a very good tool. Best wishes, ITProgramming
I have done projects similar to this in the past. I'm new to Freelancer, and I'm looking to complete my first project. This should take no longer than a few hours, so $40 is a pair price.