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
Thank you.
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.
I can create a simple formula that will parse your data into this format of output. It is capable of handling any amount of information, and is extremely easy to use (just copy and paste the formula once, then drag it out to fill out all of the rows you need).
If you could please PM me with a sample of your input data, I can create a test document to prove my claim.
I am a graduated Information Technology and because of this I had experiences in doing this project. I have many qualities and skills in handling this project mentally and physically such ad typing faster with a high degree of accuracy. I can easily cope and catch-up on the directions to be followed. I do not rush a project instead i have my time-scheduling in doing so that before passing it to the employer I know that it would look organized, accurate and beautiful.
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.