expand

This is an additional question from a previous post. I received the following code, however when using in a different worksheet it is not working well. I am trying to place a total row (sum) and format this row. Possibly bold font & fill The range is D5:Lxx). Column 12 may expand. Dim lr As...

I have the following code, which I would like to expand. I would like the data to be filtered down to anything that starts with the letter F in column 113 and certain things that start with the letter V. I would like to expand upon this, to include a list of about 23 allowable criteria that...

Is it possible to have a pivot table so that it always shows as 'expanded' all. I have a large data set and want it to show expanded with the option to collapse rather than collapsed and then have to expand. I know you can expand all in a column however on a dashboard it is easier and better...

Hi Is it possible to expand and collapse individual groups using vba i.e. as opposed to expanding or collapsing all groups. In the following example I would like to have 3 buttons somewhere on the sheet, one for each group, to toggle expand collapse each group one at a time [/IMG]

Hi, I have a cell A1 that will either be "Yes" or "No". I have cells(rows) A2-A11 that are grouped and defaulted as collapsed/hidden. I want these rows to automatically expand if A1 is "Yes". Is this possible?

Hi, I transform data in Power Query and now I have some columns that need to be expanded. Do I have to expand each column singulary or I am able to expand several columns at once (by their name or index)?

Hello! I have a sheet full of data. In column A there are many rows with blank cells. I'd like to collapse (group) them up to the previous row that contains data. The goal is to have all data showing where there is a value in Column A. The user could then click the "+" next to that row and...

One of the features I love about Excel tables is that as you complete a row of data and tab through, it will automatically expand to start the next row. Further, that doing this carries forward formulas and formatting to the newly added row. However, I am finding that if the sheet with the...

Hello, I have been working on this "database" program for a couple of days, but just cannot get one thing and would greatly appreciate some help I have a fill form which is created every time a new sample is added and information gets inserted into their respective columns V W X Y Z AA AB AC...

Hi All Very minor issue but curious to know if there's a way round it. I have some code which generates a report and emails it to the recipients, part of this code is applying grouping on certain data within the report. I've noticed that when the user expands the group (based on Rows rather...

Hi! I really hope someone can help me with this issue. I have a spreadsheet with MANY columns containing array formulas to display values from columns in another excel file. For example: {=if('file_path\file.xls'$A$2:$A$500="","",'file_path\file.xls'$A$2:$A$470}. Basically, when it would...

I have many columns (budget, forecast, and variance) for each month and quarter. I need to collapse and expand the variance columns as one group. How do I do this?

Hi, I'm trying to automate a micro to collapse/expand certain cells in a spreadsheet as data is put in (i.e. if Cell A>0, then Cells B-F will expand, if Cell A<0, then Cells B-F will collapse). Currently, the code WILL do that but only AFTER clicking the A column. Below is the code I use, any...

I have <50 sets of grouped rows in a spreadsheet (3 sub-levels of grouping at most) and for some reason it takes much longer to expand collapse one particular group vs. the others. The only thing I can tell that is different is that these rows contain 2 named ranges (both just 1 cell constants...

Please help me with code that inserts or deletes an appropriate number of rows when expanding or collapsing pivot tables that would otherwise overlap another pivot table when expanded. I have several pivot tables stacked on top of each other on one sheet, all with the same column headers...

Hi, I'm am using Excel 2010. So, normally if you have a text cell with more information that is shown in the cell you can double-click the cell to expand it and see all of the text. My issue is that I have a cell with a VLOOKUP that returns a long string of text. However, because the cell...

Hi, I have a set of biological measurements that I am trying to organize. I would like to show both the summarized data and the individual data points within the same table. Is this possible with a PivotTable? Here is the data in summarized form only: The data consists of three replicate...

I am using VBA to allow users to Expand/Collapse columns in a protected sheet but it is over-riding the ability to filter a table. If I right click on the tab, unprotect the sheet, click the box so users can filter, and then protect the sheet again everything works fine, but once I save, exit...

Hi All, First post here. I've a little question that is giving me a bit of a headache. Is it possible to link to tables in excel, so that if I add a entry (a new row) to one of the tables the other one will automatically expand with a new row? Thanks!

I'm having a problem with collapsing and expanding the data in my pivot table. Currently my data is arranged by about 4 row labels: Owner Client Business Unit Project When I collapse/expand a client field for one owner, all client fields of the same name for all the other owners...