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.
Bu iş için 29 freelancer ortalamada $120 teklif veriyor
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
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
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
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