Find Jobs
Hire Freelancers

Writing a VBA code -- 2

$30-250 USD

クローズ
投稿日: 5年近く前

$30-250 USD

完了時にお支払い
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!
プロジェクト ID: 19732347

プロジェクトについて

25個の提案
リモートプロジェクト
アクティブ 5年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に25人のフリーランサーが、平均$119 USDで入札しています
ユーザーアバター
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 3日以内
5.0 (222 レビュー)
7.4
7.4
ユーザーアバター
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 2日以内
5.0 (194 レビュー)
6.9
6.9
ユーザーアバター
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 3日以内
5.0 (42 レビュー)
5.3
5.3
ユーザーアバター
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 3日以内
4.8 (86 レビュー)
5.7
5.7
ユーザーアバター
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 5日以内
4.8 (18 レビュー)
4.5
4.5
ユーザーアバター
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 3日以内
5.0 (2 レビュー)
2.2
2.2
ユーザーアバター
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 2日以内
5.0 (1 レビュー)
1.4
1.4
ユーザーアバター
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 3日以内
5.0 (1 レビュー)
1.1
1.1
ユーザーアバター
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 7日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I m done your work very fast
$155 USD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 7日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 7日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
New York, United States
0.0
0
メンバー登録日:5月 22, 2019

クライアント確認

このクライアントからの他の仕事

Write an employee memo
$10-30 USD
ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。