b19

Hello, Can you help me with a macro please? I need to auto populate certain cells in different rows with "N/A" and grey shading depending on selections made in column B from a dropdown list. For example, if we select "School" in cell B19, then E19 to P19 show "N/A" with grey fill colour and...

Hi Everyone. I have this formula below: =IF(B19<=$B4,ROUND(F18+D19+E19,2),IF(B19>$B4,0), IF(ISBLANK(B19),"") It is supposed to do three conditional things in an Outstanding balance column. 1. If B19 (repayment number) is less than or equal to $B4 (number of months) THEN perform calculation...

Hi All, So i just started learning excel and the vb part of it, im getting some of it but not all of it... what im trying to do is take a single word like blue and have it add 1 to a cell that has a number... ie if i have 15 in B15 and then change H2 to blue i would like it to add 1 to 15 to...

Hi All, Very new to the Marco's and would really appreciate your assistance to provide me with a macro that can hide/unhide rows base on a value in a certain cell. I am working on Excel 2013. And have 3 Worksheets which the information on my result sheet is pulling from (2 Sheets with Data + 1...

Hi all, i'm new to excel and I'm having significant problems fixing my issue. I need to find the amount in column H (titled Actual) based on three types of criteria. 1. I found it easier to concatenate data on column A. That includes two of my criteria, which is Category, and the Acct. No...