Search results

Hi Narayan Sorry for the delay in replying to this but the system would not let me post. Anyway. G18 = a Text field. If it has "R" the formulas basically ignores it. H18 = date field of the invoice AO18 = payment terms of invoice - 0,30,60 days etc S18 = amount of invoice AS5 = Month/year...

Hi Narayan Can you assist me with this. I'm using the formula below and I need to update it. Tried but to no avail. I have a field X18 that may have a date in. If it does this is the date that should be used not that H18 and the amount in S18 should be put same period at the date in X18...

Hi Narayan Thanks for reply. I mean =5000-sum(c5:c10) I only want to flag/format "sum" cells so not a cell with =200*4 David

I want to format specific cells in a worksheet that have the "sum" equation in. I could propable do this using conditional formatting but don't want to have CF on a large no of cells so I think running a macro would be a better use of resources. Conditions: Specific Sheet - Sheet1 Column C...

Hi SirJB When I copy this across into either field or DV input box it comes up with formla error? Thanks.

I am using this formula successfully in a cell that the user enters a £ value. They can't enter a value in Q16 without selecting from a dropdown in F16 (F,O,I,E,B,P,S,R) and then a date in G16. =AND(NOT(ISBLANK($F16)),NOT(ISBLANK($G16))) I need to enhance this. I need the value entry in Q16...

Hi I have 2 worksheet events that I need to operate on a worksheet. I soon realised I can't have more than 1 - but I don't know how to combine them. I've shown the 2 codes below and hopefully included an adequate description of what they do. Is it possible to combine them. The first was...

Is it possible to write some VBA code that before I save my workbook it takes a copy of all the autorecovery files that may have been created in Path A: and copies them to Path B:

Thanks for advice - better rethink the merged cells. What was driving this was using a worksheet as a form and trying to have entry cells that could be laid out well.

Hi Bobhc Yes have done a repair - and thought everything was ok - but what it's done is unmerge many cells and removed all data validation. Cammandk

I have a workbook that frequently (not all the time) keeps coming up with this error message. I'm not aware of having anything to do with XML in the workbook. Repaired part:/xlworksheet/sheet3.xml part with XML error. Load error. Line 2,column 0, I've looked at the sheet and assume Line...

I have a custom cost manager workbook with hidden sheets and vba code. On my main entry sheet "CostManager" I want to be able to call up (probably via keystroke) a mini sheet to float that the user can use as a scrap working area - only needs to be say 10 x 10. It should save when closed The...

Works great thanks SOLVED

I want to hide the ribbon / formula bar just in one excel workbook. I have used the following code in THISWORKBOOK in VBA. It does hide them but if I open up another workbook it does the same to that workbook and excel itself seems to default to this. Any help would be appreciated. David...

Hi Narayan All in a tick - thanks working now. David

Sorry this is still not working - its letting me input the value even though only on field filled. can you up load the working sheet. the code that you have above is what i had in the worksheet and it didn't work? do you have an email address I can then allow you to upload to my box folder...

Hi Narayan back on this issue - i've upload a sample wb with the fields in. when i try to enter value in the amount field it won't let me even though the other fields are completed Thanks david https://www.box.com/s/vbahzxygerk8lnipojca

Hi Bob, Link is interesting. I think I just need a UserInterFaceOnly argument in the one worksheet. Can you advise if this is correct. The sheet that has the custom views is Sheet4 -(Cost Man). The Macro below takes me to the Custom View - CostManager1. What and where would the code go...

Just for some context the F001 is an Petty Cash No. When it's entered by user in COL L - Col O becomes "U" via formula to reflect its entered but unpaid. There could be multiple rows using this F001 for different cost centres. Once Petty Cash F001 has been processed by the accts dept I need to...

Hi Narayan Can I just confirm that I copy the formula into the custom forumula field on data validation. I have done this on a new worksheet and although the results true/false all appear correct when just a formula in a cell as soon as I add into data validation box it doesn't work. Not...

I have a Sheet "Cost Man". It has 3 custom views - CostManager1 / Payments1 / Handover1. I go to the views via macros When I protect the Sheet "Cost Man" - the macros don't go to the custom view - they go to the basic Sheet "Cost Man". Is there coding that will allow me to use these other...

I have tried in a seperate cell and it is giving the correct True/false response. I then put it into custom data validation option for N7 and it doesn't allow. David

In Column L of worksheet "CostManager" if I have the Value "F001" (from Floats!$A3) I want the value on Column O to be changed to "P"

I will have a good look at to see if I can understand it. I do have many hundreds of rows that this would need to apply to - would the VBA work? Thanks Cammandk

Yes your assumptions are correct. - COL D is a dropdown. However COL E is a date field Have named my DV as you have. =AND(NOT(ISBLANK($D7)),NOT(ISBLANK($E7)),$N7>=MinVal,$N7<=MaxVal) Not allowing me to enter anything even when D & E fields populated - is it because E is a date field?