codes

  1. D

    Extract multiple strings from 1 cell

    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...
  2. B

    range.value in loop speed issue

    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...
  3. Z

    Identify cells with unknown variable

    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...
  4. T

    COUNTIF Help

    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 -...
  5. B

    Goolge Maps Data

    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...
  6. M

    Loop through a list of codes in columns and save ones meeting the criteria as their own workbook

    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...
  7. W

    Last Row issue

    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
  8. H

    Issue to button and unable to copy

    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...
  9. I

    Color codes in UserForms

    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&?
  10. H

    Macro to Filter in PIVOT Table.

    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...
  11. M

    Sorting 3 columns (over 1million rows in total) A - Z

    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...
  12. W

    VBA to copy rows to a master sheet when a quantity is entered in one of the material worksheets

    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...
  13. P

    Next Language for a Userform?

    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...
  14. B

    Finding the correct formula for multiple ranges of zip codes to determine shipping cost.

    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...
  15. T

    Using RAND function

    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...
  16. K0st4din

    Macros Compare the last two months and remove the coloring in the first

    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...
  17. D

    Combine details on one sheet

    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...
  18. NewOrderFac33

    Extracting differences between two comma-separated strings

    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...
  19. A

    Userform clear labels function

    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
  20. M

    Conditional Formatting - highlight row based on cell not containing text

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top