1. R

    Extra subroutine to crop values of one column to 10 characters

    Hi, I have this macro (see below - code scripting credited to member rlv01) and I would like to add a subroutine which crops all the values of column O to 10 characters only. So I want to only keep the first 10 characters of the data in every cell of the single column O. For example: if the...
  2. R

    Macro to refresh workbook, clear sheet, refer to path and import columns

    Hi, In my worksheet, I would like to add a macro which does the following at once: 1) refresh the active workbook, 2) clear the contents of a specific worksheet, 3) import columns data from a closed workbook, 4) refer to the path of the closed workbook based on cell data in the open workbook...
  3. G

    VBA to Only Highlight cells with a Value

    Hello, I'm looking to edit this script such that if there is no value under the first row and then don't copy it. So only copy the cells with values inside Range("D11").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select...
  4. N

    Insert Check Box in Google sheets based on value of another cell

    What formula would I use in Google Sheets to insert a check box into cell A2 if the value of cell B2 is "Signing"? I only need the check box if B2 is signing I can get column A to have all check boxes or add them in individually but there has to be automated way to do this. Maybe with a...
  5. Jyggalag

    Can somebody help me test my VBA code and fix it if it does not work?

    Hi all, I have this VBA code to write an email body text: eBody = "Dear person," & "<BR><BR>" eBody = eBody & " 1Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text (Text text...
  6. Y

    Excel Online - Office script - renaming sheet based on cell value

    Hi everyone, I need to create a script to change the name of a sheet based on A1 on that same sheet. I need this script to run automatically. Is this doable? Does anyone know how? I tried and failed. Thank you Moderator Edit: This is for xl Online, so VBA won't work
  7. I

    Why does this JSON Microsoft Script VBA code work in Excel 2016 but takes forever in 2019?

    I have this JSON Microsoft Scripting VBA code that pulls data from a work website into Excel. Can pull about 55,000 rows of data. About 5 columns of data. On 2016 the code worked fine but on 2019, which I need the code on, it takes forever to run or crashes Excel. I then have to quit Excel. I...
  8. R

    Google Sheets - Add Blank row after every 100 rows of data

    Hello, Just wondering if any knows if / how this can be done in Google Sheets. 10 colums of data with 1,000 rows on a Google Sheets Document What forumula can I use to automatically insert one or more blank rows after every 100 data filled rows to break up the large block of data? Is there a...
  9. E

    Retrieving Product Pictures and Tabular Data from the Website

    Hello to everyone, I have a few different websites, I want to extract data from them and then create data for my business and analyze. Link Macro.xlsx I am waiting for help from you dear wise people. My demands. 1 - site (Pega Air Springs - PEGA Otomotiv A.S.) Example link: Pega Air Springs...
  10. J

    Move numbers end of the cell in new cel

    Hi, I have a lot of this cells: A1Middelweg 552Torenstraat 39-413Nieuwe Steeg 74Schoutlaan 95Leerdamseweg 22a The numbers in the cell are house numbers. Now I want pick that housenumber and move that to another cell But the house numbers can look as 11-13 or 12b. Exactly i look for a...
  11. J

    Move or Exctract data value after specific word

    Hi, I have a excel file with a lot of this cells: A1renewal store by G. de Vries2build house by R.J.D. van Kampen3draw made trough G. Jonkers4renewal barn by S.D.S. Groot Is there any way to move the data starting with the words by and made trough to another cell. Like: AB1renewal storeby...
  12. J

    Fill serie with exception if same number

    Hi Excel experts, Can someone help me with a difficult Excel question? I think it's also difficult to explain the issue, hopefully you understand me. I have a lot of rows with numbers, but I must number this in a serie in another cell. But I want if the number is the same, it must be the same...
  13. J

    Pick/Extract year from middle of value

    Hi Excel expert, I have a excel document with more than 20.000 rows with the following data: A1BL19340032BL19340043BL19340054BL19340065PP20100846PP20100857PP20100868RB20030019RB200300210RB2003003 It's start with two letters followed by a year followed by a few numbers, like this...
  14. J

    Sort alphanumeric data with - in number

    Hi Guys, Hopefully you can help me with a sort issue. I have more than 4000 rows with numbers year-number (1990-1). They randomly in the excel document. I want to sort on this number. But when I sort, al numbers 1 come be first. Example: E111990-1121990-15131991-1141991-5151990-2161991-14...
  15. J

    If value started with specific number, insert number before value

    Hi Guys, I'm looking for a script. A script when a cell starts with a specific number than insert two numbers before that number. I have the following excel cells: A12009/2721988/14396/9742007/27051986/261998/5371988/83892/7091989/1231093/24 Now i want that IF the cell starts with a 9, thain...
  16. J

    Can I find and move some number strings in Excel

    Hi, Is it possible to find and move some number strings in a cell vallue? Example: moving barn rebuild house 1990/212 moving house 1992/23 * changing rebuild 54 barn 92/12 And look and move some number strings. The following number strings where x = a different number xxxx/xx...
  17. I

    Quick solution for 400 increment macro's with VBA?

    Hello community, Excel/macro noob here. I have a question. currently i am working on a 'barman list' in excel where the barman can click the + and the - to increment or decrement a value. For examle, "john" orders a drink, the barman clicks the + button behind his name and a 1 will appear. I...
  18. W

    VBA to change multiple shapes color in Excel

    I'm beginner in Excel so i'm looking for a way by which if I type yes in a cell it should change color of multiple shapes with same color and if I type NO it should remove the color from those shapes and same goes for other zone entries as show below image. Example: If i type On in G22&25 it...
  19. G

    Delete rows if (certain value) exists in data set.

    Hello, I've been trying to delete rows in my data set that contain the following keyword "lename" This is the following script I found and the following error Script : Sub Delete_All_Rows_IF_Cell_Contains_Certain_String_Text() Dim lRow As Long Dim iCntr As Long lRow = 150000...
  20. P

    Scoring participants answers using an Excell script

    Hello, I have registered in this forum to ask a specific question about something that I was told it's possible and you can help me to find out how to do it. I am doing an experiement in which I ask participants to listen to 40 short phrases in German (e.g., Die Haeuser sind sehr schoen) and...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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