I have a fairly easy problem I guess and I know I tried to do this before. I am trying to write a macro that will allow me to copy the data created using the tool u can see in the attached picture.
Essentially, there should be a button that would allow recording different selection / scenarios into a separate sheet row by row. The database should include columns where the total cost, total reduction and the selected categories and their year of implementation should be recorded. This all should go in ONE row that would be populated after I hit the button "RECORD" to which the macro I am trying to figure out will be assigned.
Also, I would like to add a button that would allow me to delete the database with a little pop-up window asking if i wished to proceed with the deleting procedure.
Is this possible?
Any help will be highly appreciated!
Thank you in advance!