reference cell

  1. E

    Tracing Formula Frustrations — due to complex cell referencing​

    Suffering some apparent limitations of Excel. Excel cell referencing (i.e. $A$6) can become a major pain when I have to make changes to a complex spreadsheet. Multiple formulas to update etc. Tracing the formula is a major pain! I.e. Vlookup(A3, ProductMaster!$A$1:$D$25, 3, false) verses...
  2. K

    Losing Absolute Cell Reference

    I have the following formula in a cell on one work sheet: {=IF(ROWS($B$4:$B$4)>COUNTIF('Lab Submissions Ad 1'!$N:$N,"upper"),"",INDEX('Lab Submissions Ad 1'!$A:$A,SMALL(IF('Lab Submissions Ad 1'!$N:$N="upper",ROW('Lab Submissions Ad 1'!$N:$N)-ROW('Lab Submissions Ad...
  3. L

    Find value in string and return reference cell

    I have been a long time viewer of this forum but just recently signed up. Based on what I have found on here I know that someone has an answer to this problem. I have a cell in column B that contains a string of values (example 1) on one sheet in a workbook. On another sheet I have cells that...
  4. A

    Formulas to make references independent-multiple sheets

    I am gonna try to make the question simpler (so only one reference is required) the actual sheet has 54 reference columns. Sheet 1 Column A: Agent ID Column B: Agent Name Column C: Agent Region Column D: Member ID Column E: Member First Name.... Sheet 2 Column A: Member ID Up till now i...
  5. F

    Reference to cells that meet a condition

    Hi, I have the A column with 215 rows and each row can contain no value ("") or 1. I should select all rows with 1 and copy the 5 cells on the right on a different column. So, for example, if the value 1 is in A5, A34, A55 and A89, I should copy B5:F5 in C1 (C1:G1), B34:F34 in C2 (C2:G2)...
  6. S

    Selecting rows from a table

    Hi everyone, I couldn't find anything in the forum that could answer my question so here goes nothing... I am recreating a table from an older board game that uses a slide rule to report numbers. During the game, the slide moves up and down according to what space you land on. However, if you...
  7. A

    VBA Copy/Paste dynamic table into cells based on text reference

    I'm trying to make a macro that will copy a table with what will be an unknown length and paste it into a new location based on a reference text cell. Cell D1 will contain the text Week X where X is the current week of the year and the table is 5 columns wide (the source being in A:E starting in...
  8. A

    Use clipboard as reference, but clipboard is empty?

    I have this code below. Whenever I send an email, I want to put a "Y" in the corresponding row with a unique code that I entered. As I go through this code, I get to the line If item_in_review = Sheets("Data").Range("K" & row_number), but it keeps saying the clipboard is empty, but the excel...
  9. S

    How to refer to a cell that its column keeps changing?

    Excel 2007 <tbody> Row\Col A B C D E F G H I J K L 1 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 </tbody> <tbody> Sheet: Sheet1 </tbody> Excel 2007 <tbody> Row\Col A 3 The current accounting month (Feb-16) is the last...
  10. A

    Searching throughout multiple sheets and returning values between multiple workbooks

    Hello, I would appreciate any help with following. I have two excel workbooks, both containing multiple worksheets. I need to do following: - search the excel workbook 1 for a text from workbook 2 - when it is found - return a value from a specific cell in the sheet in workbook 1 (sheet...
  11. R

    Help! Excel VB refer on cell and macro question, I dunno how to explain it in word

    I have this condition as you can see in the image, 1. D3 are need data from B3 with formula =$B$3 & " and Indonesia" 2. I need to make B7 until B15, when i type "USA","Australia",etc in those cell one by one it'll do task like point no 1, so the result will be "USA and Indonesia" example : I...
  12. M

    Populating 1, 2, or 3 cells to the left with text of any cell that contains a specific value (test also)

    Hi all, hoping to get some help with this. I am establishing an availability table in Excel. I have dates listed by day across the top of the spreadsheet and people listed down the left. In the table I have the date that the individuals arrives on shift marked as AR and the day that they...
  13. C

    Fetch rows based on conditional formatting and display in new sheet

    Hi everyone! I'd like to automate excel so that it displays all records from other tabs where a certain condition is met (based on conditional formatting). In my worksheet I have multiple sheets containing data that I'd like to pull from. These sheets are all formatted in the same way (i.e...
  14. H

    Formula required referencing a cell's formula

    My Workbook contains 2 worksheets: Sheet1 & Sheet2 In Sheet2: B2=Sheet1!T17 In C2 I want to get value of column A i.e. 'like' =Sheet1!A17...but I don't want to punch this formula. I need a reference formula with respect to cell B2. Thanks in adv.
  15. D

    Referencing Multiple Cells Within A Loop (VBA)

    Hi guys, Think this is a relatively simple fix, but have not come across the solution online yet, so apologies if I have missed something obvious! I am looking at labeling each variable in a loop. So we have a very basic table, such as : <code style="font-family: monospace, monospace; margin...
  16. M

    Solution to find the value two cells to right of a reference cell which can change

    Hi, Could someone help with an excel query? I want to find the most recent date for each person and then choose the value two cells over for each ID? The following does not work as the MAX() range includes a mixture of dates and values: =HLOOKUP(MAX(A1,E1,I1),A1:L1,2,0) The database is...
  17. L

    VBA Insert row - keeping clacs and reference numbers in order

    Hi All I have been looking/trying various bits of code to insert a row on a large protected sheet. I have also been recoring various stages, but cant get the result I am after and think I might be overcomplicating metters. Large Excel sheet with A:Z and 1-100 hidden, full of calculations. The...
  18. M

    Searching a sheet for numbers with 7 digits in length, and appling for and if statements.

    Hello, I've got myself a little stuck!! Any help would be very much appriciated! I am using excel 2003, Please see the linked example workbook below: https://app.box.com/s/wkv1yn5040t3wolorz8u I have a workbook with two sheets, the first is a random splattering of words and numbers the second...
  19. H

    Referencing a cell & output required

    In my Excel workbook, there are 2 ws: tab named "4" & "5" respectively. In 4: AA2='5'!Z13 Output required: in cell AJ2 : the value in cell D13 of ws "5" by using reference to the cell content of AA2. How to accomplish?
  20. R

    Cell reference in a pivot table

    Hi, Using Excel 2010, Im trying to generate a formula to calculate a running subtotal from a data in a pivot table. I have a pivot that looks something like this: <TBODY> A B C D E F G H I J K L M N O 1 Column Labels Hours Days 2 Row Labels Jan Feb Mar Apr...

Some videos you may like

This Week's Hot Topics

Top