codes

Having to trouble getting this code to work. Used all last year and now always running debug and I'm struggling to figure out why? Private Sub CommandButton1_Click()Dim ws As Worksheet Dim shtname As String Dim codes As String If Workbook.TextBox1.Text <> vbNullString Then MsgBox "Need...

Dear All, I'm using a list with 100 different codes. I need a different extensive formula for each code. Every month several new codes will be added to the list. Is it possible to make a formula list based on certain cell values? For example: Code column with these numbers: 5 7 13 2 If cell...

Hello, Anytime a save a file that has bar codes in MS Word. The file converts bar codes in to human readable text. Any idea why is it doing this and how to stop this behavior? Regards, Rajesh

I have two combo boxes. List of Combobox2 is dependant on list of combobox1. Combobox1 has list of companies. Combobox2 has codes of products the company(selected in combobox1) provides In label1 I want to have name of the product for which the code is selected in combobox2. For the record...

Good Day Mam/Sir. In this project , i have to register for an appointment. Sample picture below. as of now, i am managing to save the inputs from userform to worksheet. to finish my project, i just want to add a code that limit the applicant to register for a specific time in a specific...

Column P (16) contains 'codes' that represent a description of something. Example: "CSR2B" = wrong labels Also there can be more than 1 code in each cell in column P (and almost always will be more than 1 actually.) (which is whY I am using the 'Like' operator and the '& vbCrLf' ) For the...

On sheet 1, column A1:A5, I have a list of names: Joe, Smith, Mary, Joan, Bill. Column B1:B5 of the same sheet contains reference codes for the names in A1:A5: JSM, SUT, MRE, KIT, and KTM. On sheet 2, column B1:B5, I have a list of codes that includes some, but not necessarily all, the same...

Hi, So I have a column of data (10,000+ rows) which contain various codes assignedto the individual (Around 60 different codes). These codes situnder 5 different headings, but these headings are not contained within thedata set. My aim is to insert5 new columns with the row header for each...

Hi there, I was just wondering if there is some way of using the sumifs function to minus or subtract a range of data from a large data set? I have a large data set that picks up contract codes in column A and the cost against these in column B. I am looking to exclude certain contract codes...

In Tab 1 i have a list of individual 5-digit codes. Each code is a specific type of hospital procedure. In tab 2 I have a list of hospital procedures names and the ranges of 5-digit codes that fall into that procedure. The ranges are NOT continuous and have gaps in them. For example, one...

Hi, I have fiterd data in one spreadsheet and then I have another spreadsheet which has more data but I want only to see the data from the filtered sheet. For ex. I need the data from column b on spreadsheet 1, which are dfferent codes, to see on spreadsheet 2, which has more codes than...

Hi there, I have 3 tables with codes and prices (codes are not formatted like the below). I want to enter a value in J2 and if that value is in any of the tables I want the PRICE for that table to display in K2. I can do it for two tables where it displays one value or the other using...

This is going to be long and tedious, or I am just simple minded. I would like to have a database of information (Control) on one sheet, and import data on another sheet, and have a formula compare that to the control and if it finds a similarity I need it to tell me how much money is invovled...

I am trying to work on a set of data, where I need to count how many times certain combinations of codes are used. Originally I had just one set of codes to count, but now I have multiple code combinations to count. Is it possible to combine the two lines of code as below, to work together in...

I have two columns Column A and Column B Column A has all existing product codes Column B has all existing and new product categories Old Product codes consists of two parts two letters and a 6-digit number the letters always remain the same ER the numbers were picked at random. So existing...

Hello,</SPAN></SPAN> Column "B" contains the codes, in the column "C" codes are grouped by in the friction of (1 to 2187) (2188 to 4374) and so on, numbers.</SPAN></SPAN> Example B4=100 are in the group from 1 to 2187, and the B5=3250 is in the group from 2188 to 4374 Note: to get these...

I'm trying to have a table where if you enter a letter in one cell it will give a number in a different cell. So if A1=A then B2=1, if A1=B then B2=2. I've written a formula in colum B something like this: =If(A1="A",1,(if(A1="b",2,if(A1="c" etc...... I have about 20-40 different codes to go...

Hi, Detail of data: Column A has a list of product codes (of which there can be duplicates upto 5000 duplicates but in some cases, there may only be 1) Column B has a list of associated product codes (there may also be duplicates as more than one of the products in Column A can be associated...

I have a dynamic table that will vary depending on a result. I need to pull that into an email as a table to email to the team. All the codes I find want me to recreate what is already a table in the workbook. Can I just use the table created? If so, how? DThib

I need a code to stop the other codes from running if the sum of cells O16:O26 do not equal cell O10. Also need the msgbox warning. This is what I've found so far. It's not working for me. Can anyone help? :) Private Sub Worksheet_Change(ByVal Target As Range) If...