reference cell

I'm having an issue with a formatted cell. I am trying write som text in a cell and using a cell reference to put a value in the middle of a sentence. It looks like this Cells(122, 1).FormulaR1C1 = "This is text " & Range("B98") & " this is more text." when it returns the cell value I get the...

Hi I really hope to have some help with creating a sort of double reference. I'd like to refer a cell in in another spreadsheet, but I like to fill out the cell number from a cell in the current spreadsheet. Example: The data I need is in =Spreadsheet2!$B$24 But I'd like to pick up the '24'...

Hello all, I'm trying to do a lookup that references a table and uses three variables to locate the percent of traffic in a given store, on a given day, at a given time. I'm struggling with how to use multiple variables along the same axis (store # and day) because most of my experience with...

I know there are various threads out there about this, but I haven't been able to make this work. I am trying to input a formula (and it needs to be a formula, not just the current answer) that is activecell.offset(2,0).formula = sum(activecell:selection.end(x1up))*activecell.offset(2,-2)...

Hello, I have a longer code, but I'll save space. Essentially I have a "For Each rCell in Range..." code and I want to use that moving rCell as a reference to create another variable (sCell) that is used just for that one rCell, then on to the next rCell. For Each rCell In Range(Range1a...

I am trying to get the value of a cell based on the last value of a row that used the lookup formula. Let's say in cell A1, I referenced the last value of the row 300 on the sheet 2 renamed Notes. I used the Lookup function: A1 value: (=LOOKUP(9.99999999999999E+307,Notes!300:300). The value...

I was wondering if there was a way for a cell that references a span could spawn at the first cell referenced rather than the last. example - cell A1 on sheet 1 references cells B1:B52 on sheet 2. When I click on A1, which is hyperlink, it takes me to B52 on sheet 2 rather than B1. Is there a...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...