#REF! Error Referencing Worksheet After Importing Sheet
I have a template i'm making that is full of formula references to sheets not yet in existance in the workbook. what i want to happen is this: My code imports data files, renames the tabs to 1, 2, 3, 4... The formulas i already have are set in the CONCATENATED tab.... an example of such a formula is: ='1'!$P2.
so this should work, and yet it doesn't. the sheet is imported as it should be, the tab is renamed to 1, and yet the CONCATENATED sheet still shows #REF for the cell value. if i click in the cell, click in the text bar and enter out, the formula updates. there apparently is no option that i KNOW OF (although i'm sure there is something out there that does...) that will update this without me entering into the text bar and entering out.
Question: how do i manually update all references once the sheets to those references have been imported?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Worksheets & Cell Referencing #REF! Error
I have 3 worksheets: Lets call them RED, BLUE AND GREEN Essentially GREEN pulls Values from BLUE and BLUE pulls Values from RED. Red being the base worksheet from which everything is calculated. In my GREEN workbook I have the following =MIN('BLUE'!H14,'BLUE'!L14) And this will work fine.....Until I press a clear Worksheet button that has been implemented on the RED worksheet (button was not implemented by me and I do not wish to edit anything with respect to that button) When RED is reset the #REF! Error will appear in GREEN. This is fine because it cant find any values From BLUE. However when I do input new values into RED, which in turn updates BLUE which is where GREEN in theory should then be able to pull the results from.... But it just stays with a REF! error. Is there anyway i can permanently set a CELL to have the following code =MIN('BLUE'!H14,'BLUE'!L14), no matter what happens to other cells?
View Replies!
View Related
Error #13 During Importing Data. Query Error?? Or Wot?
I imported some data from an MDB file while working at home. created a macro to that effect. and it works fine at my home PC. but when i try t execute this macro on another PC or work place, then it gives error #13. i dont understand why. something is wrong with the code. i think it is the "WITH" code for query tables connection giving error ....
View Replies!
View Related
#REF! Error Using GETPIVOTTABLE
I have set up a monthly standard report using getpivottable results using the formula =getpivottable"A"+getpivottable"B". If either value is not valid in a month and the other is I was expecting a valid reponse but I get a #REF answer. How can I amend so that the formula substitues 0 for the invalid lookup?
View Replies!
View Related
Sort Page (Sheet 2) #REF! In Cell With IF Formula To Sheet 1
Sheet 1 is my main page containing all my data, full of formulas and is protected. Sheet 2 is a simple sorting page with no color and is simply for sorting and printing. Sheet 2 has IF formulas refrencing rows and cells on Sheet 1. Example Sheet 1 A2= Bob Sheet 2 A2="" until I put in this formula: =IF(Sheet 1!A2="","",Sheet 1!A2) Now Sheet 2 A2= Bob Simple... But when I delete a row in Sheet 1 (using my cool new macro...long story) I get #REF! in the cells on my sorting sheet, as I should I guess, because there is no more row there to reference. It's annoying, but what do I do to fix it without just unchecking the #REF! in autofilter on Sheet 2. I just want to eliminate #REF! Do I need to put something else in the IF formula?
View Replies!
View Related
Sum A Row That Also Has REF Error In It
I'm trying to sum a row of cells that has formulas in these cells and in certain cells there are the results of this formula and in some no (still needs to be worked out and till now it's showing as a REF error). Whan I'm summing all up to get the total it's telling me also a REF error. Can I get aroung this with another formula rather then the SUM formula,
View Replies!
View Related
#ref Error With Indirect Function
I have been searching through your forum but I can't seem to find the solution to my problem. I have two sheets: On one sheet in cell b2 I have a validation list whose source is =Indirect(Subgroup) which gives a #ref error. However when I evaluate Subgroup, I get a legitimate range. I have attached an example of what I am trying to do.
View Replies!
View Related
Indirect Function #REF! Error
In Excel 2007, the following cell Q14 CSE formula accurately returns the row number of the first negative value in the column P array P14:P102. {=MAX(ROW(INDIRECT(ROW()&":"&MIN(IF(P14:P102="",ROW(P14:P102)))))*(INDIRECT("P14:P"&MIN(IF(P14:P102="",ROW(P14:P102))))
View Replies!
View Related
#REF! Error From GetPivotData Function
Excel 2003, WindowsXP When I type = and then click in the pivot table under group1, I am recieving a #REF error. It strange because when I do the same thing in another group (ie. group 2 or group 3, etc.) in the same pivot table I don't recieve the error?
View Replies!
View Related
Delete One Of The Source Rows I Get A #REF Error
I have two worksheets that directly link a range of cells on both sheets, ie: Output!a1 = Database!a1. In this case, the Database sheet contains data that I want to manipulate by deleting entries that are defined in rows. however, when I delete one of the source rows I get a #REF error on the Output sheet. Is there any way to avoid this so the entries will automatically shift down a row if a row has been deleted? :o So if i were to delete row two on the source page and the data from row three moves down, that would, in turn, cause the row three data on the output page to move down one row as well.
View Replies!
View Related
Match/Index Formula :: #REF! Error
I have a formula =INDEX(Wholesales!A:C,MATCH(Data!A2,Wholesales!A:A,),MATCH(C2,Wholesales!B:B,)) Now this returns the correct value for the first row only, then after that I get the famous #REF! error. Any ideas why it only works for the first row?
View Replies!
View Related
Hiding !REF# Error Using =indirect() Function
I am setting up a summary sheet that contains =indirect() functions for workbooks that don't exist yet. I would like some kind of function that returns the =indirect() function correctly if the workbook exists and just a 0 or blank if the workbook doesn't exist. I would like to have the indirect function in all of cells that as soon as someone creates a workbook it will update the summary sheet.
View Replies!
View Related
Prevent #REF! Error When Deleting Rows
I have a form on a SheetA wherein all cells are referencing the data in cells on SheetB. When I delete or add a row on SheetB, the cells in that row on SheetA read REF#. I need the row in SheetA to be added when I add it in SheetB and vice versa for when I delete a row.
View Replies!
View Related
Indirect Giving Me A REF Error When Closing Workbook
My indirect formula doesn't work when I have the entire path defined. I have the entire filepath specified (which will never change), and then I have cell A6 with the tab name of the worksheet on the workbook . Workbook 1 named 'Testme' contains the table with range a2:b5 Worbook 2 contains the formula I put this formula into workbook2 (the tab in the example is named hitab & I put that name in cell B6) Here is what I have:Does not work even when other workbook is open =VLOOKUP(B6,INDIRECT("'H:CUSTOMERSCurrentClientAMRO and General SuppliesBearings, Motors, PTsSavings Tracking[Testme.xls]"&A6&"'!a2:b5"),2,FALSE) This DOES work when workbook is open, but not when it is closed (which would seem logical if when the workbook is closed, the formula needs the exact path) =VLOOKUP(B5,INDIRECT("[Testme.xls]"&A6&"!$a$2:$b$5"),2,FALSE) I can hard code everything except the tab name. Why doesn't Indirect recognize an entire file path and also why does it give a REF error? - I did a search and found that some people said to use the add-in Indirect.exe. I followed the link and the page was no longer found.
View Replies!
View Related
Vlookup And Dynamic Named Ranges = #ref Error
I am trying to merge data from two worksheets onto a 3rd for a mail merge. The COLLECTIONS sheet contains the acct #, name and amount owed. The ADDRESSES sheet contains the acct #, name and all of the address information. The 3rd sheet is the MERGE sheet that I'm using as the reference point for my word document and the mail merge. Upon reflection the MERGE sheet is probably not necessary, but made sense to have it when I started out. Never the less... On the ADDRESSES sheet I am trying to name a dynamic range "AddressList" (I'm trying to go dynamic because the list of addresses will change from month to month). I am using the following formula in the refers to field when I name the range: =Offset(Addresses!$A$5,0,0,CountA(Addresses!$A:$A),CountA(Addresses!$1:$1)) I think this is what is giving me my problem, because the named range does not show up in the list when I try to go to the named range. Just in case that is not the problem, the #Ref is showing up when on the MERGE sheet I type a vlookup formula referencing the acct # on the ADDRESSES sheet. That formula looks like this: =VLOOKUP(A4,AddressList,3,0) which seems simple enough. Before trying to make the named range dynamic the formula worked fine, which is why I'm thinking the named range is what's giving me the problems.
View Replies!
View Related
Ref To Other Sheet
Without coping the contents of a sheet, I would like to have a macro that would write in the cells of sheet 2 something like "=Sheet1!A1", "=Sheet1!A2", "=Sheet1!B1" for the fiirst 3 columns until there is no data in the rows.
View Replies!
View Related
Deleting Worksheet Causes #REF! In Formulas
I have a macro that imports a text file. I then have summary sheets that reference to the sheets with the imported text file details. This is a task I complete every month. The next month I delete the sheets with the imported text file details before importing current month's details. But when I do that it screws up my references. Here's an example of a reference with previous months' imported text file details: = SUM('X'!$I$1:$I$3000)/2+SUM('Y'!$I$1:$I$3000)/2 When I delete the sheets with the imported text file details and import current month's details, my reference suddenly looks like this: =SUM(#REF!$I$1:$I$3000)/2+SUM(#REF!$I$1:$I$3000)/2 What can I do to prevent the summary sheet from messing up my original references?
View Replies!
View Related
Macro To Goto Ref Cell On Another Worksheet
I have designed a workbook for a reservation planner which lists all production reservations over the whole year. Because of the limitations in columns, I have had to split up the workbook into 3 worksheets. I have a quick links section (52 command buttons) which redirects the user via macro to the specific week they require.... Sub Week12() Application.Goto Reference:="R6C256" Application.Goto Reference:="R6C118" End Sub The first split is at week 17 which is on sheet2. I am working far too hard at the moment and I cannot figure how to go to the sheet in addition to the cell references as above.
View Replies!
View Related
Deleting Linked Sheet Causes #REF
I have a Main sheet that has many formula on it that link to several Data sheets. Now sometime I want to delete the data sheets and recreate them by copying a Data template sheet and remaming it to the same name as whatever my data sheet was called. I see that this basically causes a Ref#! error in all the formula on my main sheet so when the data sheet is recreated it wont recognise it. How can i stop it changing the formula path to Ref#!?
View Replies!
View Related
Sub Worksheet Change Range Color Error Due To Protected Sheet
I have this code that works fine until I password the sheet and the range (b9:d65536) is protected. When I protect the sheet and make a change I get a debug error. What would I need to add/change to handle protected cells on a protected sheet? VB: AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy/pasting, but IS if the keyword uses "quotes" ....
View Replies!
View Related
Referencing A Field With An Error In It
My problem is I have a field when imported occasionally has a #Value! error in it. Most of the records are fine. As I will be importing it into another DB I need to have the #Value! removed and replaced with a Zero. Here is what I tried. I have a field that is displaying a #value! error. In another field that is referencing that field I wanted to do the following if statement. Basically if that error value is displayed show a zero, else show the value of the square. (Note I also tried it with an IIF but got a # Name? error) If((Q2) = "#Value!",0,(Q2)) Or should I be looking for an error? When I ran it, It basically gave me the value of the Q2 field. If((Q2) = Error(#Value!),0,(Q2)) Or is there some other way to get around the error?
View Replies!
View Related
Importing Worksheet
I am trying to import from Excel Worksheet 1 into Excel Worksheet 2 in a user-friendly manner. I've created a form in Excel Worksheet 2 that allows the user to browse for a file and select it. All I want to do is copy columns A through I from Worksheet 1 into Worksheet 2. How can I do this very smoothly without needing to open up Worksheet 1?
View Replies!
View Related
VLOOKUP Cell Referencing #VALUE Error
I'm working on a spreadsheet for a gaming community. This sheet is used by more than 3000+ players and growing. It has to be updated roughly twice a week for new inventory items, which can range from 1 to 3 new items weekly. To make it easier on new and existing members, I want to create a way to make updates with the spreadsheet easier and to allow players an easier way of updating the spreadsheet rather than re-entering all the data over and over again twice a week. So, I started to use VLOOK in some formulas to look at the data and pull the corresponding information. However, this same information is used throughout the sheet and referencing this information has brought about #VALUE errors that I cannot seem to figure out how to get around. I've included a copy of the spreadsheet to download and review in hopes of finding a solution. Here's what this speadsheet is doing: MyInventory is where the players will enter all their items, with some being drop-down selections and manual entry. The LookupedInventory worksheet is where the VLOOKUP (columns C,G,J,Q,etc.) formula is used to look up entries in the MyInventory worksheet and pull their values over to the LookupedInventory worksheet. Now these values from the LookupedInventory will be carried over into two other worksheets, InventoryTableAttack and InventoryTableDefense. These two worksheets are where my #VALUE errors are appearing. If the cell referenced is empty, the #VALUE error appears. However, if the cell references a number, the rest of the formulas tied to to this cell reference work. However, since there are errors, the rest of the worksheet cannot function until I fix all the #VALUE errors. So, what I'm seeking is to see where my issue is and what I need to do to fix it. If I need to take a different approach to this, please let me know what that is and how to go about doing it. I've even thought about a macros that copies and paste all the current data from an older spreadsheet to the new one, but I'm not that good at macros. If I can stay away from macros, that would be good, but if not, then I'll have to dig in my heels and start leaning.
View Replies!
View Related
Importing Data From One Worksheet To Another
I am using Microsoft Excel 2003 and I am trying to import data from one worksheet to another. I found out how to import the data, but I can not find out how to get the data that I am importing to go into the labelled cells that I want them to go into. Is there any way that I can get Excel to do this, or am I searching for something that can't even happen?
View Replies!
View Related
Importing Data Conditionally From 1 Worksheet To Another
I used to know my way around Excel pretty well back in college, but I'm drawing a blank here several years later. I know there's a way to do this, but can't remember how. In the attached sheet, I have info on Sheet 1. Sheet 2 only displays the info with LABEL=2. How can I make this sheet 2 automatically do this and update based on changes to Sheet1?
View Replies!
View Related
Importing CSV Files In A Worksheet
The Excel 2007 help menu claims that you can open a CSV file directly into a worksheet but I always get all the fields clumped-up into the first column. After many tribulations I was able to import it through the Data import menu (text). Could someone explain what I am doing wrong with the first method described above. It appears that the CSV converter is not working properly on my computer.
View Replies!
View Related
Importing More Than 65000 Records Into One Worksheet
It is so nice to check-in once in a while to see all these new ideas and solutions of people's problems. So, I would like to ask a question that really bothered me for some time, and it looks like I cannot find a full answer to it. So here it goes: How can I import data which is either more than 65000 records long or it will sum up to be more than 65000 when imported? I need all my data to be on one worksheet, and I don't care if these data will be imported let's say in columns A B C, then once it reaches the 65K, it will be imported to the neighbouring columns D E F, etc.? I searched the Ozgrid for an answer and I found a thread importing more than 65K records
View Replies!
View Related
Lookup Referencing Closed File Returns Value Error
I have a file created in Excel 2003 that uses a vlookup to reference another file, also created in Excel 2003. The function returns VALUE when the referenced file is closed. I get the VALUE error whether or not I update links upon opening the file. If I open the source file, the function calculates properly. Here is the formula when the referenced file is open: =VLOOKUP(A38,'[June Scorecard confirmation.xls]VPSC Summary'!$C$10:$F$22,4,FALSE) The full & correct path appears in the formula when the referenced file is closed. Columns C, D & E in the referenced range contain text, column F contains a Sum. This file is linked to another file, also using lookups. The linked area in this file works without problem, but it is a precedent to the calculation in column F. Both these files reside on a network in subdirectories of the same logical drive. I am using a laptop that briefly had Excel 2007 installed on it, but was wiped clean before it was issued to me.
View Replies!
View Related
Importing Data Range From Another Worksheet With A Msgbox
How do I create a code to open a msgbox to select a number rows of records from 1-500 possible range to import from worksheet "Az3E" in Record4, to worksheet "AZ3E" in "Record2". Only import column A and E, to column A and E of the target worksheet starting with row 20. Do not import header row. In Column E import results as values only. Title "Selection" Inputbox "Select range in Column A and E to be Imported" "Range/#of rows to import"
View Replies!
View Related
Referencing The Name Of A Worksheet
way to reference the name of a worksheet in a cell, or even better, use a cell reference to dictate the name of a worksheet. In other words, I would like to create a new sheet, and set it's name ='Sheet1'!C1 so that if I changed C1, the worksheet would automatically be renamed to whatever is typed in C1. If that is not possible, I would like to have a cell be tied to the name of a given worksheet, so that if I renamed the worksheet, the cell would change accordingly...similar to the &[Tab] function used in headers/footers.
View Replies!
View Related
Referencing Another Worksheet
I have an XLS spreadsheet which updates cells through an ODBC connection to a database. The information is pulled across ok and 90% of the Vlookup and IF statements work. The problem arises on a summary page. When i start off the summary page has cell references in numeric order to another spreadsheet and pulls back the information to 4 cells Across and 1000 Down. ='Campaign Responses - Cash Break'!A2 This is a spreadsheet that changes once the queries have run and a number between 1-1000 records are returned. However once the data has changed and the page refreshed. Not all the results have been pulled across to the summary pages. A few are there but the numeric sequence jumps from......
View Replies!
View Related
Importing A Sheet From A Closed Workbook
I found this code on the net, and it works, it DOES import the sheet specified from a closed status, but it adds 0 where there were blank cells. The worksheets are static, the names will not change, but the information on them varies in # rows but the # of columns depends on the page.. The use of this import is to upgrade the program, by importing the sheets from the old version. The first part browses for the file, which is good, because it could be stored anywhere and named anything.. I have it set up to "Click to Import".... Private Sub CommandButton1_Click() GetValuesFromAClosedWorkbook "C:", "Book1.xls", _ "Personnel", "A:H" End Sub This next part does the importing, but it fills all the columns and rows that were blank with 0's and fills all the way down to 65536 thru my column H that I specified that had data above. Sub GetValuesFromAClosedWorkbook(fPath As String, _ FName As String, sName, cellRange As String) how this code can be modifed to do the following.. Detect and copy ONLY the used range of the closed workbook.
View Replies!
View Related
Importing Specific Csv Data Into Different Worksheet Tabs
I want to import a CSV file into a worksheet. one of the things i need to do for the import is seperate the data if its a different currency.BUT copy the format from a sheet called "MASTER" which will be hidden. some of the variables are as follows, there will be more 0 = GBP (£) ¢ = USD (U.S Dollar) E = Euro S = CHF (swiss Franc) A = AUD the csv file is layed out as follows [BTTP][BDTEE8][BDTEP8][BATNUM][DESC1][DESC2][VALUE][CURRCY] How ill i get VBA to loop throught the file and import the data into: New sheets if the Currency has been found already? on the next available row if already exists?
View Replies!
View Related
Referencing A Cell In A Worksheet.
I used to think I was moderately intelligent. Certainly, I thought I knew my way around a computer. Then I got the bright idea to try and learn VBA. Since then every attempt I've made in trying to produce the most basic of code results in mad fits of rage and me wanting to slit my wrists. I've read half a textbook and I keep trying to write simpler and simpler code to get some sort of result, just to give me the drive to carry on but no matter what I try it always goes completely wrong. So before I stick me head through the computer screen, here is today's attempt. I want to select a worksheet. I then want to copy the contents of cell A2 down to A1200. Private Sub CommandButton1_Click() Sheets("Calls Outcome").Visible = True Worksheets("Calls Outcome").Activate Range("A2").Select Selection.AutoFill Destination:=Range("A2:A1200") End Sub I’ve stepped through the code and I get an error on “Selection.AutoFill Destination:=Range("A2:A1200")”. After spending several eight-hour days trying to get something out of VBA I have zero energy and zero patience.
View Replies!
View Related
Clear Rows Vs. Deleting Rows To Avoid #REF! Formula Error - Macro
I have a macro which is copying data from several worksheets into one consolidation worksheet. When determining where to paste the data into the consolidation sheet, the macro includes some logic to find the last row that has data in it (using e.Range("A65536").End(xlUp).Row, where "e" is a variable holding the name of the consolidation worksheet). Once all the data is on the consolidation worksheet, I have a second worksheet with formulas that link to the consolidation sheet. The issue I have is that the first step of my consolidation macro deletes all data on the consolidation sheet to ensure that no data is double-counted). I am deleting the data with logic that simply deletes all rows from 3 to 65536. Once these rows are deleted, Excel returns a #REF! error on my second worksheet which is linking back to this data. Rather than deleting the rows on the consolidation sheet, I have tried using the Clear and/or ClearContents commands instead. This works (i.e., my formulas no longer error out), but results in the consolidation macro running very slowly (~15 minutes, compared to
View Replies!
View Related
Importing 4 Sheets From 4 Books To A Sheet In Another Workbook
I have a workbook called summary with a sheet called "detail" I have 4 workbooks Called week 1, week 2, week 3 and week 4. All the week workbooks have a sheet called Summary. I need to import the summary sheets from each week workbook into the the detail sheet. All workbooks are in the same folder. I need to only copy columns A,D,F,G. If someone can post code or point me towards a thread I can figure what changes need to be made. I am getting better but slowly!
View Replies!
View Related
Importing Data From A Website To Spread Sheet
Im trying to import data from a plumbing supply website to an excel spread sheet. On the supply house web site, for each part catgory there are corresponding pages containing a price list data table. there are from 1 to 3 pages (price list data tables) for each part category. i can import data from page 1 and page 3 fine. When i try to import data form page 2, it returns no data, or imports page 3 (instead of 2) I spoke to the person who designed the website and he said that it was a problem within excel and not a problem with his program. (said it was a problem with excel not being able to recognize the page)
View Replies!
View Related
Referencing Every Nth Row From Another Worksheet
I need to create a worksheet whose sole purpose is to return the values from every 17th row from another worksheet in the same workbook. I have spent a few hours trying to research the correct answer and OFFSET comes close but either I'm doing it wrong or it's not what I need. I want to be able to drag the (every 17th row from sheet 1) formula down about 100 rows. Assume A1 as starting place. I would prefer a formula answer as opposed to a macro or VBA.
View Replies!
View Related
Worksheet Referencing And Position Recognition
I have a bit of a complicated one here so I have attached my book, its probably easier to undertstand the query by looking at the book. Hopefully somebody can help me out here. I have 2 worksheets: A results worksheet - this contains all category of results, each category has been given a specific sort id. A foreign worksheet - this contains all categories found on the results worksheet with sort id = 7. Now the complicated bit. The whole exercise is too pick up the correct exchange rate for the foreign category (sort id 7). each foreign type has a specific number at the end of its description in brackets e.g (3). At the bottom of the "results worksheet" is a key which says what type of exchange rate to use for this type e.g. (3) Price of CAD 22.9 converted using exchange rate of CAD 1.9645 = £1. What I need to do is on the foreign worksheet, it to recognise the number in the item description, keep it in mind then switch over to the "results worksheet" find the keys at the bottom of the page (the key is not necessarily in the same place all the time!!), match the number in the items description with the corresponding key and then find the exchange rate. As i said very difficult to explain, since I reletively zero experience with this kind of work in excel. Luckily I been muddling my way through a work project gradually thanks to a forum member here. so i hope we can keep this up! edit: two restrictions in the way this solution can be done: 1- Results worksheet can not be modified, but it can be referenced to using INDIRECT, and you can make any number of modifications outside of the results worksheet. 2. Any solution must be automatic. /edit I have attached my workbook and highlighted the bits I need to fill and the picks I need to pick up. Would be ever so grateful if some1 could show me the light here.
View Replies!
View Related
Formula To Referencing Future Worksheet
Reference a worksheet that has not yet been created, avoiding the #REF! result? The formula I have is correct, however the macro generates new worksheets throughout the month in which the totals sheet is referencing. The problem being that the totals sheet is referencing worksheets not yet created.
View Replies!
View Related
Prevent Referencing Hidden Worksheet
I have a spreadsheet which I'm using as a log-in front for a series of other workbooks. The usernames and passwords are stored hidden cells within a "very hidden" worksheet. The workbook is protected and VBA code itself is password protected. In short no-one can directly view the passwords (unless the password to unprotect it all is known. What I have found is that someone can use a formula to reference the cells containing the user details. "=a1" for example. Is the a method hiding the contents of a cell from excel itself? I want the vba script to be able to see the value, but any "=a1" formulas to return a blank.
View Replies!
View Related
Importing Specific Sheet Of Multiple XLS Files Into One
I know similar questions have been asked before, but I couldnt work out how it is done. Basically I have several xls files with the same name, eg. "test" with an alternating number at the end. 1 - .... each of these workbooks contain several sheets but all books are the same just with different information on it. each workbook has got a summary sheet in it, i want to import all summary sheets into a single workbook called summary. but each sheet should be imported as in individual sheet.
View Replies!
View Related
Referencing Sheet Tabs
Is there a way to use the "value" of a name in a drop-down list to reference a sheet tab name in a formula? A1 has a drop down list. When a name (Bob's Sales) is selected from the drop down list, B1 shows the value of cell D5 from sheet "Bob's Sales".
View Replies!
View Related
|
TRACKER
