offset

HI All I would be grateful for the advice on the following: I have two "For Next" Statements nested inside each other. The outer loop takes a phone number from a spreadsheet, then looks the number up on a messaging service. The inner loop identifies the message conversations and drops each...

Hi there. I did one macro to find a value, then change a cell's value with an offset. Just a string. It is working. Now I just wanted to use the same macro, but I dont want to replace the content from the offset matching cells with a string but with a formula. And I have tried for hours to find...

referring to a cell by OFFSET(INDIRECT(ADDRESS(ROW();COLUMN()));0;-4) is easy Although I want to replace "$H:$H" in a formula by an OFFSET function referring to the entire column 4 columns to the current cell (column) How can that be done? example: =TEXTJOIN(", ";TRUE;IF($H:$H = E5;$I:$I;""))...

Hi all, I have this formula: Essentially, when I fill in ANY data or make ANY changes to cell D2, i want the VBA to automatically update the current date/time in cell B1, so I can see the last time I made any update to cell D2. I can do xOffsetColumn = -2 But this will show the date in...

Hello, I wanted to see that within a for loop in VBA, is there a way to start at a cell then every 4 columns over until the last column in use So starting at F44 it copies that formula there, pastes it every 4 columns now, so J44, N44, R44, and so on thank you in advance!

hello! i have to loop through specific columns because some columns are merged. In the code below, i am not sure how to resolve the part on "For j = 1,5,7,13,17". i need the code to run only columns 1,5,7,13,17. Any help will be greatly appreciated! For k = 1 to N # to loop rows For j = 1...

Hello, In the code below, I am selecting a specific range. Within that range I am replacing all the cells that contain $O$1 with a formula which contains the RowNumber. Note that everytime I run the code, the RowNumber value changes. So I cannot simply write a number as a replacement. When I...

Hello everyone, I am new to the board & thank you all in advance for the help. I have data for the time it takes each step in a manufacturing process & each step has a unique name that never repeats, as seen below, pasted in A1 corner. Steps time Start Point Sum of Steps Count 2800N1 5...

Hi All, Hope there is someone who can help and utter newbie in VBA coding. I have a workbook with multiple sheets. The first sheet (PFD Copy) is my master sheet from which I want data to be pasted into other sheets. The following is the code I have written so far: Sub Frommastertobuftarget()...

Hi Guys, I am trying to use the following formula : =XLOOKUP($B8,'[December 202021 WORKBOOK.xlsx]Sel'!$B:$B,'[December 202021 WORKBOOK.xlsx]Sel'!M:M) the return array being '[December 202021 WORKBOOK.xlsx]Sel'!M:M I need it to actually return the N:N column so i can copy it across so it...

Hi there, In my daily workbook I have an invoice date that changes every month and the payment date is always on the 2nd of the following month. I'm trying to create a formula to flag the payment date and show the corresponding cash outflow on the payment date. Using the OFFSET function...

Hoping somebody can help out...please :) I have a sheet that I want to do countifs on but when I put 2 working countifs together in one formula I get #value? 1. =COUNTIFS(Colleagues!$E:$E,$B$4) - returns the correct result 2...

Hi, Sorry for two posts about the same thing, won't let me delete the first one. I want to create a VBA code so that I can look up the string "Category 1" and use it as a reference to add a certain number of columns based on another cells value. The new cell values are to have the headings...

Hi All! As the title says, I have no idea how to modify the formula since I used this online template and still trying to learn. Can I ask for your help on below: Is it possible to get the total leave (NM8) subtracted to the entitled leave (NJ8) and carried forward (NK8) to show on the...

Hi. I have this code that copied and pastes data from two different workbooks based on matching data. However, I also need to include the value in the fourth column over. So for example the last line should be something like. But I am getting an error on this line. Sht.Cells(f.Row...

Hello (again) mrexcel forums, I'm working on a formula which outputs an array of values in an n*m grid, where the size of the grid may vary a lot between use cases. I've been getting good mileage with using arrays as named variables in equations, but i'm having trouble with the MIN/MAX...

I've been trying to use OFFSET formula nested within the ISNUMBER(MATCH) combination to get a dynamic range but can't get it to work. There's probably an easier and more elegant way to achieve what I'm trying to do to be honest but I thought about trying to see if this will work. First version...

I have ID's in a column (currently Col K) and Codes currently in Column M. (Columns will be added but Codes will always be two columns to the right of ID. I have the following code but how do I use Offset in the formula to look for an entry two columns to the right? I don't want the formula to...

Hi everyone, I got this bar-chart with x-axis labels of which I only want to show every 3rd item, but I also would like to start at the 2nd item of the list. now I got 1,4,7,10,... and I like it do show 2,5,8,11, but still chart data from 1, just the label needs an offset of 1. (VBA...

I can't for the life of me figure out how to adjust my code to offset the location of where the answer to my second input box question goes. How my macro is supposed to work. . . if A4 (for example) is my active cell and where the macro starts, that's where I want the answer to the very first...