Create some Excel Macros to automate spreadsheet functions

The project involves building excel macros which will automate certain functions in a few excel worksheets that are receiving data, manipulating it and exporting it to others. The functionality isn't very complicated but we don't internally have the expertise to automate the desired functions and have an immediate need for the worksheets to have this functionality. Among the functions macros we would want written would perform include the ability for the macro to clear the template document of prior data, export worksheet data which is composed of formulas to other worksheets as values, take columnar data and load it into fields in another worksheet tab, etc.

We currently perform the following functions which we would want macros to automate:

We initially cut and paste tab-delimited columnar data from a txt file into a tab of a worksheet, cut and paste 5 columns of that data into another worksheet tab which contains an existing macro which performs certain functions...(the macro for that is already done) and thereafter we cut and paste the results of the data generated to another separate excel worksheet file. We paste as special that output to a tab of this other worksheet and then have another tab of that worksheet which has data fields, link those fields to specific columns of the input tab worksheet. If we have 25 rows of data which contain 40 columns of data, we would need 25 tabs created that provide calculated output for each row of data. There is an existing macro that exports the value results of the calculated output page(s) to a new worksheet so that macro is also already done.

If this makes sense to you and you think you can help us with this project, please bid.


Habilidades: PHP, Arquitetura de software

Veja mais: excel spreadsheet expertise, excel special, excel automate, create excel worksheet, create an excel, create a excel, automate], file cut paste, excel create input output, load excel, excel macro txt, excel macro row, export page excel, etc excel template, spreadsheet template, excel export txt, excel export template, excel 2013 macro, create load, project export excel, php excel macro, excel export txt file, excel macro php, data input output software, tabs create

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #5126086

13 freelancers estão ofertando em média $256 para esse trabalho


Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. Mais

$721 USD in 3 dias
(887 Comentários)

Hey, That sounds like a lot of manual work and just by reading through the brief description, I could say that most of the stuff like getting the data from text file, pasting columns and running other macros can be Mais

$277 USD in 5 dias
(214 Comentários)

Hi, I'm ready to help you on this project starting right now and finish ASAP. just award me the project to start and Hope to have this steps as images. thanks.

$160 USD in 4 dias
(103 Comentários)

Hi, I'm a VBA/ VB6 expert, with over 12 year experience I'm ready to start ASAP... I iwll deliver high quality results on record time... Please check out my reviews and see what my past employers say about me.... Thank Mais

$95 USD in 5 dias
(72 Comentários)

Hello - First of all I have to say that in project, you forgot to tag the skill Excel, which is needed to attract the relevant freelancer. Next, about me, I am an Expert Techno-Functional Analyst having vast experience Mais

$100 USD in 7 dias
(40 Comentários)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive Mais

$166 USD in 10 dias
(71 Comentários)

hey kurzner, Very experienced team here... Can you please share your sheet and we can discuss more ? You can know our reputation here => https://www.freelancer.com/u/expertatwork.html ..Please reply. thanks Mais

$55 USD in 3 dias
(56 Comentários)

Hi, This is Amit from Illuminatus Softwares,India. We have been working on Excel automation macros & and we are comfortable with row-by-row excel operation macros along with functionalities like creating documents Mais

$250 USD in 5 dias
(4 Comentários)

Hi kurzner, i have read your requirement and i ensure i can help you. With my experience about excel macros, i ensure i can help you to do this within 1 or 2 day (You can refer my profile to see somes excel macros proj Mais

$80 USD in 2 dias
(1 Comentário)

Hello, I have extensive experience in VBA, and I'd love to flex my Excel VBA muscles; I haven't made macro in a while and I'd love to write another one. Do you have the source code for the macro and maybe some examp Mais

$222 USD in 3 dias
(2 Comentários)

I have automated several Excel Worksheets to import and analyse data. Using VBA, I have successfully completed the functions described in this project post. I have confidence I can turn this around very quickly. Mais

$300 USD in 3 dias
(0 Comentários)

I have extensive Excel and VBA programming experience. I currently to a tremendous amount of work with parsing data and placing it in the correct worksheet tabs, then performing on the data. My approach would invol Mais

$722 USD in 3 dias
(0 Comentários)

I am an excel expert and a computer engineer who can combine both skills in projects. Being a computer engineer I can develop software and use this skill to develop macros. Please contact me

$180 USD in 3 dias
(0 Comentários)