groups

Hello Guys, I have created a custom Ribbon with different groups, say "groupA"; "groupB", "groupC" etc. The top level groups work fine. I need to create sub-groups for groupA. That is when I select groupA (one of the main top tabs), I want to get a set of groups (tabs?) that all belong to...

Can somebody help me with VBA code which will allow me to copy the data from excel sheet and paste it to Different different groups in whatsapp (i.e. web.whatsapp.com on chrome). Thank you in advance.

I have a pivot table setup with dates along the columns, and these dates can be rolled up via groups into weeks or month. When the data is rolled up, is there a way to display the value from the last date in the group? In the example below it would be 2107 closing soh and 80 days cover when...

Hello everyone. The purpose of the worksheet is to assist in generating x and y coordinates by entering information at Range C2:C13. The inputs are for: Rows Per Group Columns per Group Starting X-Coordinate Starting Y-Coordinate Starting Z-Coordinate Rectangle Width Rectangle Height...

I was wanting to , via VBA or macro be abble to add multiple groups fo cells that pertaing to an individual client each

I have a spreadsheet with 20 different groups and each group has people assigned to them. I would like to be able to search by typing their first name in a search box and have it return what group or groups they resides with. Any help would be appreciated.

Hi Everyone, I'm looking for a formula or VBA code that will allow me to sort the following data: Col A Col B 1 3 2 3 5 4 5 3 6 6 7 1 Into specific groups like the below. Col A Col B 1 1 2 3 3 3 4 5 5 6 6 7

Greetings, I'm currently in the process of finalizing the approach to a dashboard I'm constructing in Excel. I've run into an issue however. I'm trying to have a set of object groups which include a number of header objects. The problem I'm facing is I can't find a way to streamline the...

Hi, So I’m looking to sort times into set groups based on the hours they fit into. So for example this: Col A. Col B 00:00 03:37 01:00 02:20 02:00 03:52 03:00 01:00 Would become: Col A. Col B 00:00 01:00 01:00 02:00 02:20 03:00 03:37 03:52 Thanks.

Hello everyone, Though some other posts have had similar solutions, I want to pair a list of unique identifiers to others with each pairing unique for each month. April has #1 with #3 and necessarily #3 with #1 The first three pairings were manual and would like a formula to generate the...

Hi guys, I need a VBA to enable the use of expanding / collapsing groups in protected work sheets. Not all work sheets have groups or protection, I'm not sure if that makes any difference. I have tried a few codes from google searches some required a password when the workbook opened which...

Hi guys, I'm currently in the process of creating a training matrix. I designed the layout thinking I wouldn't need to go the lengths of protecting certain areas of the work sheets, but a colleague of mine has proven me wrong. I protected the sheets not realising it would stop the groups...

I have a sorted worksheet that includes Outline/Grouped rows as well as single rows. As I add new rows and resort the worksheet, the previously grouped row NUMBERS remain grouped, however the rows previously grouped are often shifted out of that group. When I group rows I add a new row below...

I need help with some VBA to loop through a spreadsheet and Group rows with an indent level > 0. Indent level 0 is the highest level summary for the data, detail is broken out at indent level 1, 2 etc.. A data sample follows: Cash & Short Duration Cash and Money Market Money Market 1 Money...

Greetings, I need help with something I was tasked to do for work. I'm familiar enough with Excel to know this is possible, but not sure how to develop the formula. I have a list of items with prices that I want to group into 4 similar totals. For example, I may have 12 items (no...

Hi How can get the maximum of these number of groups in a VBA code? Thanks

All formations of suits of each two groups digit Are even / odd 0.2,4,6,8 1,3,5,7,9

Hi I am an analyst and I need help with an advance use of the sum product function for weighted averages. I am trying to calculate three different weighted averages within 1 of 50 groups of data. Each of the 50 groups of data have a different weighting score (different importance). I have...

I have a spreadsheet containing different groups of data, each of which vary in number of lines, separated by single blank lines. The number of groups also varies from month to month. I can find the last line of a particular group using 'SelectionEnd(xlDown).Select' with no problem but i don't...

Hi, I'm using a spreadsheet for utilization. I use different letters for different meanings. One of them is "R" I'm trying to find a way that it will count how many "R's are in a row, but only count groups. <colgroup><col width="48" span="4"><col width="59"><col width="48"...