expanded

I have a dynamic report that lookups a couple of comments columns. Depending on size of text I would like to expand the rows height to meet the needs of the lookup. So default the row to 12 unless it needs to be expanded. Was going to write macro to do so but figured Id make sure there was no...

Hey everyone, I am having some issues with a message box popping up 3 times for each scenario in the code below. I tried using Boolean values as explained in similar posts, but that just made the problem worse. Basically, there are two cells in question. I'd like for one message ("A") to pop up...

I'm using a PowerPivot measure to determine average sale amount by customer for a particular type of product by dividing their total sales of that product by a distinct count of the item. When it's expanded, it works beautifully: When I collapse the row though, it throws off the average...

Dear Team, I have a Data Model that contains a Many To Many Relationship and a Bridge Table. Here is the picture of my Data Model: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/01-DataModelWithBridgeTable.jpg I have started to create an Expanded Table Diagram. Here is the picture of my...

I have a text box that needs to be several lines big but sometimes more text may need to be entered. If this is the case, I need everything else on the spreadsheet to be pushed down and the text box just expanded, as the text box is near the top of the page. How is this done?

Hello, I have a spreadsheet that has many row groupings. There are columns that only need to be seen when any of these row groupings are expanded. I figure this will require VBA code to accomplish. Not in my wheel house. Could someone please help by sharing code that will automatically...

I have this formula below which works only on a single IF, ISNA & VLOOKUP statement: =IF(ISNA(VLOOKUP(G770670,Aircrafts!$A$2:$A$1000,1,FALSE)),"Others","CL650") However, when I expanded it to use multiple ISNA & VLOOKUP, it doesn't work...

Hi, I am trying to paste into a table already in existance in a spreadsheet. When I paste special values or just paste. The data does not come over. I see the paste area highlighted but there is no data in it. The table is expanded enough and even if I just try to copy and paste the last record...

All, I was typing away in a cell on excel when suddenly, I noticed all my columns expanded in width. When I look at the actual column size number, they didn't change. How do i get this spreadsheet to go back to normal? Thanks, Dan

I am trying to get data from www.tab.com.au into excel however don;t know how. To understand what I mean: 1. Go to www.tab.com.au 2. Go to menu/todays racing/greyhounds/Cannington (select race 8 as an example) 3. Above the first dog their is a button that says "Show all form"- click on that and...

Hi, I have a rather large sheet containing vehicle tracking information, I need to identify the first trip for each day for each driver. I have the formula below, which seems to work over a short range, however when expanded to incorporate all entries I get a completely different value? Any...

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...

I found this: Sub Collapse_All()mp ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1 End Sub However, when expanding the groups, they are still expanded. For example, there are 5 groups expanded. They get collapsed with the above code. The 2nd group is expanded & all subgroups...