Forum

Hi, What have you tried that doesn't work? Please supply the workbook and code. What version of Windows are you using? Regards Phil

Hi Bhavesh, So what is it you actually want to do, you haven't really explained? Change $Z$54 to some other cell reference? Please supply the w...

Please supply a workbook with sample data and examples of your expected outcomes, and cover all scenarios. Thanks Phil

No worries - see attached. P

Hi Candid, try this attachment. The values for the bands (1M, 20M etc) are hardcoded into the formulae. So you should replace these with cell r...

Hi Candid, This is why it's always best to include a workbook and several examples of the desired outcomes. So to make sure we are clear, do you...

Hi Candid You should read about nested IF statements =IF(A2<=1000000,0.055,IF(A2<=20000000,0.03,IF(A2<=30000000,0.025,0.01))) Work...

Hi Andi, Not sure how you can change a cell, but at the same time not change the cell. Why do you want to do this? If you can explain your inten...

Your data validation formula could be =EXACT(B2,VLOOKUP(B2,E2:E6,1)) with the cell you are typing into being B2 and the permitted list of inputs...

PBI File attached

Chen, There's no attachment. Phil

Try =HYPERLINK("F:Study Material"&C3&"2017" & A3 & ".docx",A3)

Hi Maurizio, Your code is looking for elements with the HTML class name "sunny" but I don't see anything on the page that has that class name. The ...

Please supply the workbook so we don't have to key in the data and recreate everything. If I enter your COUNTIFS formula into the Units column I ge...

Hi Luke, I have no problem with that string either. You haven't supplied the XLSM that generates the codes though so it's impossible to check wh...