Create some Excel Macros to automate spreadsheet functions
$30-250 USD
货到付款
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.
项目ID: #5126086
关于项目
有13名威客正在参与此工作的竞标,均价$256/小时
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. 更多
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 更多
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.
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 更多
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 更多
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 更多
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 更多
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 更多
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