offset values

  1. A

    Find and copy corresponding value to another cell on another sheet

    Hi, I need assistance with my code as I am struggling to find a solution. I eventually split the array in two as I was getting an error. I am searching for words in sheet "ServiceType_SubType_Item_byComp" and copying the offset value to sheet "Charts", but often there are two cells with the same...
  2. A

    VBA: Function that sums an offset cell for every cell in a range

    Hello! I am trying to develop a Function that will Sum the values in column F, but only if the cell's row has "Clinical" in column D. My spreadsheet looks like this: While I was able to use the IF Function to perform this [...
  3. E

    Check value of several cells in one row, trying to shorten If Then statement

    I'm trying to have my macro check if cells in a row on two different sheets match. I'm able to get it to work using And & Offset, but I'd like to know if there's another method to accomplish the same thing in a shorter code. This is essentially what I've got so far: Dim Sheet1 as Worksheet...
  4. Prevost

    checking cell values beside selected range of cells

    Hi, I have the following code and what I would like to do is after the user has selected a range of cells, when they run the macro I want it to check each cell value to the left of the selected cells. If the cell to the left of the cell contains "ABC" then I would like the selected cell to have...
  5. A

    How to create a dynamic chart off dynamic data that has formulas???

    HELP!! I am trying to create a dynamic BAR chart that changes with my data. The below is my data set which is dynamic as well. I've tried using OFFSET but i must be doing it wrong and need help ASAP if possible. I need to chart columns A, B, and C. Like i said, all 3 columns are dynamic...
  6. T

    Pivot table error

    Hi, I have a pivot table that uses the OFFSET function to drag in my data dynamically as kindly shown by Bill "Mr Excel" Jelen. The issue that i am having now is that im having now is that when i go to filter my data i get a alue of "0" that can be filtered on. If i look in my data, there is...
  7. A

    Please help! Positive/Negative Account offset???

    Hi There, I have a spreadsheet containing approx 36000 lines of information. Column headings are: Business Unit, Cost Centre, Account Number, Amount etc. I need to be able to identify the positive and negative Amounts on the same Account within the same Business Unit. Ideally delete these...
  8. T

    Set Value from a cell moved 1 place to the right inside a For Loop

    Hello Coders, I have this loop, I get a range of specific cells and then I loop over this collection searching for a value, if this value exist I wanted to move one place to the right and then set a value on that cell, but for some reason when I put this offser(0,1) parameter, the loop became...
  9. S

    Copy and Paste Help

    Click a Button to start.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Looks through column C for blank cells (Cells equal to “”)<o:p></o:p> 1 – Identifies First blank cell in Column C<o:p></o:p> 2 – Copies data from an offset of (1, -2) and...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top