• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help With Code

Fred Wayne

Member
Hello. Here I am again. I have made another small file to register wake up calls. The file works perfectly. It records all the information that you put in TextBoxes and ComboBox. What I have been trying to implement, it is a code to sort the information recorded from UserForm. The information is sent to a sheet called Database. I have created a button called "Sort Data" in order to sort the information placed in cells from B2:G33 in Database Sheet. For some reason I can not get how to create the code to allow me sort the data in Ascendant Order. Can it be done by code inserted in the Sort Data button or can the code be inserted directly when clicking in "Save" button? Also I created another button called "Clean Data Sheet". What I need this button to do, is just clean cells from B2:G33 from Database Sheet. I have uploaded the file I made and some screenshots in what I need to be help with. In advance, thank you so much for all your invaluable help.

Sincerely yours,

Fred.
 

Attachments

  • Sort By Time Lapse.JPG
    Sort By Time Lapse.JPG
    81.3 KB · Views: 5
  • Delete only the data registered.JPG
    Delete only the data registered.JPG
    54.2 KB · Views: 5
  • Wake Up Calls Automated Log.xlsm
    44.6 KB · Views: 5
Something like this?
Sorting happens when you save.
 

Attachments

  • Wake Up Calls Automated Log(belle).xlsm
    38.4 KB · Views: 5
YESSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS.... WOWWWWW THAT IS WHY I LOVE YOU ALL.. YOU ARE AMAZING. THANK YOU SO MUCH.
 
I know this is too much to ask...but is there a way to keep like a track per day of the wake ups done. I mean to save per day as a PDF file and then have the chance to display the file in PDF and then print it? Is this possible? Please accept my apologies if I am asking too much. Thank Belleke in advance....you are the best.

Sincerely yours,


Fred.
 
Something like this?
Zip file contains excelfile and a folder, keep them together.
 

Attachments

  • Wake up calls.zip
    106.5 KB · Views: 5
Yes Exactly...that is what I really needed it. Please accept my apologies my apologies on the response delay. Thank you very much. You are simply the best.
 
Back
Top