grouped

Hi everyone, Is it possible to display the number of grouped items as a value or as a bracketed suffix to the name? For example: Accessoires would show "Accessoires (12)" and Accessoires Indoor would be "Accessoires Indoor (39)" even though it is collapsed. Alternatively, B3 would show the...

On one worksheet I have a group of buttons (not actually grouped, but just adjacent). When I click one of the buttons is unhides another worksheet and hides the first worksheet. The buttons show as an image on the second worksheet and the real buttons on the second worksheet are not visible...

Just wondering if I can shorten my code a tad by changing grouped buttons with 1 command instead of two. For example: If you have a group of two radio buttons (for this example I'll call the group "NewEmp") and you want to lock or unlock them, do you have to use two commands (i.e...

Hi again all, I have a new hire checklist that has 5 groups and various rows in these grouped rows for each group. (Example rows 3-7 are grouped for network access ID's. rows 8-13 are grouped for software that needs to be installed). Each grouping has its own merged and centered title in Column...

I am trying to write a macro that can go down a column and find if multiple rows in the column are grouped. If they are, then I would like for it to ungroup them then place the value in all of the rows that were grouped. In other words if A1 and A2 were grouped, ungroup them and then put the...

Any ideas how to stop toggle buttons from moving every time i open my spreadsheet. I have a few of them. I have grouped them, set them to don't move or resize but they still do it. Many Thanks

Hi, I have an excel template which can be used by different users. I would like to have a macro that expands or collapses a group of cells when a specific user-type is chosen in a "user" dropdown. Details: Dropdown is found in cell A4 and has option of choosing user A or user B. If user A...

Hi There, I am trying to copy all the data in my row that includes the grouped dated. If the data is grouped and I past the new row in it messes up my conditional formatting. If the data is ungrouped the conditional formation just expands another row. Is there a way to include the grouped data?

Hello, I am new to VBA coding and would appreciate assistance with the following scenario. I have a file that I would like to hide a range of columns across multiple sheets. I am wanting one button to be able to do all this at once if possible. On sheet 1, I am looking to hide columns (L:R)...

i have a large worksheet that I want to apply a Filter in Row 1 across all columns that will show me all data in each row for any given column. I have a data set from Row 6-42, that are grouped then another data set from row 48-50, that are grouped and so on throughout the worksheet down to...

I am trying to make an incident column in a log. I have the following formula in the table column cell (is a table so increments): =VLOOKUP(WHSELocation,Hidden!J2:K33,2,FALSE),ROW() Of course this is coming back in error. The idea is it is looking in 'WHSE Location" a name, it matches...

Dear all, I need help. I would like to group the rows if the value is zero. For example, if cell a10 has a value, and a15 has a value, then row 11 to row 14 have to be grouped as row 11 to row 14 values are zero. I have 2000 rows. Can anyone help me with this please? Thank you very much!

Hi I'm writing an Add-In so people in my team can copy charts automatically to PowerPoint or Word. I just tested it on a file where one of the charts has text boxed and an arrow grouped together - these will need to be copied together. First, How do I tell that the chart is part of a Group. I...

Hey, I have grouped amounts and it equates to the subtotal. I would like to sort all of the subtotals will my groupings follow?

I have a workbook that I am supplying to a production shop to help allocate their costs properly. For the most part, the sheet takes a few columns of inputs from the operators that are used in formula driven cells to calculate various costs. I first made sure that all the cells in the sheet...

Hello Masters of Happiness, I have learned tons on this site without ever asking a question, but today I need help!! I have a protected worksheet, and users are to access certain cells. Those columns that are most relevant are displayed, while less relevant columns are grouped and collapsed. I...

NOTE:This post is NOT about allowing a user to Expand (+)/Collapse (-) grouped rows/columns on a worksheet, but is about increasing/decreasing the number of rows/columns that are included in the existing Row/Column Outlines. I have the following code in a macro that toggles sheet protection on...

Hello, I have the below code to toggle my grouped columns in excel to expand and contract (the code doesn't remove the grouping), how do I amend this code so that this only applies to specific columns e.g. A:E and leaves all my other grouped columns Thanks Public Function...

Using Microsoft Excel 2016 MSO 32-bit from Microsoft Office Professional Plus 2016. I have a workbook that contains several sheets, one of which holds a structured Excel Table used to record individual investments. The table includes various data entry columns as well as several...

Hey Dear community, I have very big data, where i need to count income based on markets, but there are some group of markets in my list with different names, i have already grouped them. ( for example N-market 1 , N-market 2 , N-market 3 ) So all N-markets are in A2:A10 How can i ask excel to...