Last seen: Jun 8, 2026
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
EDIT: Velouria posted while I was looking at the workbook 🙂 Hi John, On the 'Schedule 2020' sheet, cell E10 is part of the header row for ...
Hi Craig, That's an image of your spreadsheet, not the spreadsheet. Phil