• 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.

Search results

  1. D

    Auto-Transporting Row To Another Sheet If Checkbox is Checked Difficulties

    I will admit I was a little confused initially upon reading that as I have not encountered that specific problem at all (Or any other). I have been testing the sheet relentlessly in every (albeit limited) way(s) I know how and have not encountered the problem you so kindly illustrated. The...
  2. D

    Auto-Transporting Row To Another Sheet If Checkbox is Checked Difficulties

    Upon frequent testing it works perfectly. Absolutely as intended! I am amazed to how it functions so well with so much less code. It's just sort of a quick visual reference for comparing dates for the user rather than having to glance down at the calendar, it's not really necessary. But thanks...
  3. D

    Auto-Transporting Row To Another Sheet If Checkbox is Checked Difficulties

    I have no idea how to do this and any assistance would be greatly appreciated. Ah, so the moving of the cells is what caused the REF! and the format errors, good to know! The idea is is that the date should freeze whenever information arrives onto the sheet. Almost like some sort of...
  4. D

    Auto-Transporting Row To Another Sheet If Checkbox is Checked Difficulties

    Hello again Hui! I've managed to fix the sheet by cheating a little (Recorded Macros) But now it is fully functional. Thanks a bunch for your help! Hope this helps someone who is in the same situation. Here's the adapted code and the modules that reset things: Edit: After an hour or so of bug...
  5. D

    Auto-Transporting Row To Another Sheet If Checkbox is Checked Difficulties

    Thanks! Works flawlessly, except that the freeze date formula (=IF(B20<>"",IF(H20="",NOW(),H20),"")) outputs as #REF! and I'm not entirely sure as to why. After checking https://support.office.com/en-gb/article/How-to-correct-a-REF-error-822c8e46-e610-4d02-bf29-ec4b8c5ff4be it appears to be due...
  6. D

    Auto-Transporting Row To Another Sheet If Checkbox is Checked Difficulties

    The following code seems to function perfectly, although results in an Error 13: Type mismatch. Could anyone advise on where the data types conflict? Sub delete_old() Dim rowDate Dim curDate Dim interval Dim curAdd Dim vCell As Range ' set interval to an appropriate...
  7. D

    Auto-Transporting Row To Another Sheet If Checkbox is Checked Difficulties

    Additionally, there is another formula on the worksheet that is not functioning (Possibly due to the same error with the initial formula) which can be found in Sheet3(FinishedJob). This formula is intended to regulate (Delete) information based on current date vs date inputted. I have managed to...
  8. D

    Auto-Transporting Row To Another Sheet If Checkbox is Checked Difficulties

    Here is my current worksheet. I have labelled everything as best as I can to try and allow a better understanding of what my worksheet does.
  9. D

    Auto-Transporting Row To Another Sheet If Checkbox is Checked Difficulties

    Hello there! Firstly, I am not Excel proficient nor entirely VBA literate and although I have progressed thus far, I am unable to complete the sheet. Any assistance would be appreciated. Apologies in advance for any misuse of terminology or coding language. I hope I can provide you with enough...
Back
Top