Create Command Button macro to consolidate 3 sheets
I'm new with VBA and still in the learning process. I'm making a scoresheet w/ 3 different forms and want all entries from the different forms be saved on another sheet that consolidate all common entries using a command button. I also want to create another command button to clear all entries after saving. I already made several attempts to create the command buttons but still fail. Hope someone can help me in doing this.
Hello Russell C,
Welcome to the Forum!
To help you solve these issues, you should post a copy of your workbook.
To Post Your Workbook
- At the bottom right of the Reply window, Click the button Go Advanced
- At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
- Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
- Click the Select Files button at the bottom middle of the dialog.
- In the new window Find the file you want to upload, select it, and Click Open.
- You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
- Wait until the file has completely uploaded before you exit the File Manager dialog.
File Manger Picture
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Here is the scoresheet I'm attempting to finish. Hope you can help me on how to go about the codes.
Hello Russell,
It looks to me most of the information is under the masthead. Can you tell me more specifically which cells the data comes from?
The data sheet is where all entries are saved. The 3 other sheets have different functions and is used for a specific transaction. I'm trying to consolidate the entries on the audit date, transaction, Customer support officer (processor), service manager, process, & the AOP, result, & score fields. What I wanted to do is whenever I enter anything on each sheet will be saved on the DATA sheet by putting a save and clear command buttons on the 3 sheets.
Hello Russell,
I have created a macro that can be called from "Save" button on each of the sheets and wrote a macro to clear all data on the summary sheet, except for the headers. The attached workbook has the "Save" button on "ISR.NB" calling the macro. You can use this macro for the other 2 sheets "Save" buttons.
Module2 Macro Code
Please Login or Register to view this content.
this is super awesome!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks