reference cell

  1. J

    Max Function Refer To 1st Cell in Row

    I am trying to create a formula that will display the 'name' from column A that corresponds with the row of the value resulting from Max function for range in column B. To illustrate the desired results: On 'sheet 1' I have the max function determine that cell B5 has the highest number for...
  2. J

    Max Function Refer To 1st Cell in Row

    I am trying to create a formula that will display the 'name' from column A that corresponds with the row of the value resulting from Max function for range in column B. To illustrate the desired results: On 'sheet 1' I have the max function determine that cell B5 has the highest number for...
  3. C

    Referencing Cells in other Sheets using the Address function

    I'm building a table that references a dynamic range on a pivot table. So far I've gotten the function to return the address on the pivot table but it wont return the value. I'm doing this so that I can both refresh the two source data sets and summarize (pivot table) and also graph these two...
  4. R

    How to auto populate a worksheet using a reference cell

    I have two spreadsheets, one which contains job data, and the other that is set up as a job sheet form. Currently I link each cell of the form to the appropriate cells in the data sheet, but figure someone here may know a way that I can populate the needed data from the data sheet into the job...
  5. I

    Best way to link to other worksheets/books

    Is the only way to reference another worksheet cell is with an absolute path name ('C:\...\...\..)? I need to figure out the best way to make this "portable" to other users. I have a workbook which contains multiple tabs, each one with product pricing in different geographies (about 20 tabs...
  6. B

    Excel Cell links

    Hi guys, I need some help linking two cells in the same work sheet. I want to be able to click on a cell and it take the viewer to the related cell elsewhere in the spreadsheet... I can do this with a hyperlink but my issue comes when I move the linked cell to a new location. The link then goes...
  7. K

    Capturing changes in reference cell value

    Hi, I need the solution for the following: 1. Currently I have a randbetween() formula in cell B2. 2. Cell A1 = B2 (Every time the value in B2 changes so does the value in A1) Instead, I want that every change in value in cell B2 is captured in progressive cells. For example: First...
  8. S

    How to create a reference to a cell?

    I must be feeling dumb :confused: How do I create a reference to a cell, to use in a formula: On Sheet1 I have this: in cell A3, ='Sheet2'!A32 in cell A9 I want to display the contents of 'Sheet2'!A33 in cell A15, the contents of 'Sheet2'!A34 in cell A21, the contents of 'Sheet2'!A35 etc. So...
  9. R

    Conditional formatting based on another cell's format

    Is there a way to transfer conditional formatting across sheets in a workbook by referencing the cell? I have a large workbook that has Mon-Fri calendar schedules showing when employees are working. The Master Calendar tab is where we edit content and apply different colors to the cells so...
  10. B

    How to reference a named range

    Hi there, I have what I thought was a simple problem, but can't seem to find the answer. I have 11 names of named ranges in a list. I am trying to reference the name of the ranges in an =index(namedrange,3), so that I can drag my index formula down and select each named range. I tried...
  11. D

    Changing Value of a Cell Excel VBA Macro

    Hello, I am working on a code that writes labels to each row on a worksheet. The worksheet is comprised of a header row, which has a header for each category: |ID|Category|Sub-Category|Metric|Sub-Metric|Unit|Priority|Existing Reference|Comments|Data Link| Last row of the sheet can very...
  12. H

    Auto-populate checked data from sheet to sheet

    I am using a basic excel book with many sheets holding reference data. What I want to accomplish is, as I go through each sheet and mark a column beside data I need to pull at that time with say an "X", how can I create a formula on a separate sheet that will compile all the data I marked with...
  13. B

    Copy (range} from worsheets to "Results" sheet

    Windows 7<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Excel 2007<o:p></o:p> <o:p></o:p> PROBLEM: I have completed my loop through all the sheets in my workbook. All my data is copied to a “Results” sheet that looks like this. Player 1 has been copied...
  14. D

    Referencing PivotTable Page Fields "Absolutely"

    Hi there, Is there a way to reference the current value for a page field without using a macro-enabled file (i.e. without VBA)? I'm trying to do dynamic chart titles (by having a cell that references the page field I care about), but I get in trouble if additional page fields are added or...
  15. M

    reference a cell - RC Notation hurts brain

    Hello... I'm writing a macro that creates a summary worksheet that references data from other worksheets. I want the summary page to be dynamic so that if the user changes drop downs on other pages, the cells update accordingly. For example cell G2 = "=worksheet2!A2" which equals "Tree"...
  16. H

    Indirect Returning #N/A Error when referred to a range

    A Person using my workbook will go to sheet 2 and enter a series of integers from 1 to 5 inclusive. Sheet 1 will display analysis of the numbers. In order that the data be easily updated , I have had to use formulas which will refer to the right places when they are clicked and dragged, or in...
  17. J

    subform references in formulas

    I need some help in subform references in formulas, ie, I have Main form: frmMain subform sfrmSub1 sfrmSub1 fields: cost1, cost2, iCnt sfrmSub1 will have more than 1 record For instance, how do I do calculations such as cost1 * iCnt, cos2 * iCnt etc. Also, how do I differentiate between...
  18. M

    Cell Address

    Hi, I have a range where I want to find a cell address based on another function, like HLOOKUP or any other. But when I use HLOOKUP function as a 'refernce' argument in Excel's inbuilt function Cell(), it gives an error. Is there a way, that I can find a cell address based on any of the...
  19. T

    Referencing Blank Cells Without Zeros

    I would like to reference a blank cell in Sheet1 and have it stay a blank cell in Sheet2 without a 0 popping up. Is there a way to do that?
  20. P

    Referenceing NonConsecutive Cell with Macro

    I need to extract data from Sheet1 into Sheet2. The data being extracted is sample book analysis and each book has a series of row headers and column headers. The row headers are repeated for every book while the column headers are repeated once at the top. Each book is separated by a blank row...

Some videos you may like

This Week's Hot Topics

Top