Concatenate Not Working [SOLVED] - Excelforum
Join Date 08-10-2013 Location Ipswich, England MS-Off Ver MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home) Posts 40,461
Actived: Wednesday Aug 5, 2020
Macro to Sort Coupons by Redeemer Number [SOLVED]
I scan coupons with a desktop scanner into a giant folder and I'm trying to make this easier on myself if at all possible. I'm wondering if once I have the giant index of all the coupons if there isn't a way to come up with a macro to put the coupons into the correct column based on their four digit redeemer number. Here is an example of the coupon data: Column A Column B
Formula help - coupon # [SOLVED]
I need help with a formula. I have highlighted it in the attachment. Here is the jist.. There are 8 apartment buildings and 15 apartments in each building. Coupon books need to be made for each apartment & each month. I am having a problem with the coupon number. It works for the Building 1, apartment 1, and months 1-12, but when I go to the next apartment, instead of going to the next
Producing discount code in visual basic
Hi, I am trying to write and function in Visual Basic that takes customer type and number of items purchased as inputs, and returns the correct level discount that should be given. The discount given is based on the type of customer and the amount of items purchased. For example: Customer1 More than 50 items - 30% 25 to 49 items - 20% 15 to 24 items - 15%
Separating $1 and $2 Coupons by Bar Code
I'm having a hard time coming up with a macro that will sort this data the way I want. We have farmers market coupon barcodes that will be for $1 and $2 food coupons. The $1 coupons will all have barcodes that fall within this range: 850001-860000. The coupons will always start with HB2016. So the $1 coupons will be HB2016580001 to HB2016860000.
Macro to Sort Coupons by Redeemer Number [SOLVED] - Page 2
I took off the date and time since that appears on the left also but that shouldn't change anything should it? The only other thing that is different is the HB1234 doesn't have a -3 after it. The -3 referred to the third time I scanned coupons with that code so that part can be ignored.
Change cell color of bar codes in a certain range
I will have a spreadsheet with multiple workbooks - one for each farmer - that have barcodes listed for coupons they have received. These will be both $1 and $2 coupons mixed together. The $1 coupons will be in the range HB2016580001 to HB2016860000 (all coupons will start with HB2016 followed by a 6 digit number). The $2 coupons will be any coupons that do not fall within that range.
A coupon organizer with product name, value, exp. date, etc.
Some sort of template for organizing coupons ----- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.
Calculating Bond yields on Bonds with Multiple Coupons
Hi, I am trying to calculate the Yield on Step up bonds. For example, the bond may have a 0% coupon for 4 years then 6% coupon for years 5-9 and 9% from 10 through to maturity. Does anyone know of a function or of a way to calculate the yield on such a bond using VBA?? The yield function only allows for one coupon rate to be assigned.
Auto fill consecutive row after processing from different
Hello excel experts, I have problems with H2 from "Sell" sheet. I'm trying to get auto result in H2. IF the Coupon code in "Sell" sheet (C2:C32) have a match from any of (B2:B32) in "Buy" sheet, THEN it will calculate the value in "Sell" sheet G2, minus I2 in "Buy" sheet. The problem is, I need to get the value based on the coupon code, and not depending from the same row on "Buy" sheet.