codes

lets say i have two column in sheet 1 A is Names B is code of them in sheet 2 i have just names how can do below 1- check the names in sheet 1 with names in sheet 2 2- putting the codes of names in sheet 2 thanks

Hello! I have a table with codes E4:P250, example of codes mjk502, mjb333 etc. I would like, if possible, that if I select any cell, for example F65, that has the code mjk502, it displays what the code means in C2. All codes are in a different sheet in the same workbook.

Does anyone know if there is either a Microsoft add on or, a reliable add on to have Excel create QR codes? Thanks.

Hello! I would like to know about personalized codes or whatever it is called hehe... for example, If I introduce "600" in the cell, automatically there will be a text saying "purchase". What should I do to make like a legend of numbers/personalized codes which correspond to a specific text...

Hi MrExcel, I'm working with a large data dump (>3000 rows) that contains multiple columns but only two values that I'm primarily interested in: messages and message codes. Every message has a code and every code has a message, and what is supposed to be true is that every code has exactly one...

Hi I have a master list of 3 digit codes in J2:J30 with data values in column H. I would like a CF formula in column H to show which cell values are not in J2:J30 As an example one of the codes is HVE As ever any help is appreciated.

Hello! I am trying to find matches between multiple columns of text and having a terrible time getting the formula correct. I had 2 individuals rate items using 2 letter codes. They could give each item between 1 and 4 different two-letter codes (with 9 unique two-letter code options...

I receive the following data: Book1ABCDEFGH1CodeConfigFlow rateFlor rate/pumpHeadHead unitQtySelling price2code 1D/A21.521.57bar124681.000003code 20125061.540004code 3D/A10106.5bar115857.000005code 20113583.100006code 401685.00000Sheet1 However when I try to list the codes out on a seperate...

I've tried this several ways with different codes but cant seem to get it done by editing the codes I've found so now I'm asking someone else to write the code I can simply copy and paste. What I'm wanting to do is email multiple worksheets as attachments to multiple email recipients with as few...

Hi everyone, I just can't get my head around how to extract a product length from the middle of a string. Our product codes have a variable number of characters but the length always follows the "/" character. Not a problem, except that some codes have a length with up to 3 decimal places and...

Hello hope you can help I have a column O with 7 different codes, each one relates to a name. I just want to a formula to look at the code in O then return the name. B2:B8 are the list of codes C2:C8 are the list of names I want a formula in A11 which looks at the code in O11 then returns...

Hello, This is my first time using this forum so please be gentle. Your time and help would be greatly appreciated. I've built a list of all zip codes in the US with their corresponding organization code, of which there are ~100. A total of ~42k rows. I now need to group the data in a...

Hi, I have a spreadsheet with thousands of product codes, and corresponding data of stock on hand and weekly orders. I would like to match the product codes with each other to automatically align, in each row, the data of stock on hand and orders. For example column C has the product codes for...

I need to test a postal code in one sheet to a range of codes in another sheet and return the data in a specified cell. EG: Client's postal code is 0001, test against the Postal Code ranges in col A and return the relevant Province in col B. <colgroup><col...

I need a formula or macro that can extract a code in the format “03 30 00” from various data in text format in multiple variations, such as; “033000 CAST-IN-PLACE CONCRETE” “Section 03 30 00 CAST-IN-PLACE CONCRETE” “03 30 00 CAST-IN-PLACE CONCRETE” “ 03 3000 CAST-IN-PLACE CONCRETE” with a...

hello friends Newly I am studying excel VBA. when i am coding one school program Run time 53 (file not found) error occurred. Me.Image1.Picture = LoadPicture(ThisWorkbook.Path & "" & TextBox1.Value & ".jpg") please tell me what is wrong in this? and explain me about these codes. Thanks Apolin

Hi All I am hoping that someone out there will be able to help me. I am looking tochange a nested formula to a macro due to the amount of conditions that need to be met. I have an export out of a system that is rather "ugly". This schedulehas stuff in like holiday, Bank Holidays, Sickness and...

Hello guys, I have this project and its VBE codes was from excel 2007. So I am trying to copy the codes to Visual basic and also create the same as my project but this time in excel version 2016 just to make it enhanced. Is it possible that it will work successfully? Really appreciated your...

Hi, Can you please advise the way to merge the following codes. Then i will have the 1 button the press to run both codes. Many Thanks for all your help. Sub LEADERBOARD() '' leaderboard Macro' Range("C1:F17").Copy Range("I1") Worksheets("HONDA SHEET").Range("C1:D17").Copy...

Hi Guys, Suppose I have a list on text that I want to replace a specific part of it with something. Column A 11346 XZ Alpha 91970 XZ Alpha 113974 YP Alpha 1135 YP Alpha 99786 XY Alpha 99786 XY from XZ to ZZ from YP to MS from XY to JA In my current code, I recorded a find/replace code...