Discount Check Macro

May 8, 2014

If I explain all the 8 steps , it will be lengthy and not easy to explain , thus I will go step by step

See file attached raw 01 , copy it on drive c directory called DISC , see file attached the result file

I want the the result file to go fetch data from the folder created DISC in which there is file called raw 01 and do the following with pulling headers , since the header is already plugged.

a to a
b to b
c to c
d is thus empty for the second step of the macro ( explain following after this fetching is achieved )
d to e
e to f
f to g
g to h
h to i
j to k
k it should not copy

View 5 Replies


ADVERTISEMENT

Conditional Statements Using IF: Get A Discount (no Discount) Not To Apply The 10%

Dec 22, 2009

I have attached a 2004 excel document that has a conditional statement that says, if an amount is over $400.00 you get a 10% discount, else, the cell says no discount. That is working fine. I also have a absolute cell ready to do the math for the 10% amount. There is also a column that shows the discount amount and column that shows the amount after the discount has been applied. Since I have been just doing one calculation and auto-filling, my problem is, how do I get the record that doesn't get a discount (no discount) not to apply the 10%?

View 4 Replies View Related

Discount Function In Macro

Mar 30, 2007

I have a quote system which takes data from tabbed sheets if there value is greater than 0, then does a simply formula which is then times by a discount which found by searching for the sheet name and then attaching the appropirate discount. In short this means that the whole forumale doesn't work and is not displayed

View 11 Replies View Related

Macro To Force Format And Check Barcode Check Digit

Nov 27, 2009

My company uses 4 types of barcodes 8, 12, 13, & 14 number barcodes for our products my problem is that I can't figure out how to force the barcode to format properly no matter how somebody enters it if they don't use spaces or put them in the wrong spots, I can't use custom formats because there is 4 different layouts

8 digit should be "#### ####"
12 digit should be "###### ######"
13 digit should be "# ###### ######"
14 digit should be "# ## ##### ######"

these barcodes are in columns L, M, & N also right now 'm using a formula in another cell to verify the barcodes by calculating the check digit and comparing it to the check digit typed the formula i'm using is

View 9 Replies View Related

Check Boxes Macro: Macro That Will Check If The Boxes Are Checked And If Not Ignore Them And If So Run A Certain Macro

Jul 28, 2006

I have numerous hyperlinks in cells on a worksheet, next to these I have checkboxes. I am looking for a macro that will check if the boxes are checked and if not ignore them and if so run a certain macro.

View 6 Replies View Related

Discount A Row

Dec 24, 2007

Is there a way to insert a discounted row at the top of an existing spreadsheet?

I'd like to name it "0" or "Row Zero" or "MasterRow" or something similar, such that the existing rows retain their original numbering, and none of the existing code is effected.

View 5 Replies View Related

Discount Based On Amount?

Feb 6, 2009

I need to create a price list a we give a discount based on the price of the product for example:....

All products over £100 have a 10% Discount, how do this and also at the sametime round the value up to 0.99p. ie Product ZXY123 is £123.99 10% off is £111.59 we need the calculated price to be £111.99.

View 2 Replies View Related

How Do I Discount By % (percentage) Not The Amount

Dec 3, 2009

how to get the discount to work the way I need to. As is, It requires a person to put in the actual amount that I will discount the product for each product sold. I would like to simply key in the discount percentage. EX: 10% or 13%

View 14 Replies View Related

Apply Discount After Calculations?

Jan 14, 2014

A customer has an overdue account, we will say in the amount of $500.00. We offer various discounts, 30%, 20%, 0% depending on the circumstance.

What I had previously worked flawlessly, that is until the higher ups changed how things had to be calculated.

Previously, we would take the amount owing and apply the discount (ie 20%) which would become the new amount due ($400).

We would then take the discounted amount and separate it into monthly payments:

$400.00
1st payment 60.00
2nd payment 60.00 (and so on)
6th payment 60.00
7th payment 40.00
Done.

The new way they want it calculated is (Same situation $500 owing, 20% discount).

$500.00
1st payment 60.00
2nd payment 60.00 (and so on)
6th payment 60.00
7th payment 60.00 *
8th payment 60.00 *
9th payment 20.00 *
Done

(*these would be the discounted amount, it would be stated that these payments would be removed if payments are made on time and in full yadda yadda).

The trouble I am having, is figuring out a way to tell excel to flag the specific payments. The reason behind it (i guess) is so that if a client becomes delinquent, the full amount owing would be sent to collections, not the discounted amount owing.

View 1 Replies View Related

Formula For Discount % According The Number Of Procedures

Jun 25, 2014

I need a formula to take away a percentage according the amount (number) ot procedures.

For example:

- procedure - price for one - 5 of it - 10% discount - final price

The idea is, for example, if I type amount of 5 procedures, automaticly to make 10% discount, if I type 10 procedure - make 15% discount etc.

View 6 Replies View Related

Calculating A Discount Based On Certain Rules

Feb 11, 2009

I'm looking for assistance with working out the following formula. I live on an apartment complex in Marbella Spain and we pay Monthly Community Fees of say $100.

We want to calculate a penalty amount for late payers of say 30% of the monthly fee due for non payers? So for instance if the monthly amount due in Cell D8 = 100 and the actual amount received in cell E8 shows 0 or then increase any figure due for the following month in Cell F8 should increase by 30% ($ 130) in the following month. and so on

I use Excel ver 2003. Trust my query is reasonably clear?

View 7 Replies View Related

Creating A Fake Discount Calculator?

Nov 9, 2013

I'm very new to excel, my boss request me to create a discount calculator. A cost of price is given. We have a fix discount rate of 5% of that cost value. Some new customer want more percent of discount to the item they purchase. To deal with that, a markup price will be quoted then we will make a discount according to what the customer prefer but the final discounted value will be always be the discounted 5% of our cost value. I've problem creating it because as example; the customer request for 15% discount, when I add the cost + 10% then minus it back to 15%, the value I get will no be the same of the fixed reduced 5% value of my cost value.

ac16xpZ.jpg

View 5 Replies View Related

Cost Price Vs Quantity Discount

Apr 7, 2008

I'm trying to work out how to get a spreadsheet to calculate when it works out cheaper to buy more of something, due to quantity price breaks, than less... e.g. 1-10 are £12.50 each, but 10-20 are £10 each and 20-30 are £8.75 each.. so it's as cheap to buy 10 (10x10=100) as it is 8 (8x12.50=100) and cheaper to but 10 (100) than it is to buy 9 (112.50) than 10... but there are similar price breaks at 20, 50 +

View 9 Replies View Related

Discount Formulas: Cells To Calculate $40 X (100%-10%) = $36

Jun 7, 2006

I would like to ask the formulas for this... for example:

$35 .. discount 10% + 25%

instead of having so many cells to calculate $40 x (100%-10%) = $36
$36 x (100% - 25%) = $27

View 2 Replies View Related

Discount Applied To A Cell And Rounded To Nearest Nine

Jul 10, 2014

I want to take the value in I and apply a 10% discount to it and place the new value in column M. Would it be possible to have this new value rounded up or down to the nearest 9.

Example:
Column I=7.99
Column M=7.19

Column I=7.59
Column M=6.83 (however I would need it to be rounded to the nearest 9. The price I would need would be 6.79)

Column I=2.19
Column M=1.97 (however I would need it to be rounded to the nearest 9. The price I would need would be 1.99)

View 3 Replies View Related

Track The Levels: Club Is 0 To 19 Points And Yields An 11% Discount

Jan 11, 2009

I have a 4-level program. The levels are Club, Bronze, Silver and Gold. Each is awarded when a certain amount of points are gathered.

Club is 0 to 19 points and yields an 11% discount.
Bronze is 20 to 44 points and yields an 12% discount.
Silver is 45 to 59 points and yields an 11% discount.
Gold is 60 and better and yields an 11% discount.

I am looking for a way to total the points and have the spreadsheet automatically calculate the leve and percentage. So if my total points is 22, I would need the formula to return "Bronze" in one cell, then "11%" in the next.

View 3 Replies View Related

Simple Form To Display Cost Based On Discount?

Jul 14, 2014

How would I create a simple user form to display a price based off the category selected.

User types in List Price, then selects 1 of 4 discount categories, it then displays that price.
An added bonus would be copying that price to another sheet, but not necessary..

View 2 Replies View Related

Figuring List Price - Cost To Show Discount Percentage

Apr 25, 2006

List Price $46.98 (e2)
Net Cost $19.53 (e3)

How do I enter a calculation that will show me my discount percentage from my supplier? (e4)

I then need to be able to drag the formula to the end of the sheet. Discount percentages will be different for each product, but the List Price and Net Costs are present, so the calculation needs to take these differences into consideration so that I get the correct discount percentage for each item.

View 9 Replies View Related

Calculate Amount Of Days Paid In Advance And Apply Percent Discount

Jul 13, 2009

Part of the assesment task is to write a formula, to work out how many days in advance the customer paid, and then apply the needed discount. I have tried several basica variations to the formula, and keep getting the same Err message.
give point me in the right direction to how i can calculate amount of days paid in advance and apply a % discount?

attached is the start of the assesment question.

You should create and enter formulas to calculate the No. of Days paid in Advance, the Discount and the Course Fee Paid.

Use a VLOOKUP function in your template to determine the discount rate to be used for the calculation of the Discount. Your template should include a separate discount table containing the following information about the discount received:
• If students pay the course fee less than 7 days prior to the course commencing then they receive no discount.
• If students pay the course fee 7 to 13 days prior to the course commencing then they receive a discount of 5%.
• If students pay the course fee 14 to 20 days prior to the course commencing then they receive a discount of 8%.
• If students pay the course fee 21 days or more prior to the course commencing then they receive a discount of 10%.

View 6 Replies View Related

Writing Macro To Check Cell Population And Then Run Another Macro

May 14, 2014

Basically, what I'm dealing with is an inventory system. When a cell value reaches below a certain quantity, we have a cell light up with the word "YES" (under the "re-order" column). What I'd like to do is have a macro that checks to see if that cell is populated with "YES" and if it is, to run another macro (which I already have written) that sends out an email notifying us of the need to re-order.

How it would work: The person pulling out the inventory would fill out this form and click "Submit"

submitbutton.jpg

I would then have a "call" code tied to the "Submit" button that when clicked, would run the macro to check cell population and send out the email. The email code is already written and works flawlessly on it's own. I just cant seem to figure out how to write a macro that checks for cell value and then runs it (or not) based on that.

View 14 Replies View Related

Macro Check A Value

Nov 17, 2009

I'm at a point in the macro where I want to check a value.

Not sure how to write it.

Here's what I need.

If the value in B2

View 9 Replies View Related

Discount Prices Based On Order Quantity And Package Quantity

Nov 23, 2009

I have two idential spreadsheets with several rows of items each with different packaging quantities, price break quantities and corrisponding prices next to each break quantity. I'm trying to build a discounting sheet on an idential page by using formulas that read off the price sell in the same relative position on sheet 2. Below is one row of sheet1 and the idential row of sheet2 - underneath the cells are the rules I would like incorporate:

Sheet 1
ABCDEFG
1Pack QtyQty 1Prc 1Qty 2Prc 2Qty 3Prc 3
210010.91000.744000.6

Sheet 2
ABCDEFG
1Pack QtyQty 1Prc 1Qty 2Prc 2Qty 3Prc 3
210010.91000.744000.6...........................

View 5 Replies View Related

Macro To Check Internal Ips

May 26, 2008

we have a network of small routers and wifi aps. The Ip range has got a bit out of control so I would like to be able to audit it every once and a while.

how I could go through a set of IPs on a spreadsheet, open a telnet session or whatever, try pinging each ip individually, paste a response or no response in the adjacent column then move to the next ip in the first column (some sort of loop).

Time is not too much of an issue as I could run this overnight if need be.

As a response, the macro could just copy the last line of the ping eg

Minimum = 7ms, Maximum = 9ms, Average = 7ms
if it responds

or

Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)

if it does not respond

Example

Col1 col 2
Ip
1.2.3.4 Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)

4.5.6.7 Minimum = 7ms, Maximum = 9ms, Average = 7ms

5.6.7.8 Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)

6.7.8.9 Minimum = 3ms, Maximum = 21ms, Average = 9ms

etc

View 12 Replies View Related

Macro To Check Part# And Sum

Apr 13, 2006

I have a huge spreadsheet that has part numbers and quantity. I need to find the same part number and sum the quantity of that part number.

View 10 Replies View Related

How To Check If Macro Is Scheduled Or Not

Jul 16, 2012

I have a button that runs a macro every 5 seconds.

I have another button to stop the loop.

Problem happens if a user hits the stop button when the sequence is not running - they get an error.

Here's my code for button 1 (start) and 2 (stop):

Code:
Sub Process_Emails_and_Backup_Auto()
Application.Run "Process_All_Emails_In_The_Inbox"
runtime1 = Now + TimeValue("00:00:05")
Application.OnTime runtime1, "Process_Emails_and_Backup_Auto"
End Sub
Sub StopProcessing()
Application.OnTime runtime1, "Process_Emails_and_Backup_Auto", , False
End Sub

Is there a way for button 2 - the StopProcessing macro - to run a test like If process is scheduled then run this code - if not then don't?

View 2 Replies View Related

Macro Check Value Delete Row

Sep 21, 2006

My macro for some reason is not working. I want it to delete every row that has FALSE in Column A. I don't know what is wrong.

Sub deleteFalse()
Dim I As Long, trufalse As Long
With ActiveSheet
trufalse = . Range("a65536").End(xlUp).Row
For I = trufalse To 2 Step -1
If .Range("A" & I) = "FALSE" Then
Rows(I).Delete
End If
Next
End With
End Sub

View 2 Replies View Related

Check Cells Value Before Macro Run

Jul 29, 2007

I have completed a formulation and included in a macro but I dont know about coding to check for specific cell string values before macro will take off. I want macro to check that if specific cell text are not matched, use MsgBox to display the wrong versus correct cell string text, then vbOK to exit macro. Also, if Range(B2:G2,J2) are completely blank, use MsgBox to display "missing data", then vbOK to exit macro.

cell B =REQ
cell C =SS
cell D =Current Stock
cell E =PO
cell F =Sales Order
cell G =In-coming
cell L =unit cost

If these cell texts (U or L case will do) are in their specific cells, macro will proceed. If either one or some of these cell texts are not matched, display MsgBox of the wrong and correct cell texts. Then button OK to stop macro run. If Range(B2:G2,J2) are completely blank, use MsgBox to display "missing data", then vbOK to exit macro.

View 3 Replies View Related

Add Check Box & Assign Macro

Feb 12, 2008

I have designed a functioning userform which transfers the data (limited or complete) into the sheet. Along with the data and at the end of each row it automatically generates 4 checkboxes and links them to 4 offset cells.

This is where I hit a dead end. I am not sure which avenue is suitable or indeed possible. I want to click any checkboxes in the first COLUMN and as a result have it change the complete ROW colorindex of the background. I did achieve this with conditional formatting but it seemed to make the empty sheet bulking when saving and I cannot alter the font size which is another goal on the 3rd column of checkboxes. Am I waffling yet?

The 3rd column checkboxes I want to have the ROW font size drop to 3pt. The 2nd and 4th currently serve no purpose i.e. trigger nothing as a result.

I don’t think I can use the checkbox_click event as the boxes are generated for me so I don’t know which number they will be. The worksheet_change event and calculate event don’t seem to register when the linked cell goes to TRUE or back to FALSE. I tried using FORMS and CONTROLS checkboxes but neither has brought me success.

I was hoping the linkedcell would trigger an event and in turn select and manipulate the entire row in which the linked cell is located….

Due to my limited knowledge the code I have written/adapted to suit my needs may appear a little unorthodox? I hope that in itself is not a problem.

I have not managed to get the Controls Checkboxes to initalise blank. Currently they appear greyed out with a tick but fully usable? Of minor importance.

I can't attach the file because the blank sheet is 4.5MB?? so here is the main body of code from the userform. If you need anything else I will supply as required, however I can't get anyfiles under the attachment maximum of 48.8kb. My jpeg image was 108kb....

View 9 Replies View Related

Check Headers And Stop Next Macro If Its Different?

Aug 11, 2013

I did not want to bother you again but I have a problem that I can not solve it because my knowledge in vba etc, are limited and could not become to find with Macro Recorder.Usually I solve the problems on my own by searching on Google and experimenting with ready Macros and Macro Recorder.

I have an excel file with a macro and I want before this macro launched, to run another macro that can check if the headers have the correct name and in its correct position. The headers is in first Row.

If are not in the correct position or if it doesn't exist or if not have the correct name, then the process of the next macro be stopped and of course be informed that there is a problem.But if Is everything okay, then proceed to the next macro and be informed that Is everything okay.

I have attached a Sample file with the headers i'm using.

Sample...xlsm

[Code].....

View 5 Replies View Related

Run Macro To Check If Hyperlinks Are Valid?

Jan 22, 2014

I have a large spreadsheet that has thousands of hyperlinks that I would like to check periodically to make sure they are up to date. I have found dozens of examples of VBA code that will do this for me and seemingly very clear instructions on how to do it (for example this), but haven't yet been able to successfully run anything in my spreadsheet. It either doesn't do anything, or I get an error message of a bad file name.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved