Forum

Hi Bandi, To populate a ComboBox use the RowSource property. First create a named range for the cells containing the data to go into the list, the...

Hi Lea, I'm confused. You ask that names be split so that first name and last name are on separate rows. But the example you provide in Invert-col...

You're welcome.

Hi Kenneth, A quick search indicates this could be fixed by declaring a sheet object and manipulating that: Sub SetSheet() Dim cp As Workshee...

Hi Chris, Why can't you change the source data into tables? If Excel functions and other tools are designed to work with this data structure, su...

Hi Hussain, If you only want to keep 13 rows why not copy/paste these somewhere safe, delete the entire 2nd list, then cut/paste the 13 rows back a...

Hi Vedant, The W2 you've supplied is completely empty so I don't understand the need for it? Why not just copy the W1 file and rename it W3? Or...

Hi Cally, If you want the 3 separate calculations they will individually look a little different to the initial formula, because some of the logic ...

Hi Cally, If your value is in B2 =IF(B2<150000,B2*0.025,150000*0.025)+IF(B2>150000,IF(B2>500000,(350000*0.01)+(B2-500000)*0.005,(B2-150...

No worries 🙂

Hi Josias, It's a bit confusing because your initial post, subsequent post and attached workbook don't all agree. For example, you don't have a Sh...

Hi Gary, Can you attach your workbook please so we don't have to type in your data. Thanks Phil