cell referencing

  1. Q

    Referencing range of cells one by one using VBA

    Hi, I needed some help writing VBA. I need to reference a range of cells (A2:A2357) one by one from sheet 1 to every 4th cell of column D in sheet 2, starting at D2. Please let me know how I can solve this. Thank you in advance for your help.
  2. M

    How to reference a different worksheet's title in a formula

    Is it possible to reference the name of another worksheet in a formula? For example, if I have a set of data with fields for January, February, etc., and have tabs that are named January, February, etc., and I want to lookup data in those tables based on the month specified in the field, is...
  3. L

    Mass Changing Cell References to Absolute Cell References

    I vaguely recall that there is a way to convert a range of cell references to absolute cell references in an efficient manner, but I have forgotten how. Basically the problem is that I wish to copy a range of cells with standard cell referencing to another column next to the original column and...
  4. R

    Conditional Format (color and icon) based on values in two cells...

    I'm familiar with CF but can't seem to apply two rules to the same cell in order to get an output that is formatted to be both a certain color and have an up/down arrow icon. The formatted cell (A1) should 1) be color coded (3 colors) based on a value range referencing B1 and 2) show up/down...
  5. I

    Extract data from one tab based on input date in a second tab

    Here is an image of what I am hoping to accomplish: https://imgur.com/y7uP2af Whether VBA or another way, I would really like to solve this. I am open to ideas. I initially tried to do it based on a vlookup, but the vlookup picks up the first in the range so it just brought in duplicates. The...
  6. Z

    Dynamic Custom Column in Power Query "M"

    Hi all, I'm trying to create a dynamic tool that references end user input in the query and performs operations on the source data. Right now I have a table on a spread sheet where a user can provide input which is then called in the query to create a custom column. The inputs correspond to...
  7. B

    Adjacent formual stop working when I delet a range

    Hi All, I have a worksheet in which users populate action points in columns A:G. Column G has a completion date for the task. In column H I have an if statement that checks whether the action is late or not depending on today's date and the closure date in column G. All works fine. At the...
  8. E

    Looking for correct method for assigning variables

    Hello, I am trying to make a macro that will essentially copy several different cells from one workbook to another. I used the macro recorder and it gave me the following code: (I attempted to add in the variable) Sub DoAllTheThings() ' ' DoAllTheThings Macro ' Dim eVariable1 As Integer...
  9. 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...
  10. H

    Possible for Formula to Referencing Future Worksheet?

    Does anyone know if it's possible to 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...

Some videos you may like

This Week's Hot Topics