offset

  1. A

    Comparing first two weeks to last two weeks

    I have weekly data. I would like to create a monthly indicator showing the % change from the last two weeks compared to the last two weeks for each month. The output should look as follows: A B 1 16M01 % (where this calculation is ((16W03+16W04)-(16W01+16W02)) /...
  2. E

    How to solve a fill range need in a combo box within a VBA code?

    Hello, hope everything is good! I will try to be the most clear with the goal I'm tryin to achieve: I have a Sheet1 where I would like to enter a given record with some information about Country; Transit Type; Incoterm; Forwarder; Currency info. This would be almost what I needed (it...
  3. G

    dynamic offset if statement

    I have this formula, if the first sheet is blank, then it will go to the second sheet first row with data and continue. It is similar to the vba pasting under that last row, however I don't want to use vba if I don't have to for this workbook. This hopefully is an easy fix to this problem. Any...
  4. J

    VBA to change chart background picture offset values

    Hi, I'm looking for a way to change the Offset Top, Bottom, Left and Right values through VBA. The chart is an XY scatter plot. Any help appreciated!
  5. L

    Offset getting stuck in VBA code

    Hi, I cannot figure out why Offset in VBA code gets stuck after running few times... The section of the code below is supposed to record a timer value from C2 in column G. First it checks if the first record exists in F3:G3. There's no value there yet, so it works: records the timer result...
  6. K

    Find a value then copy a picture using offset

    I am trying to copy a picture using offset but I am not getting any data upon pasting. f.Offset(11, -8) is merged. I tested using f.Offset(11, -8).select on vba, then right-click copy, then paste to another sheet. I am getting the image, although not the right size. Here is my code: Sub...
  7. A

    Offset in VBA Code not working?

    Hi Guys, I have created a VBA code with help of a friend. The code copies contents of 2 columns on a sheet to a new sheet. But when I try to extend the code to copy more columns it just does not work. To be more clear it does not copy all of the cells below. Especially when I try to set it to 2...
  8. C

    Offset Index Match

    I need to get the column next to my target value here is my data sheet Sheet1 Oct Nov Dec Points available Points Achieved % Achieved Points available Points Achieved % Achieved Points available Points Achieved 0 0 #VALUE! #VALUE! 0 0 0 0 0 0...
  9. L

    Convert formula to work with conditional formatting

    Hi everyone, I'm a little confused by some conditional formatting that I'm trying to do. I use the formula =OFFSET(Content!M3,MATCH(TODAY(),Content!I4:I58,0),0,1,1) on "sheet1" Cell "H64" - it simply matches today's date with dates in l4:l58 and then gives me the information from relevant...
  10. andrewb90

    VBA to copy offset range

    Hi all, I have a macro that filters a table, then I am working on copying select pieces of data to another sheet. I have been able to copy individual cells, but I can't seem to copy an entire range, and any variation I make gives me errors. I'm sure its something very simple I'm doing wrong...
  11. R

    Copy value in cell AX to DX based on value in A(X-1)

    Hi everyone, Long time Excel user, first time posting as it has been some time since I have done anything with VBA and I have pretty much forgotten everything I once knew. I currently have a working macro that filters a list of copied data but because of some formatting issues in the source...
  12. A

    Add an " Offset " to a Cell Reference to a Simple =Sheet!A1 Formula

    Hi I have Sheet1 that References Sheet2 as follows; Sheet1 in Cell A1, =Sheet2!A1 Sheet1 in Cell A2, =Sheet2!A2 Sheet1 In Cell B1, =Sheet2!B1 Sheet1 In Cell B2, =Sheet2!B2 Works Fine, but when the data on Sheet 2 for instance moves slightly ( as the data is an import ) it all goes wrong. I...
  13. D

    VBA one cell returns date of last time another cell was edited

    Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...
  14. E

    Dynamic Dropdown List Error

    Hi All, First time poster, long time reader. I have been having an issue with a formula I am inputting into the data validation widget to create a dynamic dependant dropdown error. The formula is as follows: =OFFSET(Setup[[#Headers],[Savings]],1,MATCH([@[Expense...
  15. J

    Macro Help

    Hi all, I need help with an excel macro. I have only started to use macros and as a result have a very basic knowledge and understanding. I was wondering is it possible to create a macro that can be reused even when the raw data coming in changes the position of the cell that the macro was...
  16. Y

    AVERAGE EVERY 10 ROWS

    I have a spreadsheet with two tabs that keeps wins information for cases I work on for my job. The "Winners" tab has all the info and the "Summary" tab summarizes it all. Within the "Winners" tab, I have it broken up by a days, and each day has 10 lines attributed to it. For example, day 1...
  17. dreen

    Vlookup & Offset #Value Error

    I have two workbooks, one where I am doing the Vlookup and the other contains the table I need to retrieve the information from. I am trying to basically Vlookup the table found in the other workbook '[Database_IRR 200-2S.xlsm]Changes'! below row 3 as sometimes the lookup retrieves information...
  18. U

    Using Offset with MAX

    Hi, I have a workbook with data showing number of visitors at every hour for different dates. I have created another sheet which only shows the total number for each date. At first i used the following formula OFFSET('Sheet1'!$E$2,(ROW('Sheet1'!E1)*16-1),0) to copy the value in the 16th row...
  19. D

    Auto Refresh the Drop-Down List in Excel Worksheet

    Hello Everybody, First of all, thank you so much for using your time in assisting me with this matter and reading this inquiry. It is greatly appreciated! I am currently making an order form in Excel, where I am pulling my product data (material description) from a sheet I have named...
  20. C

    Using Offset on inactive sheet

    I am trying to run the following code but it only works when Sheet5 is active. Am I right in thinking that the Offset() property tries to select a range. Is it possible use Offset() with the sheet being active? For Each named_range In ActiveWorkbook.Names If Left(named_range.Name...

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