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

    Macro to Save File and then create a copy [SOLVED]

    SOLVES
  2. C

    Custom Data validation [SOLVED]

    I have an invoice amount field to be entered. I don't want the user to be able to input a value unless they have made a selection in COL D (Type) and COL E (Date). If they have made the selections then the amount field needs to be data validate based on decimal Min in Setup!$A$21 and Max in...
  3. C

    Multiple Data validation types in same cell

    In column A I can have different entries in in a cell. If it's "B" I want the data validation in column E to be a data V list. If it's "I" I need the data validation to be decimal. Is this possible? Thanks
  4. C

    Hide Tabs in Workbook

    I want the tabs to be hidden in the workbook. I've turned off in advanced option and it works for a while but then they come back. I am using macro's to go to different sheets within the workbook. Any ideas.
  5. C

    Incrementing a cell value by 1 within a running macro [SOLVED]

    Thanks - Got working. SOLVED
  6. C

    Macro that will only run if certain criteria are met needs a password [SOLVED]

    Hi Dave / Luke Just got to try this and yes it works - I will try and understand the logic better. Many thanks all. SOLVED.
  7. C

    Macro to Save File and then create a copy [SOLVED]

    Hi Looked at link but can't see how to amend code for what I need. I want to once a month perform this function - save a copy of file to the project code name with the current mmm/yy then save the file withe the current Master name
  8. C

    Macro that will only run if certain criteria are met needs a password [SOLVED]

    Not able to try this yet but feels like order not quite right still: 1. Try to run macro - click button 2. If criteria not true - message Criteria not True - stop macro 3. If criteria true - ask for password 4. If password not correct - message Password not correct - stop macro 5. If...
  9. C

    Incrementing a cell value by 1 within a running macro [SOLVED]

    Hi, Thanks for advice - just super keen at moment and people been so helpful but will look at postings. What triggers the statement. The macro I am running is a one time end of month and at that time I need the value to increase. Where is this statement placed Cammandk
  10. C

    Incrementing a cell value by 1 within a running macro [SOLVED]

    I have a macro that runs and as part of it I need to increment a cell by 1. Thought going to the cell as part of the macro record and +1 in the cell would do it but no success yet.
  11. C

    Macro to Save File and then create a copy [SOLVED]

    I have a file called OTR2CMMaster.xls At the end of the month I want to save off where we are and create a seperate accounts file to use for month end. I want to run a macro that will save this master file and then create a copy and save as OTR2CMSageJun13 - the Jun 13 refering to the...
  12. C

    Macro that will only run if certain criteria are met needs a password [SOLVED]

    I have managed to get this working. What would be really useful is if the 1st Message was "Condition Not True" if all the criteria are not meet and then the 2nd Message was asking for the password.
  13. C

    Macro that will only run if certain criteria are met needs a password [SOLVED]

    Thanks. Where do I actually copy this into? Sorry newbie to this.
  14. C

    Macro that will only run if certain criteria are met needs a password [SOLVED]

    I have a MONTH END Button on a worksheet. I have recorded a macro MONTHEND to do what I want to happen when the button is clicked. I only want this to be able to run if a range T1:T3 all equal TRUE If the button is clicked I need a password CPL to be entered for it to run. What code is...
  15. C

    Cant Get Nested IF/AND statements to work - have I reached limit [SOLVED]

    Tried but couldn't get "B" to work properly - figured out missing ) on end of 2nd Day(E7 - so all good too go. Thanks Solved.
  16. C

    Cant Get Nested IF/AND statements to work - have I reached limit [SOLVED]

    Thanks - tried this and getting parenthesis error - I've added my active cells =IF(OR(D7="O",AND(OR(D7="I",D7="P",D7="S"),E7>TODAY()),AND(D7="B",DAY(E7)>20)),"A", IF(OR(D7="E",AND(OR(D7="I",D7="P",D7="S"),E7<=TODAY()),AND(D7="B",DAY(E7<=20)),"U","")
  17. C

    Cant Get Nested IF/AND statements to work - have I reached limit [SOLVED]

    I have a list box in A3 which depending on the selection and the date in B3 needs to return a different result in D3. I've broken out the statements but have had no success trying to combine them all together. Is there a way. Type Date Status O 04-Jun-13 if A3 = "O" then Status = A...
  18. C

    Put value in correct Month Col based on date of invoice payment terms [SOLVED]

    I think I've found a fix which works for me - I've made the last "" "0". so that there is a 0 in ther terms field.
  19. C

    Put value in correct Month Col based on date of invoice payment terms [SOLVED]

    Sorry one last thing. Copied rows down but because no values in yet - getting #value error in cells - can this be cleared
  20. C

    Put value in correct Month Col based on date of invoice payment terms [SOLVED]

    Brillant. Thank you.
  21. C

    Put value in correct Month Col based on date of invoice payment terms [SOLVED]

    yes
  22. C

    Put value in correct Month Col based on date of invoice payment terms [SOLVED]

    Thank you for this it works very well and I can almost understand it. There is one thing that it is not quite doing as I need - may have been my explaination. If the Term is "P" then I need the value to be put in the current month - and not based upon the date of the invoice. The "P"...
  23. C

    Put value in correct Month Col based on date of invoice payment terms [SOLVED]

    Hi, I'm working on a cashflow sheet and I need to have the value of an invoice put into the correct month column based upon the date of the invoice and the payment terms. A B C D E F G 1 Date Value Terms Jan Feb Mar 2 01-Jan-13 100 0 100 3 10-Jan-13 200 30 200 4...
View older results
Back
Top