iterate through rows

I am trying to figure out how I can see if one cell is equal to another one on a different sheet, perform an action once that IF statement has been determined, and then iterate down one row on both sheets to perform the same analysis on the cells in the row directly below. Essentially what I...

Hello Everyone :) Thanks for taking the time to view this post. I am familiar with macros but the language is sometimes confusing to me sometimes and I can get overwhelmed. I have a raw data set that includes Categories and SubCategories. *************************************** Here is an...

I'm trying to write some code that links to certain sheets if certain cells are clicked. My sheets are named "01", "02", "03", ... , "20", ... "XX". I'm hoping I can use some loops to reference the names of the sheets since they are in a number format, but "j", which is how I tried to link cell...

A worksheet has data from machine oil pressure readings in column range A:D. The need is for a formula or macro to perform the following; Starting at row 1 copy the values of A:D to F:I every 5th row so that row 1 F:I will contain the values of row1 A:D, row 2 F:I will contain the values of row...

Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Dim row As Range Dim cell As Range myvar = "A1:A" & ThisWorkbook.Sheets("Sheet3").Range("A5") - ThisWorkbook.Sheets("Sheet3").Range("A3") For Each row In Range(myvar).Rows For Each cell In...