About 1,450,856 results (3,652 milliseconds)
How to rename a TAB based on a cell value? - Google Docs Editors ...
https://support.google.com/docs/thread/5236560/how-to-rename-a-tab-based-on-a-cell-value?hl=en May 1, 2019 ... Only option is to create a menu option and force a tab name change that way or a time based trigger. Perhaps you can share a sheet, so we can ...
how can I make a cell content equal the tab name 'sheet1' ?
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/KEkGzoweQmE Apr 5, 2008 ... Copy/paste into that sheet module. Adjust "A1" to suit then Alt + q to go back to the Excel window to test by entering a value in A1. Gord ...
Reference cell data from another Google spreadsheet (not a ...
https://support.google.com/docs/thread/8274394/reference-cell-data-from-another-google-spreadsheet-not-a-different-tabbed-sheet?hl=en Jun 18, 2019 ... A1 with the correct tab name and cell but in both cases keep them in ... There might be a way to get a specific value if you provide a range ...
Need help for budgeting sheet: Summing up cells based on drop ...
https://support.google.com/docs/thread/26208436/need-help-for-budgeting-sheet-summing-up-cells-based-on-drop-down-menu-selection?hl=en Jan 20, 2020 ... 'Sheet Name 1'!C$8:C$15. For example, see your demo sheet, a new tab called "otherSheet". I get the data from the old LanceLooks tab. =Sumif ...
SHEETS: How to reference the Text/Value from one cell within a ...
https://support.google.com/docs/thread/137041108/sheets-how-to-reference-the-text-value-from-one-cell-within-a-formula-of-another-cell?hl=en Nov 24, 2021 ... ... name of the corresponding sheet (also Billy), and not have to update the name value within all 21 formulas that reference it. THE QUESTION ...
Average same cell across a range of worksheets - Google Docs ...
https://support.google.com/docs/thread/110834752/average-same-cell-across-a-range-of-worksheets?hl=en May 22, 2021 ... ... Excel does. But since you have fixed time periods, all of your tab names (for both current and future tabs) are known. So it would be ...
Referencing data from another sheet using a variable sheet name ...
https://support.google.com/docs/thread/4078098/referencing-data-from-another-sheet-using-a-variable-sheet-name?hl=en Apr 12, 2019 ... Using this formula to reference data from another sheet (sheet names are years)... =2018!M47. Is it possible to reference a cell address instead of hard coding ...
Display file name in a cell - Google Docs Editors Community
https://support.google.com/docs/thread/151853009/display-file-name-in-a-cell?hl=en Feb 22, 2022 ... I create a sheet daily, from a master sheet ... As distinct from your use of the term "sheet name" (by which you mean the "tab name")?
Looking for a script to create new tabs based on cell values, then ...
https://support.google.com/docs/thread/102763612/looking-for-a-script-to-create-new-tabs-based-on-cell-values-then-query-formula-in-the-new-tabs?hl=en Mar 18, 2021 ... I'm trying to do is create a script that automatically creates tabs for each unique value in the first column of a sheet.
If cell contains a specific dropdown selection, select data range from ...
https://support.google.com/docs/thread/25020428/if-cell-contains-a-specific-dropdown-selection-select-data-range-from-another-sheet?hl=en Jan 8, 2020 ... I am trying to pull specific units from named ranges on another sheet. I have tried to use the Data Validation with a custom formula =IF(C2="Food and Drink", ...
IF one cell is equal to a chosen value, insert the value of another cell ...
https://support.google.com/docs/thread/261334944/if-one-cell-is-equal-to-a-chosen-value-insert-the-value-of-another-cell-into-the-chosen-cell?hl=en Feb 29, 2024 ... I've added three tabs, and a form, to your sheet to demo this. You could have a desktop shortcut to the form to make it easy for staff to get to ...
Google Sheets Query Select Where equals / does not equal ...
https://support.google.com/docs/thread/6638285/google-sheets-query-select-where-equals-does-not-equal?hl=en May 22, 2019 ... I have a Google sheets spreadsheet with multiple tabs with learning targets, and one which has the targets someone is currently working on.
Using Indirect to put a sheet name and cell reference together not ...
https://support.google.com/docs/thread/149906414/using-indirect-to-put-a-sheet-name-and-cell-reference-together-not-working-when-sheet-name-updated?hl=en Feb 8, 2022 ... ... tab reference, as those too are also just creating a string. In this case, concatenating A5 with !B3 creates the reference "1!B3" (where A5 ...
How to pull total data and sum it up on another sheet - Google Docs ...
https://support.google.com/docs/thread/53621633/how-to-pull-total-data-and-sum-it-up-on-another-sheet?hl=en Jun 15, 2020 ... ... get his total to equal 24 and then copy to other cells. I do have a ... names on the Players tab which are from a different website. I ...
Get sum from the range in a different workbook - Google Docs ...
https://support.google.com/docs/thread/105917586/get-sum-from-the-range-in-a-different-workbook?hl=en Apr 12, 2021 ... I need to get in the certain cell next to the name in another workbook of case amount which is equal to the sum if date is the one in the header of the second ...
If cell value matches list of values, add value of a second cell ...
https://support.google.com/docs/thread/116926865/if-cell-value-matches-list-of-values-add-value-of-a-second-cell-unorthodox-layout?hl=en Jul 13, 2021 ... I'm creating a course-planning worksheet that my students and I ... name with a list of courses on the fourth sheet. ('ClassLists') The ...
Pull data results from drop down action - Google Docs Editors ...
https://support.google.com/docs/thread/2632603/pull-data-results-from-drop-down-action?hl=en Mar 18, 2019 ... ...which will FILTER columns A:H of the "AddressBook" tab where column A & B equals B2. ... It is basically split the Cell with name and search ...
Help with making one column with SAME value have a different ...
https://support.google.com/docs/thread/101987902/help-with-making-one-column-with-same-value-have-a-different-outcome-based-on-another-column-s-value?hl=en Mar 12, 2021 ... This sheet seems to contain your original requirement. It has formulas in cell H1 and L1 in line with the formulas in the "Example" tab.
Google Sheet 'copy' with a condition - Google Docs Editors Community
https://support.google.com/docs/thread/191970798/google-sheet-copy-with-a-condition?hl=en Dec 8, 2022 ... I want to make a new tab on the spreadsheet that copies Cells from Column F (only) to the new sheet but only if column M matches A1 on the new list.
Google Sheets drop down: choose text from list, return number in cell
https://support.google.com/docs/thread/13293015/google-sheets-drop-down-choose-text-from-list-return-number-in-cell?hl=en Aug 31, 2019 ... duplicate your 72 column tab and change the tab name to something meaningful. ... I understand that I need to make a copy of my upload sheet ...