Topic profile page for Cell reference.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Cell reference.
Topic "Cell reference" was discussed 3,046 times on 92 sites in last 3 months
Started 1 day, 19 hours ago (2009-11-27 18:55:00)
by tomd2712
Hi Everyone I'm trying to get a countif formula to work in an excel spreadsheet, but it keeps giving me 0 as the count, which I know is the wrong count. The spreadsheet is being used to record information on sales, and the page that has the details of past sales has a section for the percentage of sales over and under target. I am wanting to have the countif look at a particular cell ...
Started 5 days, 3 hours ago (2009-11-24 10:25:00)
by DrakeB
Please Register to Remove these Ads Hi I hope that i am posting this in the correct category, but my question is somewhat complex. I would like to reference a cell in an if//else formula that has the similar layout if 50 && 250 && 500) value = info in cell a4 Any help is greatly appreciated
Started 5 days, 13 hours ago (2009-11-24 00:15:00)
by ron2k
Using INDIRECT from one workbook to another to obtain cell reference of tab and cell content Hi guys with help from other threads I was able to device the following to obtain the tab name of a worksheet: A2=RIGHT(CELL("filename",$A$1),LEN(CELL("filename" ,$A$1))-FIND("]",CELL("filename",$A$1))) Now, I have a set of 5 workbooks ...
Started 5 days, 16 hours ago (2009-11-23 21:31:00)
by atvsource
I've been working on a jobs worksheet with 425+ check boxes that will need to be associated with a TRUE/FALSE cell so some other formulas and what not on other worksheets and pick up these i TRUE/FALSE. Now, I've already setup the check boxes and before I go through each one, one-by-one, I'm hoping there's an easier way of doing this. I personally do not want to have to go through ...
Started 1 week, 4 days ago (2009-11-18 06:41:00)
by Big Dummy
INDIRECT cell reference in another workbook In workbook named SSR2 in L2 I want to pull the data from cell H4 in workbook FData - the name of the sheet in FData with the H4 cell data I want is on the original sheet in SSR2 in cell F2. Here's what I've got (which isn't working): ='[FData.xls]INDIRECT($F2'&"!$H$4") ...
Started 1 week, 5 days ago (2009-11-16 18:20:00)
by Erich
I have tried to create a workbook that automatically grabs the filename and saves the document with some problems Both methods appear to work, but Excel always crashes. There should be a way to accomplish this without a crash. Method 1: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim objFolders As Object Set objFolders = CreateObject("...
Started 1 week, 5 days ago (2009-11-16 18:20:00)
by Erich
I have tried to create a workbook that automatically grabs the filename and saves the document with some problems Both methods appear to work, but Excel always crashes. There should be a way to accomplish this without a crash. Method 1: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim objFolders As Object Set objFolders = CreateObject("...
Started 1 week, 6 days ago (2009-11-16 09:20:00)
by Erich
( I have tried to create a workbook that automatically grabs the filename and saves the document with some problems Both methods appear to work, but Excel always crashes. There should be a way to accomplish this without a crash. Method 1: Private Sub Workbook_BeforeSave\(ByVal SaveAsUI As Boolean, Cancel As Boolean\) Dim objFolders As Object Set...
Started 5 days, 19 hours ago (2009-11-23 18:09:00)
by Aeroed7
Use cell as tab name reference Hello, If I am in cell B1 in tab "sheet1" and I refence cell A2 in another tab "sheet2", the formula shows up as "=+Sheet2!A2". Rather than hardcoding "Sheet2!" in the formula, is there a way, if I type "Sheet2!" into cell A1, that I can use Cell A1 as the refence in the formula? Can this be ...
Started 5 days, 11 hours ago (2009-11-24 02:41:00)
by Smitty
Re: Using INDIRECT from one workbook to another to obtain cell reference of tab and cell content Harlan does a pretty good job of walking thorugh an example here: http://www.eggheadcafe.com/software/...l-code-he.a spx And a good blog post from Dick Kusleika: http://www.dailydoseofexcel.com/arch...sed-workboo ks/...
Started 3 days, 2 hours ago (2009-11-26 11:21:00)
by Gord Dibben
No such function to pre-select type of cell references. Only F4 during or after entry as others have posted. Or use macros to change a complete range of cells after entry. Example macro............. Sub Absolute() Dim Cell As Range For Each Cell In Selection If Cell.HasFormula Then...
Started 1 week, 1 day ago (2009-11-21 11:13:00)
by AAE
VB : AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when View - Zero Values .", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\"");' onmouseout='GAL_hidepopup();'> Format (WS.Range("A1").Value + 1, "dd mmm yyyy")
Started 2 days, 21 hours ago (2009-11-26 16:51:00)
by Jon von der Heyden
Re: Reference calculated cell value We can't attach files here. I notice that your sample only extends through to row 69, yet the range included in the SUMPRODUCT extends through to 84. Is there any #VALUE! error present in the any of the SUMPRODUCT evaluation ranges? If any of the ranges being evaluated by SUMPRODUCT include an ...
Started 4 days, 8 hours ago (2009-11-25 05:48:00)
by Orson100
Thanks very much for the responses, In this instance, it is Donkeyote who has nailed it for me in fact. It is the case that I was referencing DNRs INDIRECT()ly from the control dialog. I will build a conditional statement to work around this as you suggest. Thanks again, great forum; although I like to try work things out for myself I have always found a solution when I come here....
