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

Recent content by Kel

  1. K

    Unprotect Worksheet without password

    Sorry, supposed to post this in the vault. Many apologies.
  2. K

    Unprotect Worksheet without password

    Hi all, If you have forgotten your password for your worksheet, the following may help: Sub PasswordBreaker() 'Breaks worksheet password protection. Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4...
  3. K

    Help Needed with VBA

    Hi Deb, Thank you for the reply. As requested, I've uploaded the file. Still not a complete workbook as I am doing this workbook from scratch. I am half guessing someone will be suggesting to me to use forms but my user has requested for the input page to be as such. http://db.tt/Cd6J3AIR...
  4. K

    vlookup vba

    Hi Das, It seems to me that you want to: 1. Cross reference the name in sheet 2 against sheet 1, to find out the amount; and 2. To prevent others from seeing your formula which is why you want to use a macro. You may want to use index match instead of vlookup. I certainly prefer that to...
  5. K

    Help Needed with VBA

    Hi all, I am a VBA noob trying to automate my Excel and I wonder if the following can be done through VBA and if doable, how it should be done. To shorten the post, this is only PART 1 of the outcomes that I desire. PART 1 Relevant Worksheets: "Invoice Date Entry Sheet", "Invoice Summary...
See more
Back
Top