Forum

Hi Shirley, Nothing attached, did you click on the Upload button? Instructions here Regards Phil

Hi Aye, I'm not sure what you are asking: 'prepare the data for month with null value'? It's not clear where your source data comes from. You m...

Hi Florence, Welcome to the forum. Your attachments did not attach, did you click on the 'Start Upload' button? Please see here for (video) ins...

Hi Francis, Always best to provide your workbook and data so we don't have to recreate everything from scratch. If your conversion rate is the o...

Hi, I'm not really sure what you mean by 'your way of writing parameter', maybe you could explain more clearly with an example? However, if you ...

You're welcome.

Hi Gokhan, You will either have to use VBA for this, or do it manually by going to the Ribbon -> Data -> Sort & Filter -> Reapply. ...

Hi Gokhan, You haven't attached a workbook I don't know if you have your data in an Excel Table or not. But if you do then you could just use the ...

Hi Christy, If you use the code I linked to it will solve your problems. I've incorporated it into the attached file. Double click a cell in Co...

Hi Jim, You can use VLOOKUP to do this. I've modified the lookup table in Cols H:I in order that VLOOKUP will work correctly. Your example look...

Hi Leslie, I'd switch to using regular form controls rather than ActiveX. You can use this to test the buttons If frm.OptionButtons("YesBtn")...

Hi Nish, This sounds like homework rather than a real world scenario, and I'm afraid we don't do people's homework for them. But will be happy to ...

Hi Christy, If your file is too large to upload here then use OneDrive and share it. That said, if you are using the code from here it sh...

You said I want to tag each record to A untill the sum of OS becomes equal or not great than A. then the next record should start taking B s...

Can you please check your examples, they don't seem to match up with the description of what you want - see attached image. Phil