How To Reference Tab Name In Cell In Excel
Store worksheet names in the current workbook Type the target worksheet name into a cell in a sheet in the current workbook (ie the workbook containing your Power Query) Name the cell See our example below For help on naming cells, see our guide here on how to name cells and create named ranges in Excel This is how your cell reference 2 INDIRECT Function to Refer Sheet Name from Another Workbook in Excel We can also use and copy cell references from another workbook by using the INDIRECT functionThe screenshot below represents a workbook named Donation Data that is open with Day 1 spreadsheet We'll extract the value of Cell C7 to another workbook with the INDIRECT
