I have over 100 files that follow the same format of the one Company Directory that I have. I can manually parse the data, but this is very tedious and would take a long time. So I need a way to automate the process using a script or formula. But the point is, I would like this process to take a few seconds or minutes per file, not several hours per file as it does now.
I would like someone to develop a script or a formula that I can use to the attached file. it is the script or formula that I need so that I can use it on future files that have exactly the same format as the attached document.
If you capability so bid & automate process script or formula sample
badge 20$ within 1 day
19 freelancers are bidding on average $31 for this job
Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)
I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. This is very easy task. I explain my idea in PM.
Dear eftiBD, I have already finished your project. I have sent you ready file to check. I have based on information and data, that you were prepared. Please, test it yourself.
Hi, I can write macro for this. Macro will split the raw data to unit number, street name, Tenant name , phone number. And then place them as per your format.