script

Hi everyone! I've been trying to create a script for this one for several days now but I keep failing. Here is my data. Tab 1 is the raw data Tab 2 is how it should look. The idea is to transpose values but create a new row once the word 'Skip' shows up. Any idea how to do this? I really...

Hello all, I have a script I made in Excel Web to automate a task when adding data to the spreadsheet. It works fine and has no issues but it's a little bit of a delay from when the user clicks the button and the data populates on the sheet. Any ideas on how can I help speed up the script...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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