Search results

I want to hide the shape. Ideally I would like to hide the rows as well to condense the space, but that is not essential.

I'm okay using VBA. Maybe I misspoke about macros. I just don't want the user to have to click anything or run any macros to get the rows hidden or object hidden.

I have a shape that i want to hide if the value is not "OE". Is there a way to do this?

I need help hiding rows based on the value of a dropdown. The dropdown is located in C1. When it displays "OE", I would like Rows 52:54 to remain visible on the sheet. When it shows anything other than "OE", I would like Rows 52:54 to be hidden. I would prefer this to be done based on when...

Does anyone know how to add labels to the map, such that a bubble or column would have a text box next to it that shows the name of the location or reference field? When you have 300+ data points, a legend becomes useless, so I'm looking for a way to having data labels attached to each zip code...

I'm not sure how slicers would be of any help here. I need the pivot table to show a sum of field 1 but then show basically an average of field 2. I tried to create a calculated field that takes the sum of field 2 divided by the count of the number of records, because I cannot use a straight...

I have a spreadsheet in which the data shows multiple records for a single account - each separate row shows a payment amount tied to a date. Each record also shows a summation of a different payment amount for that contract. I need the pivot table to sum the unique values associated with each...

It did work - it was simplier to unlock those cells rather than to insert VBA code to unprotect and protect. Thank you

When I try to reference a hidden cell (in a password protected sheet and password protected workbook), the macro does not run and tells me the reference is not valid. I am trying to goal seek cell K4 to equal Cell D44 by changing cell d39. All cells are hidden.

When I refresh my query from my data source some of the cells shift around in the data table. The cells that are shifting are being manually entered next to the query data. Each time the query is refreshed, the cells shift down x number of rows. Then when the query is refreshed again, the...

Thanks mooks - looks like it works.

I need to put code into the worksheet that will force a macro to run when any one of five cells change (the cells are C4,B8,B9,B14, & B15). The macro is called "Solve". Can someone help me figure out the code that needs to be in place in order to run this macro when any one of those 5 cells...

Does anyone know how to write a present value formula where there are multiple advance payments (e.g. 3 advance payments) contemplated.

If I were using filters in a data table is there any way that I can show what filters are being used, without clicking on the filter? Is it possible to have a cell reference the filters and show users of the workbook what filters are selected?

I am trying to write a macro that can solve for a value that is the closest to a pre-dertermined value. I am unable to solve for the exact amount because I am dealing with a specific number of payments to achieve a desired yield. I am only able to have whole payments (not partial). Is there...

When i create a dropdown list through data validation the font size in that list looks incredibly small. How can I increase the text size in the dropdown?