Encerrado

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.

Thanks.

Habilidades: PHP, Arquitetura de software

Ver mais: excel spreadsheet expertise, excel special, excel automate, create excel worksheet, create excel, 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, input spreadsheet template, excel macros spreadsheet macro

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

ID do Projeto: #5126086

14 freelancers estão ofertando em média $255 para este trabalho

rajeshsonisl

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
(446 Comentários)
7.2
shikhamehta

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
(182 Comentários)
6.8
unbre4kab1esl

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
(57 Comentários)
5.2
dpune

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
(31 Comentários)
4.5
CARLOSHUGGINS

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
(15 Comentários)
4.3
wsh2

Greetings from Easton PA.. {gentle smile} Highly experienced [20+ years] MsExcel Business programming and database professional with GURU / Mentor technical credentials at www.experts-exchange.com and www.vbcity.com Mais

$236 USD in 8 dias
(5 Comentários)
3.6
amitchaps

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
(1 Comentário)
3.2
NhatAnhIT

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)
2.7
jaylancer43

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
(3 Comentários)
2.7
TIWORLD

Hi, We are very clear with the specification mentioned and ready to start your project immediately. We are pleased about having the opportunity to work together. Sir , TI World is Indian base company. You can see o Mais

$206 USD in 7 dias
(3 Comentários)
2.2
expertatwork

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
(2 Comentários)
2.0
DanielWeiner

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
(0 Comentários)
0.0
brentmccaw

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)
0.0
BZWelch0995

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)
0.0
saktulga

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)
0.0