Forum Discussion
Excel Button to copy changes to specific cells on new sheet
Hello, I need help, I am trying to make a new excel file that will copy any changes that are made to a new excel sheet as part of that history and also so I can print the changes off. Not sure if you...
mathetes I guess I probably used bad examples, I'm not actually using cars or lots or colors. I'm using this as a System Access Authorization form that stores logs when changes are made to specific users access. The first sheet will have all of the current Users system data, the sheets after would be change logs made to the first sheet and would be dated. The change logs will be printed off and have places for signatures authorizing the changes being made.
I just need help creating the button that would copy changes made to specific areas on another sheet in the same workbook so that they can be printed off and "authorized". I just wanted to keep it simple and use any examples given to design it specifically for what I need.
I will maintain still that a single transaction history (which can be used to record changes) is a better approach. I base that on years of experience as the director of a major database design (for HR and Payroll for a major US corporation)......
Database Design is my purview; Excel buttons that do things are not.....so I'll leave that to others. But I do suggest you think about your design.
Database Design is my purview; Excel buttons that do things are not.....so I'll leave that to others. But I do suggest you think about your design.
- It may be a better approach but I'm not trying to achieve transaction history as my main goal. My main goal is to have something to print off after making changes to a user without having to design a database or go too indepth. It will not be used a lot overall, it's primary purpose will be to print changes made and get signatures on them. The log part is just a nice byproduct of that since with my design you'll have a new sheet, so I figured why not give it a date and you're good to go.