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