Find Jobs
Hire Freelancers

Writing a VBA code -- 2

$30-250 USD

Avslutat
Publicerad nästan fem år sedan

$30-250 USD

Betalning vid leverans
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!
Project ID: 19732347

Om projektet

25 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
25 frilansar lägger i genomsnitt anbud på $119 USD för detta uppdrag
Använd avatar
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 Om 3 dagar
5,0 (222 omdömen)
7,4
7,4
Använd avatar
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 Om 2 dagar
5,0 (194 omdömen)
6,9
6,9
Använd avatar
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 Om 3 dagar
5,0 (42 omdömen)
5,3
5,3
Använd avatar
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 Om 3 dagar
4,8 (86 omdömen)
5,7
5,7
Använd avatar
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 Om 5 dagar
4,8 (18 omdömen)
4,5
4,5
Använd avatar
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 Om 3 dagar
5,0 (2 omdömen)
2,2
2,2
Använd avatar
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 Om 2 dagar
5,0 (1 omdöme)
1,4
1,4
Använd avatar
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 Om 3 dagar
5,0 (1 omdöme)
1,1
1,1
Använd avatar
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 Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I m done your work very fast
$155 USD Om 2 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 10 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 2 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 7 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för UNITED STATES
New York, United States
0,0
0
Medlem sedan maj 22, 2019

Kundverifikation

Andra uppdrag från denna kund

Write an employee memo
$10-30 USD
Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.