grouping

I've been struggling to find a macro code that allows both column grouping and row formatting (hide/unhide in my case) in a password protected sheet. The macros that I've used to allow column grouping work for that purpose, but then seem to disable the ability to allow row/column formatting when...

Hi. I have a range of cells and im looking to highlight cells with a similar name and group them afterwards. See the example below. <tbody> P1234-s 50 600 330 540 P1234-m 12 23 56 89 P1234-l 1132 435 75656 747 P1234-xl 34534 567456 56756 34 P1234-xxl 45 56 23 2 </tbody> I have...

Hi, I am fairly proficient with VBA, but have stumped myself. I have hundreds of columns (transactions/amounts) with hundreds of rows of data (names). I need to get my column data into a loadable format, which I am capable of doing. The part that is stumping me is adding a grouping line with...

Hi everyone, I create a list of payment signatories each week and as a control I need to create a conditional format to flag when two people from the same department have been put on the same day. Instead of creating several different conditional formats to say 'flag when 'x' is put with 'x''...

Hello! I'm not even sure if this can be done. I have several columns with various labels, for the example I am going to use; year, size, weight and height. What I'm trying to do is create a macro that assigns a number to rows to all rows, but puts the same number in those rows where the...

Hi Guys! I was wondering whether you now of a DAX formula or DAX measure that I can use in Power BI Desktop (power Query) to make sure all groups lower than 5% are grouped together and call them "other" while the others are just the same as normal. Secondly, maybe a bit next level, is that i...

Hi Guys! I am working in Power BI Desktop (Similar as Power Query) which uses DAX. I have 3 columns:, Response ID, Brand and Volume. Since I have around 50 brands per ID, the Response ID is shown 50 times. Now I want to summarize the total volume PER Response ID in a separate column, but when...

I need to protect a sheet and allow the users to be able to use the grouping buttons (+) on the top and left side of my spreadsheet. However, when protected, excel will not allow us to use that feature. Is there a way how to go around this?

Potentially silly question here - my apologies in advance.... I would like to basically recreate the grouping userform from the ribbon in Excel 2010. I have written a series of macros and userforms in a program that creates a lot of PT's and then lets the user group the data. A userform gives...

I need to group values in my pivot table with dollar amounts from 0 to 10870500 as follows: $0 - $250k $251K - $500K $501K - $750K $751K - $1M Over $1M Is there a way to do this? I have thousands of rows of data.

I have been searching near and far for vba code that can let me do this. I found someones code but I couldn't get it to work :( Anyone come across something like this before? Below is the code I came across: <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo...

I am creating Pivot Table that has counts of different buckets. I am trying to consolidate various field for reporting. Trying to duplicate record macro routine run into bugs. Here is a snippet of code For Each pvtItem In PVTable.PivotFields("buckets").PivotItems '...

I'm trying to create a macro to separate cells with the same information onto different sheets within the worksheet. I'm not well versed in macro's so I'm rubbish at this. Lets say i have 10 entries. <tbody> Nescafe Ambient 1/1/15 Muller Chilled 1/1/15 Honey Boyne Valley 1/1/15...

Hi - I am using Office 2013 and have a protected sheet where I would like users to still be able to open/close groupings. I have used the code: Private Sub Worksheet_Open() With Worksheet ("Europe") .Unprotect Password:="PW12" .Protect Password:="PW12", Userinterfaceonly:=True .EnableOutlining...

Hi all, I've been struggling with this excel problem for most of the day and I'm hope someone on this forum will quickly resolve the issue. My OS is Windows 7 and I am using MS Office 2007. I tried to upload the worksheet, but I can't download the add-in due to my office security. I have 3...

Hello, Wondering if this can be done in Excel. For example, my data looks like this: <tbody> 1674417003 U 3 10.15 10.15 11.84 16.65 16.65 1674417003 X 3 63.57 63.57 60.94 4.32 4.32 1674417005 F 3 1949.92 1949.92 1934.12 0.82 0.82 1674417005 H 3 3257.39...

Hello I have a piviot table that from one data set I have grouped the date data by month, I have then created another pivot table from the data set but I do not want the date data grouped , how do i stopboth piviot tables automatily changing to the set ive grouped

I need help with grouping together responses in a workbook. I am using Excel 2010 and I have columnA with Categories 1,2,3,4,5 and 6. ColumnB has the responses A,B,C, and D from a pull-down list (A,B,C, and D are all defined in cells elsewhere in the spreadsheet and then referenced for the data...

I am working making a primary sheet that retrieves data from other sheets automatically based on entries in certain cells using macros. My main sheet lists tasks, and my secondary sheet lists responsible party metadata (contact info, etc.). If a responsible party value is entered in a...