Find Jobs
Hire Freelancers

Writing a VBA code -- 2

$30-250 USD

Imefungwa
Imechapishwa almost 5 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa
I am trying to automate a resource forecast file. I need to user inputs to be controlled so that the data is in good order for reporting through PowerBI. I wanted to add a button so that I additional rows are needed, the person hits that button to add a row... and their name populates in the proper column so that each of their data inputs are tied back to their name for reporting. I can’t figure out how to get the macro to add the column and take the formula from the cell above the added row... if I tie the formula to a specific cell, when someone else adds a row, and that cell reference changes, the macro will no longer work. I’d also like to shift the data input columns over one column each week. And have it automatically run every Monday at midnight. Thanks!
Kitambulisho cha mradi: 19732347

Kuhusu mradi

25 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
25 wafanyakazi huru wana zabuni kwa wastani $119 USD kwa kazi hii
Picha ya Mtumiaji
Hi, I have been working on Excel macro based projects for the past 15 years and would be happy to take on your project. Please share sample Excel file and we can discuss. Thanks, Arul
$150 USD ndani ya siku 3
5.0 (222 hakiki)
7.4
7.4
Picha ya Mtumiaji
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I understand the changes you need and can come up with an appropriate macro. I have 18 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 300 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$40 USD ndani ya siku 2
5.0 (194 hakiki)
6.9
6.9
Picha ya Mtumiaji
Hi there! I am sure if I can get a change to work in this project I can definitely give yo the solution you are looking for. I am working in VBA for last 7 years, hopefully my experience can resolve this issue. Payment only to be release when I give you complete solution. Regards, Mantu
$155 USD ndani ya siku 3
5.0 (42 hakiki)
5.3
5.3
Picha ya Mtumiaji
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can develop a macro with a button to add news rows and columns. I can access particular columns and rows through macro. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$45 USD ndani ya siku 3
4.8 (86 hakiki)
5.7
5.7
Picha ya Mtumiaji
Hi. Great app writer for your projects. I have writen vba, excel app, macro for many years. I am ready to write your project. Thank you for visiting my profile
$140 USD ndani ya siku 5
4.8 (18 hakiki)
4.5
4.5
Picha ya Mtumiaji
I'm an expert at automating all Microsoft office products with VBA or writing .net add-ins. I've written 100s of complex systems involving VBA since VBA was available to use, including all Microsoft office products and AutoCAD/Microstation products. I'm sure this is a very simple thing and I'd love to show you how to handle this situation. This would be my first time freelancing on this site, but I'd like to break the ice with this. I'm not hard up for work, busy in the long term, but I'd like to expand horizons a bit and freelance a little. I can give you time immediately and help you through this to completion quickly.
$110 USD ndani ya siku 3
5.0 (2 hakiki)
2.2
2.2
Picha ya Mtumiaji
Control user input adding rows the way you want to keep data in a good integrity for the report you create Shifting data range one column each week and run specific macro or function Appreciate if you include a sample from your sheet highlighting the range that users work in each row Share your excel sheet sample, and get it down Regards
$100 USD ndani ya siku 2
5.0 (1 hakiki)
1.4
1.4
Picha ya Mtumiaji
hello I have a lot of skills in processing data in Excel. You will get the correct and fast data. Your request is very simple with the use of VBA. I can make very quickly
$111 USD ndani ya siku 3
5.0 (1 hakiki)
1.1
1.1
Picha ya Mtumiaji
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"
$140 USD ndani ya siku 7
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I m done your work very fast
$155 USD ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Problem Statement: Need a User Input based processing to tie the data as per the needs for Reporting Solution: Macro/Excel Based Addin/ VB Based Solution to ensure the reporting needs are fulfilled
$90 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hello, I am excel vba developer and excel data model builder. I often build data model to make excel dashboard or power BI desktop dashboard. So I assume I know what you need. Please hire me Relevant Skills and Experience I am excel data model builder. I often build data model from excel to make it as power BI data source
$111 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I have the skills and experience that you’re looking for and I’m confident that I would provide great results. If I can be of assistance, please do not hesitate to contact me.
$155 USD ndani ya siku 10
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I think it will be simple for me to make your job. I need your file to better understand what you want. My bid is cheaper than the others because I am a new freelancer, but I've done jobs like that in the last 20 years. I want to try to became a professional freelancer, so send me a message in the chat and we'll discuss about your job.
$50 USD ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I have read the project description and i assure you that i can complete it with no issues. I am a highly experienced VBA coder. I have a total of 7 years of experience in VBA-related coding. In 4 of those 7 years, I was a full time VBA coder for a US government contractor that processes Medicare and Medicaid. I created many managerial dashboards and executive performance reports for my employer who required them to be dynamic in their presentation. My dynamic coding allowed for manipulation of various elements of the charts such as the column colors, text formatting, etc. My skills are diverse and well honed. There is almost nothing I haven’t done using Excel VBA. I always make sure I deliver a well-tested solution, so you can be assured that I offer professionalism and expertise.
$40 USD ndani ya siku 7
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Recently created a project in PowerBI. Database = SQL. Created VBS code to collect and manupilate data. The result: Call Center AHT forecaster, controlled by a variable Service Level (ETS Feature). Relevant Skills and Experience Data manipulation. SQL. Excel and Power BI. VBA. Excel/Power BI ETS for forecasts.
$277 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hello, I have about 15 years of macro writing experience. Are you using absolute or relative referencing? I would need to see the macro and understand better how it works and how you want the referencing to change but I can help you.
$140 USD ndani ya siku 7
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED STATES
New York, United States
0.0
0
Mwanachama tangu Mei 22, 2019

Uthibitishaji wa Mteja

Kazi nyingine kutoka kwa mteja huyu

Write an employee memo
$10-30 USD
Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.