1. R

    my office script to replace blanks with 0 is not working

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

    When cell with formula changes -> edit adjacent cell

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

    Excel scrip to replace a VBA to add a part of sheet name in rows.

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

    Cannot Record Actions when trying transform a regular table with PowerQuery

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

    Googlesheet - Data entry form - upload document to line of data and rename

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

    Copy data from one table to multiple table.

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

    Permission for refreshAllLinksToLinkedWorkbooks

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

    Macro Buttons to Copy Non-Blank Row(s) In & Out of Excel

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

    Extract Text Matching a Certain Sequence within a Cell

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

    Trying to make a form that will auto update values on different sheet

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

    VBA Script - Copy all the data from one workbook to another workbook

    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()...
  12. F

    VBA Script to run multiple scripts at the same time

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

    Copy entire row from "Sheet1" to "Sheet2" which is common between two columns

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

    Move all the "Duplicate Numbers" from one sheet to another sheet

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

    Move the data from one sheet to another

    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" &...
  16. P

    Transpose rows after one specific word

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

    Office Scripts Optimization

    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...
  18. 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...
  19. 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...
  20. 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...

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