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

  1. C

    Loop through fixed number of rows

    Posted this by mistake in the excel formula forum. I do need a vba solution as in J9:J38 there is a data validation list that contains "Cash Withdrawal" as part of the list options I'm looking for code that will loop though O9:O38 and if on any of those rows the first 4 characters = "Cash"...
  2. C

    Loop through fixed number of rows

    I'm looking for code that will loop though O9:O38 and if on any of those rows the first 4 characters = "Cash" then "Cash Withdrawal" will be put in the adjacent J9:J38 cell. So if O15 = "Cash Deposit abcd " then "Cash Withdrawal" will be entered into J15 ▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as...
  3. C

    Formula gives circular error

    I have sales revenues which have a commission % deducted to leave an net amount that repays an investment. The total investment to be repaid is $5000. Until 50% of this is repaid ie $2500 the commission to be charged should be 5%. Once $2500 has been repaid any further sales amounts should have...
  4. C

    Code not saving to sharepoint

    Hi All I have the following code which creates a backup of the open workbook - this works when on a local machine. I now have the file on a sharepoint drive and it's not working. I've already changed the \ to / in the path's but still not registering. Is it do to with being a URL? Any help...
  5. C

    Filepath when Saving to Sharepoint folder

    I had code to correctly save to a local/network folder but its now not working when the file is on sharepoint. 'the following function will get the path only (i.e. the folder) from the file's full path: Function FilePath(strPath As String) As String FilePath = Left$(strPath...
  6. C

    Can this macro be speeded up

    Luke you are correct - I've amended to just work with the filter Hui - point noted. Thanks
  7. C

    Can this macro be speeded up

    I am using the code below to hide rows that are not relevant to print and/or copy just relevant data to another sheet. The code below looks at all the rows in Col A and if they =0 it hides the rows. This seems to be taking a lot longer than it initially did. It looks through approx. 2000 rows...
  8. C

    Select TimeValue from cell

    Hi Luke Once again thank you for solution - it's working nicely. I posted an earlier thread 25th May "Add new cell value to list in another sheet" Would you have any thoughts on this - if you can? DK
  9. C

    Select TimeValue from cell

    I have a cell that shows the minutes I require (although formatted hh:mm:ss - still seems to include date) Sheet6.Range("TimeInterval") How can I use this in the code below. dTime = Now + TimeValue("00:05:00") Thanks DK
  10. C

    Cell to show defined name not value.

    Hi Narayan Sorry for delay in responding but have been travelling. I've attached a file which shows example of what I am trying to achieve. Hope its clear. DK
  11. C

    Add new cell value to list in another sheet

    Hi Deepak Thanks for this but for what I need it won't work. The list of grades in SETUP could be given any SCH from 5 to 20 and not in order I need a macro that will look at the SCH No and copy the name to the right of it to the end of the list in each SCH in the List2. DK
  12. C

    Cell to show defined name not value.

    Hi Narayan I do already have a configuration sheet - "Globals" - so that the user can go to and easily amend - rather than the name manager where every name will appear. The challenge still is: I have a defined name called GLShootWeeks in the Globals sheet I have a defined name called...
  13. C

    Cell to show defined name not value.

    Hi Narayan The defined names are meant to be very simple for the user to operate. The name GLShoot refers to 10 weeks filming period. This name may be used in many 10's or 100's of fields as the user works on a budget. Usually the 10 weeks needs to become 9 in order to reduce the budget and...
  14. C

    Cell to show defined name not value.

    Hi Mike Thanks for this but it is not what I am after. You have supplied code which gives the defined name from E3 which is the cell that the name is defined in. I need to get the defined name out of J3 which is using the defined name. DK
  15. C

    Cell to show defined name not value.

    Hi Here's a worksheet showing the need. Hope it makes sense. Thanks DK
Back
Top