Forum

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

Hi, is the value for D supposed to be 130,000? Phil

Thanks Jim, The workbook doesn't match up with your description of what you are trying to do. There's nothing in Column C. Col B contains text so...

Hi Christy, Something went wrong with that upload because the link doesn't work. Can you try again please. Phil

Not that I can think of.

Hi, In your workbook, the first example for Karthikeyan, the OS value is 475,998 but the tag is A? But in your lookup table the treshold value for...

Hi Jim, Please read Please attach your workbook. Without your workbook it makes it more difficult to visualize and recreating your data will ...

Hi Pedro, Please read this You need to attach your workbook so we're not wasting time recreating your data. Regards Phil