excel 2010 & vba

Hi there, I have a formula which the "Value if True" result is not calculating correctly. For example, if the date in cell D7 is 30/06/18 return 2016-17 but if the month of cell D7 is December, return the year of D7 minus 1 year. The bit that doesn't seem to be working is YEAR(D7)-1 This...

Hi there, I would like to calculate a year end date, based on a changeable date. For example, say the year end date is 30 June. eg. From start date 01/12/2017 I would like it to return the year end date it falls in, so 30/06/2018. eg. From start date 01/05/2017 Returns 30/06/2017 Cell F13...

Hi there, I have a basic formula of F230 - F232 = F234 Pasting the values of each cell returns the following results; + F230 421,028.9 - F232 396,028.9 = F234 24,999.9999999999 Why on earth is it giving the result 24,999.999999999 instead of 25,000 ??? I've tried changing all the...

Hi there, I use the below code to automatically reveal a row as the user enters details. It's been working fine but in this case, there are many ranges to take into account and when I tried to put it all under one, it came back with a syntax error (it's too long). Therefore, I am trying to...

Hi there, Can anyone see where I am going wrong please? Basically, if N80 is >0 return "Enter Capital Gain XPA Code" if N80 is <0 return "Enter Capital Loss XPA Code" Once the code is entered, I want the "Enter" to be removed from the description so, If N80>0 and N84>0 return "Capital Gain XPA...

Hi there, I have the below code, which is working well at hiding and unhiding rows depending on the number of investments selected from the drop down list. In additional to my current code, I was wondering if I could go a step further and hide further rows depending on the outcome of 2x drop...

Hi there, I currently have a data validation code which only allows the following formats: ### or ###/### I would like to amend the code so it only accepts the following format: 620/###...

Hi there, I have an IF statement which I'm almost there with, but I can't get the last part to work.. =IF(F45=0,"",IF(OR(D8="Company"}),"621/783",IF(OR(D8="Partnership"},F45>0),F14,I14),IF(F45>0),"511/001","521/001"))) So it's the last IF statement which I can't get to work...

Hi there, =IF(AND(OR($D$8="Trust - Business",$D$8="Company"),$F$47>0),"494"),IF($F$47>0,"465/"&LEFT($D$28,3),) So if D8 = "Trust - Business" or "Company" and F47 >0, return "494", but if it doesn't equal "Trust - Business" or "Company" and F47 >0 return "465/" and then first 3 characters of...

Hi there, I have written this formula but it is not working correctly =IF(AND(F45>0,D8="Partnerhip"),F45*D14,IF(F45>0,F45)) This is what I am trying to achieve.. If F45 is more than 0, and D8 = "Partnership" then F45*D14 but if F45 is more than 0 and D8 does not equal "Partnership", return...

Hi there, I thought this would be quite simple but I'm having difficulty stringing it together. In cell G30 I would like the user to be able to add 846 or 847. However, I do not want a drop down list, I would like to use Custom. Thanks very much!!

Hi there, I have two data validations I would like to apply to cell F17. The first one only allows number format of ### or ###/###. This code works fine; =OR(AND(ISNUMBER(F17),LEN(F17)=3),AND(ISNUMBER(LEFT(F17,3)+0),ISNUMBER(RIGHT(F17,3)+0),ISNUMBER(SEARCH("/",F17)),LEN(F17)=7)) The second...

Hi there, I've got an idea but I don't have the technical ability to write it nor do I know if it's possible. Hiding rows based on a change of a formulated cell is not easy to do. In this particular example though, the data is manually entered up top and summarised down the bottom by formulas...

Hi there, I currently have VBA code under both Module and the Worksheet which I would like to combine under one macro to run together. Independently, they all work fine. Below are the codes and in the order I would like them to run. All information is located on Sheet81 but the macro will be run...

Hi there, I'm not sure why this code isn't working. Can someone tell me if I'm missing a trick please? Private Sub Worksheet_Change(ByVal Target As Range) If Range("A17") = "TRUE" Then Range("F17:K17").Locked = False ElseIf Range("A17") = "FALSE" Then...

Hi there, I've tried a couple of different codes but can't quite pull it together. In Columns G15:G49 and H15:H49 I have formulas. If both cells in the columns equal zero (eg. G15 & H15), I would like to hide that row (row 15). If one is more than zero, it should be visible. If the data...

Hi there, Can anyone tell me why the following IF statement is not working? Regardless of the values in cells G51 and H51 (which are formulated) the IF statement result doesn't change from "Total Under Claimed". =IF(G51>0,"Total Under Claimed",IF(H51>0,"Total Over Claimed","")) Thank you...

Hi there, I currently have a drop down list which requires an individuals unique password to change it. Once a name is selected/the correct password is entered, I would like an initial and date stamp to be applied to the cell to the right of the drop down list. This stamp should only change...

Hi there, I have Data Validation set on my date entry cells so only a valid date can be entered. The formula I am using is =AND(ISNUMBER(E158),LEFT(CELL("format",E158),1)="D") and this works fine. However, when no date has yet been entered, I would like the cell to read "Enter Date". I tried...

Hi , I want to write the VBA code which can generate one pdf file with multiple sheet with specific range. I have excel file with 3 sheets: Accounting ,Management and invoice. I want generate pdf file which has data from Accounting from range A2:I43, from Management from range A1:H25 and from...