offset

Hi All, I have the following data in column A of a worksheet starting from cell A1: Column A Column B ====== ============ xxx ABC xxx 123 4567 876 I am looking for VBA code that will colour the cell in column B in yellow if the cell to the left in column A contains "xxx" or...

Hello, I am trying to create a dynamic chart with the OFFSET function to display 2 data ranges of a factory production planning. Below is an image of the planning sheet, where the first row indicates the date, the second row shows the forecast, and row 13 indicates the processed workload. Based...

I want to multiply the data of Bangladesh Finance Limited every 11 months and skip 12 months. For instance, I want to multiply the data from January to November of 2015, then Skip December and then again multiply the data from January to November of 2016 and continue that for the rest of the...

Hi Everyone, With the way things have become over the past few years, I decided to use my time wisely and started to keep a tab on a few things, one of which is my mortgage. However, I wanted something much more in depth and struggled to find much, specially when it came to variable loan (with...

Hi, I'm looking for a formula that can look through a worksheet, find a value and add together the cells next to it. In essence I have a sheet that could have a value eg Oranges a number of times anywhere on it. What I would like to be able to do is have a formula that looks for all the...

I've been trying to get page breaks automatically inserted based on text within a specific cell. Most page breaks will use the text string "Project :" within the headers to insert a page break 4 rows above at the top of the page header. The cell which contains this "Project :" is either the text...

Dim rngY As Range Set rngY = ActiveSheet.Range("A1:MA1").Find("Main Image", lookat:=xlPart) Dim rngcol2 As Integer rngcol2 = rngY.Column Columns(rngcol2).Insert rngY.Offset(0, -1).Value = "Images" rngY.Offset(1, -1).Value = "images" Dim lr As Long lr =...

I need to set the row height of specific rows, starting at Row 33 and ending at Row 2208, with the offset of each row from the last being 29. It must only perform the row height change if there is a value in the previous cell in column B. i.e. Set Row Height for Cells B33, B62, B91, B120...

Hi, I have a formula that's working perfectly for me, which is this... "=IF($C4=0,"",MIN(IF('Main Log'!$D$4:$D$2000=$B4,IF('Main Log'!$O$4:$O$2000,"",'Main Log'!$E$4:$E$2000)))) It finds the minimum value (earliest date) in my 'Main Log' sheet where the criteria are met. However, in the next...

Hi, I currently have a searchable checklist that I would like to build in a function where if a row is selected by the values in column A, if there is already a True value for it in offset column E, it bounces back a message saying that it already is True (checked). User is only allowed to...

Hi Guys, I have created a clustered column chart and scattered chart to show the market rate and the actual rate as shown below. Now for each job titles with location I have been manually looking for FTE, Terms value by inputting respective values from the data stored in 'Inputs' sheet...

Hello, I have an exported, filtered list of results (not a table) where one out of two rows (the second one) describes the first one. Now I'd like to select these pairs of rows dynamically in order to format their borders, among other things. I'd like, for instance, to give the impression of...

Hello i'm new to MrExcel.com I have some issues with the following code below. I tried to make a link to the sheet name into the offset property It gives me an error: Option Explicit Sub Magazijnprint() ' ' PrintBereikBepalen Macro ' PrintBereikBepalen ' ' 'Productie Print...

Greetings All I am out of ideas on how to implement a "FILTER" Func with Multiple Criteria for Office 2019 which does not support the function while Office 365 does. I have following example setup on O365 Excel and works like a charm. I have (2) Workbooks - Workbook A [DCI Invoice.xlsx]...

Lets see if I can even describe this correctly... I have a userform that uses option buttons to help place certain shapes and then assign text to/around those shapes. Part of the userform is in the image below and an example of what I'm trying to do in the other image. My question is around...

I am in need of a code if Column K has value to insert next value into column N, if column N has a value to insert next value into column Q and so on. Please help!!

Hi folks, Kicking myself that I haven't figured out this yet on my own. See the mini-sheet below and here is what I'm trying to do: The Aton_Delta (C) column is data that comes in, from that I have a helper column that has a "1" in it if the C column data is non-zero The DeltaFromStart (D)...

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;""))...