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.


Kemahiran: Pemprosesan Data, Excel, VB.NET, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) New York, United States

ID Projek: #19732347

29 pekerja bebas membida secara purata $120 untuk pekerjaan ini


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 ( Lagi

$200 USD dalam 2 hari
(704 Ulasan)

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 dalam 3 hari
(222 Ulasan)

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 Lagi

$40 USD dalam 2 hari
(186 Ulasan)

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

$140 USD dalam 3 hari
(82 Ulasan)

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] Lagi

$100 USD dalam 2 hari
(98 Ulasan)

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 Lagi

$45 USD dalam 3 hari
(75 Ulasan)

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

$155 USD dalam 3 hari
(42 Ulasan)

Hi, I am interested in your offer Let me know more details about this work. I will start working immediately Br;

$155 USD dalam 3 hari
(23 Ulasan)

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 Lagi

$200 USD dalam 2 hari
(9 Ulasan)
$30 USD dalam sehari
(8 Ulasan)

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 Lagi

$150 USD dalam 3 hari
(1 Ulasan)

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 Lagi

$30 USD dalam sehari
(1 Ulasan)

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 dalam 2 hari
(2 Ulasan)

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 dalam 5 hari
(1 Ulasan)

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 Lagi

$100 USD dalam 2 hari
(1 Ulasan)

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 dalam 3 hari
(1 Ulasan)

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 Lagi

$40 USD dalam 7 hari
(0 Ulasan)

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 Lagi

$277 USD dalam 3 hari
(0 Ulasan)

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 Lagi

$140 USD dalam 7 hari
(0 Ulasan)
$111 USD dalam 2 hari
(0 Ulasan)