codes

Hi, I have a list of topic codes in a cell and I need to extract just the codes. The only thing that gets me close is splitting the cell based on a delimiter but there are two issues with that 1) I then need to delete the columns which contain the unwanted text and 2) sometimes I may have 4...

So I created a rate calculator that allows the user to enter answers for questions pertaining to the rater ("r_user_interface"). These answers are linked to a table that has various calculations that gives the final result in the cell called ("v_premium") The problem is, I now want to set...

I have a spreadsheet with 8 columns of data. In the 3rd column, I have a variety of codes that start with 'B', 'D' and O'. However, those are just the ones that we KNOW OF in today's world. Management isn't sure if there could be other potential codes or not, and want me to include VBA that...

Hi, I am a first time poster in this forum. I have an issue regarding the COUNTIF formula:- I have a column containing codes and text - for example - "00000 - To be confirmed". Some rows in the column contain two or more codes and text separated by a semi-colon - for example - "95950 -...

Hello there, This might be a really dumb question, if it is, just tell me it is! As part of my job, I have to get the time and distance between two post codes and with over 200 to do, it's bit of laborious process! I used to literally copy and paste every post code into Google, I've improved...

Hi, I'd appreciate some help please in doing the following. I have a spreadsheet set up as follows: Column A = question number Column B = question text Columns C to BFW = a list of 1,528 store numbers in row 1 and their corresponding area codes in row 2 There are approx. 80 different area...

I am wiorking with a sheet that is foramted as a table. I have tried five separate codes to get the last row in column ag. None work. Can anyone suggest a solution? https://www.thespreadsheetguru.com/blog/2014/7/7/5-different-ways-to-find-the-last-row-or-last-column-using-vba

Hi, Can you see file below, and advise how I can add codes (as the clicked event) to the button within Ledger sheet? https://1drv.ms/x/s!Ai8CrEskdewXngRR6DYl8WCGYsQY It seems also the below codes do not copy the values of cells properly. Any idea...

Hello all! I am trying to get more into making UserForms and the limited color choice is starting to bother me. Is there a way to convert hex color codes to what ever this is, &H80000012&?

Hi Guyz, I am working with a Pivot. That has some 1000 project each having unique alpha numerical project codes and there budgets for the entire year. I have grouped the multiple projects under Labs. So I want to filter the project codes in the pivot which in turn effects an Chart. I tried...

Hi, I have 3 workbooks where the total rows is greater than 1048576 rows. It's probably about 1,500,000 rows (approx) These are Product codes (starting with either a number or a letter) - (including duplicates but at this moment in time, I don't want to remove the duplicates due to the data...

I have attached my file. I have tried several different codes, but to no avail. Upon entry of a quantity in worksheets Conduit, Strut, Wire & Misc., I need that row of information to be copied into the RFQ form in the respective columns. I have deleted all the codes that I have tried so I am...

I have been working within my company creating UserForms on excel for multiple different inputs and outputs. I'm getting the stage where I feel comfortable to move forward and create an actual program outside of excel. However, I am unsure of the best language for this. Currently I build...

I have several vertical ranges of zip codes with each range equaling a specific delivery cost. If I type the a zip code in one cell, I want the cell next to it to show the price of delivery. I have been successful with different formulas, but they have only worked with one range at a time. I...

Question, I have not used this and I need to set up based on 2 criteria I have a column with names in it and a second column with codes in them. I only want 10% of the total codes for each name Name 1 can have 20 codes so I need to randomize the two codes that get audited. Name 2 50 codes so...

Hello, everyone, thanks to your help, so far I have been dealing with a lot of troublesome tasks for me. I'm here again for your help. I have a large database table. With other macros, I get almost to the end of this table. I have a dilemma with which I can not fight. The table has a range of...

I have a sheet which hold job information and hours for several different employees for each month. Each job has its own code so for example there may be 10 separate entries that have job code A10. Is it possible to create a list on a separate page that automatically copies across the job codes...

Good afternoon - I have two columns of comma-separated two character codes (for example): A B AA,DB,LN,WE,UR,TD,QW AA,LN,WE,VF,WE,UR,OW,ZL The the codes will always comprise two characters, but will not...

How can I clear all the labels with a code on userform UserForm_Initialize() instead of wring below codes one by one? Me.Label1.Caption = ("") Thanks

I hope someone can help me as I'm getting a real headache from this one! I have a report from a supplier that contains branch codes - I want to apply a few rules to highlight (grey-out) branches that aren't relevant; all the branches we are interested in start with Q94 followed by another 4 or...