Hi All, I have data like what is presented below. I want to group by col1. before ======== col1      col2      col3 1      2      3 1      2      4 2      3      5 2      4      5 3      5      6 7      8      9 7      8      9 After ======== col1      col2      col3 1      2      3...

Hi I have a string, it is in text format, I'd like to take 4 first characters from the left (this 4 characters are always digits), increase by 1 and add back to the some string. I do it in MACRO...

Hi I have a problem like this: I have a sheet with rows and sometimes I have 2 similar records but only with diffrent volumes of stock. Id like to add the volumes and delete only one with added ...

Good afternoon Experts, On a VBA UserForm how can I: 1. Place OptionButtons within their individual Frames and yet keep them within the same Option group. In other words when I select an Opti...

Hi I have a Pivot Table. It has been organized by months. I have 12 months but for one month there are no data so the column with this month doesnt appear, I have 09/2008 changing to 11/2008. Ho...