Search results

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi Mike I've just tried a couple of things and I realise that the issue my be with my understanding of what I actual need. Your code does return the name of the defined name cell from the cell that it is defined - however I now realise this is not what I need. My defined name is a single cell...

Hi Mike I get a #value error in the field.? DK

I have cell A1. This is a defined name "GLShoot" and returns a value on 10 in A1. In B1 I want to show the defined name - "GLShoot". Is this possible? Thanks DK

I have a list of Grades in Sheet"Setup". This list will be added to by user. They will select which SCH it belongs too. I need a macro that will take the new entry in Sheet"Setup") and add to the correct column in Sheet"List2". Ideally the lists should be sorted. Thanks DK

Hi Nara Hope this is clear David

I want to have a macro that will create defined names from a list As the list is added to it needs to run again and not create old names again or create an error message and just add the names that don't yet exist. COL A COL B Job1 defined name in Col B - name needs to be "GL" & Job1 &...

Hi Luke I may be doing this wrong but getting error message that "You may use reference operators or arrays for data validation criteria. I have selected cell T33 and gone to data validation and copied the code into the custom formula box. (changed B2 to T33). DK

Hi Luke Just about to start travelling for a while. Looking at the formula now where does the selection of "B" in A1 become part of the formula? DK

Hi Luke Thanks for this. The list for the last option would be something like "CCJan","CCFeb","CCMar","CCApr",CCMay" - through to "CCDec" DK

I want to set entry into a cell based on any of the following conditions: 1. If A1 = "F","O","E" then no entry allowed 2. If A1 = "I" or "S1" then entry allowed 3. If A1 = "B" then option Defined Name "List1" I am looking to enter this as a custom formula is DV setting in cell. Thanks DK