About 1,777,625 results (5,293 milliseconds)
Return sheetnames from multiple sheets if meets criteria - Google ...
https://support.google.com/docs/thread/107538347/return-sheetnames-from-multiple-sheets-if-meets-criteria?hl=en Apr 25, 2021 ... I am trying to search a column in each tab that match a cell and return the sheet name. here's an analogy,. Product id in column A. Searching ...
Auto insert sheetname into chart title?
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/ge-mhPirod4 May 8, 2010 ... Hi. I'm using Excel 2003. I have several charts on a worksheet. At the end of each month I copy the sheet to become the first worksheet
Script that changes sheet name upon edit on THAT sheet, can it ...
https://support.google.com/docs/thread/91484916/script-that-changes-sheet-name-upon-edit-on-that-sheet-can-it-change-upon-a-change-on-any-sheet?hl=en Jan 1, 2021 ... Hi Gavin,. You may want to take a look at the many mail merge add-ons. AutoCrat is a pretty decent one. For other options ...
Excel -Mass add sheets pulling data from list in another tab and ...
https://support.google.com/docs/thread/127631595/excel-mass-add-sheets-pulling-data-from-list-in-another-tab-and-name-tabs-accordingly?hl=en Sep 24, 2021 ... I tried running a VBA code to name the tabs but because I made cell J1 a formula to pull the date from the template fillers tab, the VBA throws ...
How to automatically change a sheet name to the text entered into ...
https://support.google.com/docs/thread/109495829/how-to-automatically-change-a-sheet-name-to-the-text-entered-into-merged-cells-on-a-different-sheet?hl=en May 11, 2021 ... Cells on Student 1's sheet auto pull the data entered into cells B2-B15 on the 'Student Data' sheet. Each student's sheet is set to pull their ...
ExcelDNA cannot recognise macro name
https://groups.google.com/g/exceldna/c/AXxAya0dz08 am getting #NAME? in cells that reference the functions. I have removed all references to the add-in, but still nothign is called via ExcelDNA. Does anyone know ...
Returning an unknown array size - and returning a new worksheet
https://groups.google.com/g/exceldna/c/zIcRRTnHj1M Oct 28, 2010 ... for Excel. For the macro case, where you want to create some output (maybe based ... Could you advise how I resolve the new sheet name that has ...
I need a script to clear certain cells in sheets when a button is ...
https://support.google.com/docs/thread/5809954/i-need-a-script-to-clear-certain-cells-in-sheets-when-a-button-is-pressed?hl=en May 9, 2019 ... This is the script that I found that I was basing my script on. function clearRange() { //replace 'Sheet1' with your actual sheet name var sheet ...
Google sheet macro - complete status moves row to another tab and ...
https://support.google.com/docs/thread/28381517/google-sheet-macro-complete-status-moves-row-to-another-tab-and-clears-certain-cells-in-current?hl=en Feb 11, 2020 ... And cannot figure out how you reference cell ranges if the row depends on a condition. In excel for example, you would set the found row of 'i', ...
how to lock or protect cells after data entry or input - Google Docs ...
https://support.google.com/docs/thread/66826933/how-to-lock-or-protect-cells-after-data-entry-or-input?hl=en Aug 24, 2020 ... It works only in those cases when the data was entered after the script was activated. Also, when I'm trying to enter the name of the sheet that ...
Set up conditional formatting that is also case sensitive - Google ...
https://support.google.com/docs/thread/225325361/set-up-conditional-formatting-that-is-also-case-sensitive?hl=en Jul 13, 2023 ... I have 3 conditional formatting rules to warn me if I entered a name in Data that doesn't match the names in Rate. One to fill cell as white if ...
I want to create a button in google sheets that changes values in ...
https://support.google.com/docs/thread/191191324/i-want-to-create-a-button-in-google-sheets-that-changes-values-in-other-cells-based-on-criteria?hl=en Dec 3, 2022 ... ... sheet based on customer name. Each transaction is entered in a ... You can't create buttons AFAIK in sheet cells unfortunately. You can ...
How to maintain links between cells in function when sorting ...
https://support.google.com/docs/thread/20622585/how-to-maintain-links-between-cells-in-function-when-sorting?hl=en Nov 20, 2019 ... ... sheet, but I used the same set up and same formula. ... I've edited my example document with a new sheet and some new names on the list. 2 of the ...
Two-way syncing of data between sheets so changes can be made ...
https://support.google.com/docs/thread/3961222/two-way-syncing-of-data-between-sheets-so-changes-can-be-made-on-either?hl=en Apr 10, 2019 ... One more question, as I set up the ultimate Sheet for my team. You nailed a brilliant formula to copy data to a filtered sheet: ...
xlfEvaluate and alternatives
https://groups.google.com/g/exceldna/c/MibH9SHy7ls Jul 15, 2014 ... ... Excel-dna, but I have run into a wall. ... The function basically gets a value from another workbook (using a specified workbook name, sheet name, ...
Schedule Maker Help - Google Docs Editors Community
https://support.google.com/docs/thread/119043664/schedule-maker-help?hl=en Jul 28, 2021 ... I am still new to excel/sheets programming. I do not want to do ... See sheet LB-Schedule, cell A5. Here's the formula: =if($B$2="Call ...
Trying to convert my VBA vlookup to Appscript - Google Docs Editors ...
https://support.google.com/docs/thread/219167804?hl=en&msgid=219194000 Jun 3, 2023 ... const sheetName = "Management_Updates"; // Name of the target sheet ... const cell = sheet.getRange(column + row);. cell.setValue(dates[j]);.
Custom Functions in Google Sheets | Apps Script | Google for ...
https://developers.google.com/apps-script/guides/sheets/functions Create or open a spreadsheet in Google Sheets. At the top, click Add-ons ... As you type a function name in a cell, you will see a list of built-in and ...
Using a drop down list to change values in the cell next to it - Google ...
https://support.google.com/docs/thread/221341359/using-a-drop-down-list-to-change-values-in-the-cell-next-to-it?hl=en Jun 17, 2023 ... Thank you for any help! Details. Sheets,Microsoft Windows,Personal use ... The first argument to Lambda is a name that I assign to stand-in for ...
onEdit() - Trigger on specific cell change - Google Docs Editors ...
https://support.google.com/docs/thread/98154440/onedit-trigger-on-specific-cell-change?hl=en Feb 14, 2021 ... I have another sheet that shows the data of a specific client when that clients name is chosen from a drop-down menu (Profile). I am trying to ...