Excelforum.com Coupon

Data Validation Drop Down List Disappeared

I have a problem, I have a massive excel sheet with Drop down lists in many places, but when I opened it today the cells with the data validation drop down lists are not working. Meaning when you click on them (the cell) the drop down doesn't show up. When you go to Data / Validation on the cell you see that it is referencing the list, but the drop down still doesn't work.

Actived: Tuesday Jun 30, 2020

URL: https://www.excelforum.com/excel-general/609038-data-validation-drop-down-list-disappeared.html

Macro to Sort Coupons by Redeemer Number [SOLVED] - Page 2

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

Category:  coupon Get Code

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

Category:  coupon Get Code

Macro to Sort Coupons by Redeemer Number [SOLVED] - Page 3

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

Category:  coupon Get Code

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%

Category:  coupon Get Code

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

Category:  Books Get Code

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.

Category:  coupon Get Code

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.

Category:  Food Get Code

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.

Category:  coupon Get Code

changing numbers into a barcode using excel [SOLVED]

code is Off; HTML code is Off; Trackbacks are Off; Pingbacks are Off; Refbacks are On; Forum Rules. Contact Us; ExcelForum.com; Archive; Top; All times are GMT -4. The time now is 01:25 PM. Search Engine Friendly URLs by vBSEO 3.6.0 RC 1

Category:  coupon Get Code

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.

Category:  Books Get Code

Related topics