script

I'm trying to make an automate script for my worksheet and having problems with the autofill function. I have 2 columns of data A and B...i have a formula (=TEXTJOIN(", ",,A2:B2) at the top of column C (cell C2) that i would like to have fill down to the last row of data from column B. The...

Hi all, I'm wanting to make a calculator to help me keep track of scores/damage during gameplay, and help me make sure I don't miscalculate damage to the players or monsters. In an ideal scenario, I would have a checkbox (B1) that I can check for any weather condition. I also have the...

Where I work, I take large remnants of raw material and see if I can cut them down to smaller pieces so we have less waste. I've created a few spreadsheets that allow me to do this a bit more efficiently. Once I've decided which piece to cut, the meat of the operation lies in being able to get...

Hi, Hoping someone can help. I have a large spreadsheet with a lot of data. I have used concatenate to identify which rows are duplicates. I am looking for a script that will go down column BE checking for duplicates, once a duplicate is found column H needs to be checked and the lowest value...

Hi Everyone, I have an online appointment scheduler, using "https://www.squarespace.com/acuityscheduling". So far I have been manually copying all of the client information manually. Below is the information I gather manually from the website and put in my excel sheet. Is there a way I can...

function main(workbook: ExcelScript.Workbook) { let table1 = workbook.getTable("Table1"); // Replace all "" with "0" on table table1 table1.getRange().replaceAll("", "0", {completeMatch: true, matchCase: true}); let selectedSheet = workbook.getActiveWorksheet(); // Set format for range...

Hi all, I want to know if its possible the below scenario: I have a table, with some formulas here and there, but in column O, I have a formula with some conditions and dependent on other 3 columns in same table. What I want to know, is, if I can have some kind of script that every time...

Hi there, Add a perfectly working vba but now want to move to the cloud and automate thing so need to have an excel script instead but don't know how to achieve this. To be honest I have no clue about excel script. What I want is to add a part of the sheet name in a new column and at the...

Hi, I have this report that i have to manipulate each week and i was trying to record the actions so i don't have to do the same laborious process every week. One part of the manipulation involves in transforming the table with power query so i can remove the format type of the whole column...

Hi there, I was wondering (and hoping) if it is possible to upload a document to a data entry form I have created. So the document is linked to that particular data or entry. Whilst uploading, I want it rename the document the ID number of that entry. So if I have an expenses form. Each row...

Hello There. so in short: populate data from one master table (with 'variable structure') to multiple tables. in long: I have one table: data_src. with column/headers like this: tbl1$col1 | tbl1$col2 | tbl1$col3 | tbl2$col1 | tbl3$col1 | tbl3$col4 | tbl5$col2 | tbl5$col7 | ... |...

Hello, I try to run a rather simple script to refresh Data I get from another worksheet. function main(workbook: ExcelScript.Workbook) { // Refresh all workbooklinks workbook.refreshAllLinksToLinkedWorkbooks(); } I get the Error back that User did give permission to refresh from external...

So, it's not a huge thing but just trying to create a button that just grabs non-blank rows of data and throws it into your clipboard for pasting into another spreadsheet or somewhere else. You know pdfs and such don't always copy very well so the data doesn't go nicely into Excel. I'll just use...

I work for a company and we have type up orders for customers. The way the customers give the info can vary so I tend to use Excel for bigger lists. Sometimes, it's not nice and puts it all into a single cell. I don't know exactly where in the cell the item number or if the number is by itself...

I'm trying to out do myself, I have a basic form built out with drop downs and blanks. So far i have formulas in place that will find an "Available" ip by using xlookup, and i also have an xlook up to find the row, column and sheet name, i have a cell formulated to show a complete location (ex...

Good Afternoon everyone, I need to copy all the data from one workbook (Test1.xlsx) to another workbook (Test2.xlsm). There are so many sheets in Test1.xlsx file but I need to copy only "Sheet1". So far, I tried the below code but it is not working :( Sub move_data()...

Good Afternoon everyone, I hope you all are doing well. As you see in the attached pic, I have almost 12 VBA Macro scripts in multiple sheet but same workbook. Normally, I run all the scripts individually. However, Is there any VBA Macro code which will help me to run all the 12 scripts...

Hi everyone, Hope you are doing well. I need your help - I need a VBA script that will copy the entire row from "Sheet1" to "Sheet2" which is common between "ColumnA" and "ColumnB" In the attached pic, I mark in "Yellow" marks that needs to be copy from "Sheet1" to "Sheet2". NB. My actual...

Hi everyone, I hope you are doing well. Please help me to write a VBA script which will move all the "Duplicates" from "Sheet1" to "Sheet2". NB: Just wanted to inform that the attached pic has very small data range but in my actual data sheet has more than 40,000 rows and there are so many...

Hi everyone, I hope you are doing well and have a wonderful weekend. I need a VBA Macro Script that automatically moves the data from "sheet 1" into the new tab based on the "Profession Column". For example, in "Pic 1" there are total 4 professions - "Doctor", "Engineer", "Teacher" &...