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.
27 freelance font une offre moyenne de $119 pour ce travail
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 ( Plus
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
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 Plus
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... Plus
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] Plus
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. Plus
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 Plus
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 Plus
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 Plus
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 Plus
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
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.
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 Plus
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
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 Plus
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 Plus
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 Plus
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 Plus