Closed

Writing a VBA code -- 2

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!

Skills: Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps

See more: excel vba for dummies, excel macro tutorial, excel vba guide, excel vba, excel automation, what is vba used for, how to create a macro in excel 2013, how to create a macro in excel 2016, vba code create xml, vba code string gzip, php code send email specific address, tsv msaccess vba code, excel vba code optmization, vba code generate report excel, vba code check html link valid, vba code create pdf file access 2007 report, resize jpg vba code, excel vba code optimis, processor access vba code, vba code extract email text field

About the Employer:
( 0 reviews ) New York, United States

Project ID: #19732347

27 freelancers are bidding on average $119 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$200 USD in 2 days
(708 Reviews)
8.4
deepbluetech

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 in 3 days
(222 Reviews)
7.4
ksriniravi

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 1 More

$40 USD in 2 days
(187 Reviews)
6.8
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... More

$140 USD in 3 days
(86 Reviews)
6.6
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$100 USD in 2 days
(103 Reviews)
5.8
mantumalakar10

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. More

$155 USD in 3 days
(42 Reviews)
5.3
vsprybhanu

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 More

$45 USD in 3 days
(77 Reviews)
5.5
xinglong717

Hi, How are you today? I have just read your job description carefully and I am very interesting in your job. I am a senior Excel,VBA,C,C++ ,C# developer with 10 years experiences and I have developed many program of u More

$200 USD in 2 days
(10 Reviews)
4.2
Victorier006

hello,how are you. i read your bid carefully. i am C#, .Net expert and have full experience for 7 years. C#, .Net is my top skill and my interested skill. I can provide most quality and high fast. if you want to su More

$150 USD in 3 days
(1 Review)
3.6
$30 USD in 1 day
(8 Reviews)
3.6
emilianoreyes70

Hi! Try this with the little adjustments it need, there are 2 examples, check both : if it isnt what you need, i need to see the file. Regards, Emiliano Im a excel expert vba macros dashboards. reports ..... (tipe More

$30 USD in 1 day
(1 Review)
2.4
writingapp

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 in 5 days
(5 Reviews)
2.3
KimHyokJun

Hi, sir. I read your description carefully and I can help you with VB. I've many xp, and it's very easy for me. Thanks and regards.

$99 USD in 2 days
(2 Reviews)
2.0
vw1514518vw

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 samp More

$100 USD in 2 days
(1 Review)
1.4
diepkha

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 in 3 days
(1 Review)
0.6
mmostafa1220

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 w More

$40 USD in 7 days
(0 Reviews)
0.0
GKEvans

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 More

$140 USD in 7 days
(0 Reviews)
0.0
ChasCarter2002

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 a More

$277 USD in 3 days
(0 Reviews)
0.0
$111 USD in 2 days
(0 Reviews)
0.0
techlinesols6

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 th More

$140 USD in 7 days
(0 Reviews)
0.0