-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
altering
-
C
VBA to Insert Rows??
Hi there. I have used the following code (copied from the Internet) with success - it inserts rows into my spreadsheet based on a number from another cell - perfect: <tbody> Private Sub Worksheet_Change(ByVal Target As Range) If Target.AddressLocal = "$P$5" Then Dim i As...- CERipkenJr
- Thread
- altering cell code end rows
- Replies: 5
- Forum: Excel Questions
-
T
Dynamically change Pivot Table as a source for chart
Hello, I have 3 Pivot tables each having rows and columns. The number of rows and columns changes according to slicers. Using a drop-down menu, I need to show on a chart (stacked columns) only 1 of the pivots. Meaning, I need to alter the source of the chart dynamical. How can I do it...- TamirBasin
- Thread
- altering chart columns pivot pivot chart vba
- Replies: 0
- Forum: Excel Questions
-
Automatically altering a cell value by 100
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Could someone help me with this formula. Each time time a value is put in A1, I would like the value in A2 to be reduced by 100. Thank you <!--[if gte mso 9]><xml>...- gadgetman
- Thread
- altering automatically cell reduced time
- Replies: 2
- Forum: Excel Questions
