offset

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

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

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

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

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

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

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

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

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

Hi Folks, Couldn't find anything on Google for this, so thought I'd ask. If my active cell was in D4 and the next cell to the left of D4 with a data value in was B4: Is it possible via VBA to determine the offset number from the Active cell (in this case -2)? My goal is to carry out a...

Hi, Trying to match a value and return the a value offset to the left. The values to search in are in the columns B to E (as per the table) I want to return the Level in column C I know two values (these come from another tab) 1. The row heading (Red names) 'Risk template'!F5 2. What I'm...

Can anyone help me with the following problem? I have a data structure like below, except that it's a lot wider and goes from the previous Monday to 365 days out across the width of it. There are about 1200 rows of data. 11/5/2020 11/5/2020 12/5/2020 13/5/2020 14/5/2020 15/5 100%...

Hi everyone, I'm working with template spreadsheets that get populated via copy/paste and compare volumes of assets in hypothetical what-if scenarios. In the daily workflow, the user manually inserts this information from another tool into Excel and does further analytics. However, the what-if...

I have below formula, when I click ok after entering the formula into that data validation source, it shows the formula as the options and not the values that should be there. Not sure if anyone else has had an issue like this. Any help would be greatly appreciated. =OFFSET(Data...

I have some code that I want to check every cell in in the range “A3:AAA3” for a specific text. If the cell contains that text, I want it to copy the text in the cell on the right, to two rows above (see below for illustration): The copied text will be a date. This is what I have so far...

Hi everyone! Right now I'm having troubles with how to repeat my macro for each cell in A. I have some offsets so it becomes very confusing. Here is my code. I recorded the macro while ticking 'Use Relative References' on. Hopefully someone can help me. Thank you very much in advance :) Sub...

Hi all, Hope someone can help, im trying to make a loop that relies on a range, which should be changing every cycle. Range("Q244").Select Do Until ActiveCell.Offset(0, -1) = "" Set RangeLoop = Range("C8:C25") With ActiveCell RangeLoop.Copy...

Hello, I've recently been attempting to get the next completely empty row in order to add data to it. Normally this would be pretty straight-forward, however I'm running into an issue where if the last row contains values that AREN'T in the cell on column A, then it will overwrite the last line...

I have the following code : Sub checkit() Dim c As Range Dim z1 As Integer Dim LastRow As Integer With Worksheets(1).Range("A1:O100") z1 = 0 LastRow = UsedRange.Rows.Count For Each c In Range(.Cells(2, 9), .Cells(LastRow, 11)) If c.Interior.Color = RGB(255, 255, 0)...

Apologies if this looks/sounds messy... In the middle of my (probably unnecessarily complex/large) formula, I have this function: (OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),-ROW()+2,0)) As it stands, this will pull the value of the cell 2 rows from the top, in the same column as the current...