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 freelance font une offre moyenne de $60 pour ce travail
I've seen your file and already got solution which can be implemented within an hour or two. Best regards.
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
Your project is ready for delivery. Please see PM. For the past decade my focus has been spreadsheet development within Excel utilizing VBA programming. During this time I have developed spreadsheet applications by Plus
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.
Dear/Madam,Sir I'm applying for this project, kindly give me if possible I'll do it withing three days. Thanks & Best Regard