# Banding Numbers Associated Trigger Points?

Mar 4, 2014

We have a customer rebate in place with various levels of refund based on the quantity purchased during the year. I have used a sumproduct formula to calculate this before.

The customer used to have the following set up -

0-999 - £1.00 per unit rebate.
1000-1999 - £2.00 per unit rebate.
2000-2999 - £3.00 per unit rebate.

So if they bought 2501 units they would get a rebate of (1000*1)+(1000*2)+(501*3). However the customer has trigger points so rather than the above it is now -

0-999 - £1.00 per unit rebate.
1000-1999 - £2.00 per unit rebate.
2000-2999 - £4.00 per unit rebate if 2500 bought.

So now it would look like this - (1000*1)+(1000*2)+(501*4). However if they only bought 2499 units it would be (1000*1)+(1000*2)+(499*2).

## Adjust Code From Cell Range Trigger To Button Trigger

Jul 1, 2014

I have the code below that is two separate activities and I want to change the second activity from a cell trigger (Set KeyCells = Range("K42:AD42")) to a button trigger. I need to first to remain unchanged.

I'd be ok if this was just one macro that I could assign to a button but because its two and I need to write the second's to clicking a button I'm over my head.

Its occured to me while writing this that because it'll be a range of buttons I'll probably need to make each one an individual code? Is this the case? If so I may have to just keep this as it is.

## How To Add Numbers - Input Points

Jun 25, 2013

How to add numbers such as if a person has 15 points how do I input two points and have them added up to 17 points does it require multiple sheets or is there a command to do this seemingly simple operation.

## Charting 2 Data Series With Different Numbers Of Points

Jun 12, 2014

Have Series 1 (to be a line chart) with 20 data points X values are 0 to 68. Have Series 2 (Bar chart) with 68 data points, again X values 0 to 68

Cant get series 1 to display beyond X value of 20

## Reducing Decimal Points Without Rounding Up The Numbers

Jul 25, 2006

I have columns of geological data in number form which may have about 4 or 5 decimal points. I want to reduce them to 2 decimal points without rounding the numbers up. Is there a simple way to do this?

## Change Default Decimal Points For Numbers

Feb 14, 2008

I've got a wierd simple problem in Excel 2003. I have a laptop and a desktop machine, and I'm an accountant who uses the fixed decimal feature as a default, with it set to 2 decimal places.

On the desktop machine, if I input "23." into a cell and then hit enter, the value left in the cell is "23.00" However, on the laptop, when I do the same thing, I get "0.23" In essence, it ignores the fact that I entered a decimal point.

If I enter "23.0" in a sheet on the laptop, it puts "23.00" in the cell.

I thought maybe it was some sort of hardware thing, like the KB was messed up, but then I used remote desktop to try to see what would happen if I enter numbers into the other computer using the laptop, and into the laptop using the desktop. The laptop when connected to the desktop performed normally, just like the desktop machine. The desktop, when connected remotely to the laptop behved like the laptop machine. In other words, I believe this test takes Hardware out of the picture.

Which leaves some strange obsure setting in excel someplace tht is causing this behavior, and I can't seem to find it.

Does anyone here know why these two installs treat the data entry so differently? It's driving me nuts.

## Row Banding

Jul 23, 2008

i am having problems with the conditional formating function.

to make document i am working on for office a lot more clear i was hopeing to do some row banding. i think you can get some basic row banding in auto format but i was hoping to do it myself.

when i go to conditional formating - i change the tab to Formula is: ...

## Color Banding On Columns

Apr 5, 2012

I am trying to band columns together in two's and this formula works except for I need the banding to start with column B.

=MOD(INT((COLUMN()-1)/2)+1,2)

Example:
Column A - no banding
Column B and C - banded
Column D and E - no banding
Column F and B - banded
etc.,

Is there another solution to this without maybe adding a helper row below the data with 0 0 1 1 0 0 1 1 0 0 and do the conditional formatting based off of the helper row?

## Color Banding Of Arbitrary Range

Nov 23, 2007

I know that if I select say A1:C100 on a spreadsheet, I can color alternating rows using conditional formatting and the formula =MOD( COUNTA(\$A\$1:\$A1),2). I am using COUNTA -- rather than simply ROW() -- so that I am only considering visible rows. I am trying to write a VBA subroutine that takes in an arbitrary range and colors in every other row of that range. Something like:

Sub FormatRange(ByRef theRange As Range, ByVal theColor As Integer)
theRange.FormatConditions.Delete
theRange.FormatConditions(1).Interior.ColorIndex = theColor
End Sub

However I want to make the argument to COUNTA refer to the first column in theRange, not necessarily column A in the spreadsheet.

## Color Banding To Locate Active Cell

Mar 24, 2006

I used the method described here:
[url]

The problem is that it seems only to work on the computer on which I made the sheet. This should mean that it is somehow dependent on some local settings. Does anybody know what settings, or whether it is something else that may be the cause?

## Conditional Formatting For Row Banding Doesn't Work After Autofilter

Sep 8, 2009

For obvious reasons, the conditional formatting to shade alternate rows doesn't work when filtered. So I think I need another way of doing it. Luckily, my table is fairly static, rows aren't added or removed. The first column is excluded from the banding. As is the first and last row with data (1 & 67) respectively. I found a relevant thread here, but the code is beyond my understanding.

## Points Property Select Multiple Points

May 2, 2007

Is there a way of amending the following line of code so that it selects multiple data points in a data series in a chart (e.g points 14,15,16)?

ActiveChart.SeriesCollection(2).Points(14).Select

## How To Trigger A Message Box?

Dec 17, 2007

how to trigger a message box?

if i type TP123 in cell A1 i want it to trigger a message box with a comment

## Can Excel Able To Trigger If Due Date Is Set

May 20, 2013

I am preparing a list of calibration items that require yearly calibrated, how can I set the date and prompt me example 1 month ahead when the item is going to due soon.

## Conditional Formatting Using A Trigger?

Sep 17, 2013

I have attached a sample work book.

What I want to achive is the colouring of the cells in columns A-L using the trigger of the "Y" character in colums J-L

So when a Y is put in column J the cells to the left and including column J change to green. Then when a Y is put into column K the cells to the left and including K turn yellow. Finally when a Y is entered in column L the cells to the left and including L turn the lovely shade of Pink. It is possible the process will go from a Y in column J to a Y in column L mising out column K but I don't suppose this will matter.

I used to have it working in office 2003 to a fashion but have not yet got my head around 2010

## VBA To Trigger Event Change

Feb 26, 2014

I have a chart with 2 Y axis. I am attempting to write some code that will update both axis with the same max & min value that is triggered by the combobox selection. The code will update the axis but is not triggered by the combobox selection.

[Code] ...........

## Trigger Macro After 15 Seconds

Feb 22, 2009

I want to trigger a macro that refreshes a pivot table but I only want to trigger the macro after 15 seconds. The reason is that I am pulling the source data from access mdb so I want only to refresh the data once the data is pulled.

## Sumif - Only Trigger On Certain Month

Oct 20, 2012

How do I amend this formula to have it only trigger on a certain month.

=SUMIF(C:C,1,F:F)

Date Description CatCost feesTotal Balance
20/02/12 PayPal Credit 10\$0.10 \$0.00\$0.10 \$0.10
20/02/12 PayPal Credit 10\$0.01 \$0.00\$0.01 \$0.11
26/02/12 Payment 1\$174.69 \$4.49\$170.20 \$170.31

I need it to look at what month it is and then the category.

## How To Trigger Macro On A Condition

Jan 25, 2014

Is it possible to trigger a macro on a condition like this?

If date more than 1 week arrange date in sequence order.

## Create A Automated Trigger

Apr 5, 2007

I am having trouble trying to get an MS Access Query to run from MS Excel automatically.

I am trying to create an automated trigger in MS Excel that will automatically run my Access query by the times I specify in my statement.

For example: I need to run a query in Access at 9am, 12 pm and 10pm, that's it, but I believe I need to do it via Excel, I don't want the data returned to Excel, I just want Excel to execute the query at those specific times!

## Drop-down Box Value To Trigger Macro

Jun 21, 2006

A1 is a drop-down list, created from Data> Validation>List, which lists 3 different words (Text1, Text2, Text3). I have recorded 3 macros (Macro1, Macro2, Macro3). Here's what I want to happen:

When Text1 is selected in A1, I want Macro1 to run (same for Text2/Macro2 and Text3/Macro3). I want the user to be able to change this value as many times as they wish and have the corresponding Macro run each time. I've tried creating the appropriate code in Editor using other threads on this forum, but I can't seem to figure it out.

## Function Activating Without Known Trigger

Aug 2, 2006

I am encountering a strange situation with my Excel 2000. I have a public function, in a module in the VBA project associated with my workbook. But I'm not calling it from nowhere inside the code, or from other macros - it is not being referred anywhere in the workbook. Yet, after I make a slight change in code and not save my changes, when I return to the workbook and select a value from any cell with a validation-list (regardless of the sheet where it resides), that particular function is being executed!

## Trigger Event Web Query

Mar 22, 2007

I have already use excel web query, and set every 5 minutes auto update web.
And here is question , I want to use vba event to trigger when cell's value changed.

Unfortunately,

Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

This code didn't trigger successfully,I think that web query make cells
value changed didn't trigger the event.

## Trigger Click Events Via Vba

Jun 14, 2007

Is it possible, that while running code that the code can say initiate the click event on a command button on another sheet.

Say that I have a button on Sheet1 called "wkscmd_DisplayDEI"

Behind that button is obviously some code. I want to know is it possible that while some code is running ( code does not reside on the module page for Sheet1 that it can send a pseudo click to the button?

## Using Letters In IF Statements To Trigger Computations?

Mar 4, 2014

i'm attempting to create a spreadsheet that will enable me to calculate the number of certain materials required to construct new rural fencing. I have 4 different 'types' of fencing each requiring different levels of materials required. For example, a Type 'A' fence, requires 5 'droppers' per 10m span of fencing, whereas a Type B requires only 1, a Type C also requires 5 - but a Type D does not require any.

Here is what I have attempted to generate so far - but is giving errors;

=IF(E42="A",((E35/10)*5),0),IF(E42="b",(E35/10),0),IF(E42="C",((E35/10)*5),0),IF(E42="d",(0),0)

Cell E35 is a fence length field to compute that number of droppers per 10m span of fencing.

Cell E42 is the cell for fence type (i.e.: A, B, C or D).

## Restricting Auto Add Row In Second Sheet To Only One Trigger

Jul 28, 2014

I have cut and paste some code provided by members of this great forum to insert a row in a second worksheet at the same row number when one is inserted in the active worksheet. e.g. If I insert a new line at Row 14 in worksheet "admin" I also get a new row at Row 14 in worksheet "report".

Code is as follows:

Private Sub Worksheet_Change(ByVal Target As Range)
Set sourcebook = ThisWorkbook
Set targetbook = ThisWorkbook
Set targetsheet = targetbook.Worksheets("report")
myRow = ActiveCell.Row
targetsheet.Activate
ActiveSheet.Rows(myRow).EntireRow.Insert
sourcesheet.Activate
End Sub

However, anything I do in worksheet "admin" triggers a new row to be inserted in "report".... If I change text in any cell, or make any changes at all, I get a new row in "report".

Is there a way to restrict this action to only a line insert?

## Trigger Hyperlink Based On True Value Of IF

Oct 21, 2008

I need to trigger a hyper link say "Modify" based on the "True" Value of a "IF" condition in that sheet.

We can place that "IF" condition Right next to the Hyperlink if needed. But how to do that.

the If condition is like

The cells are dynamic and even the sheet is Dynamic.(they can be any cell and any sheet)

## Trigger A Macro On Workbook Close?

Dec 5, 2008

When I open my workbook it also opens a separate workbook and hides second book.
when I close myworkbook I want to unhide the hidden one and close it without saving.

## Trigger Macro At The Start Of The Month

Feb 18, 2009

is possible to trigger a macro at the start of every month. I have a fairly simple bit of VBA, but just want it to execute on the 1st of every new month.

## Trigger Actions For Three Choices In A Macro

Dec 30, 2009

I have a series of macros altering various workbooks and sheets. They're numbered Step1, Step2, etc. In my Step5 I have a series of Case statements in a macro, and I don't know how to get it to do what I want next. I have NOT tried running this code yet, and I'm sure I have something(s) wrong in it.

1) If the selection in DstWbk, sheet "Steps", is "01DSP" through "11DSP" the macro needs to delete specific columns in the SrcWbk, and then move to the next step (6).

2) If the selection in DstWbk, sheet "Steps", is "*DSP" the macro needs to go directly to the next step (6)

3) If the selection in DstWbk, sheet "Steps", is anything else the macro needs to flash a generic "No Data found" message and move on to Step7.

The part of the code that's throwing me begins at 'Select only the specific regional data' and ends at the "Case Else MsgBox"