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.


Beceriler: Veri İşleme, Excel, VB.NET, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) New York, United States

Proje NO: #19732347

Bu iş için 29 freelancer ortalamada $120 teklif veriyor


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 ( Daha Fazla

$200 USD in 2 gün içinde
(704 Değerlendirme)

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 gün içinde
(222 Değerlendirme)

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 Daha Fazla

$40 USD in 2 gün içinde
(186 Değerlendirme)

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... Daha Fazla

$140 USD in 3 gün içinde
(82 Değerlendirme)

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] Daha Fazla

$100 USD in 2 gün içinde
(98 Değerlendirme)

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 Daha Fazla

$45 USD in 3 gün içinde
(75 Değerlendirme)

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. Daha Fazla

$155 USD in 3 gün içinde
(42 Değerlendirme)

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

$155 USD in 3 gün içinde
(23 Değerlendirme)

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 Daha Fazla

$200 USD in 2 gün içinde
(9 Değerlendirme)
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)

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 Daha Fazla

$150 USD in 3 gün içinde
(1 Yorum)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)

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 gün içinde
(2 Değerlendirme)

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 gün içinde
(1 Yorum)

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 Daha Fazla

$100 USD in 2 gün içinde
(1 Yorum)

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 gün içinde
(1 Yorum)

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 Daha Fazla

$40 USD in 7 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$277 USD in 3 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
$111 USD in 2 gün içinde
(0 Değerlendirme)