r.offset

The code below runs fine. But I also want to use it to take the results (Dn.Offset(, 6).Value = R.Offset(, 5).Value) and multiplies R.Offset by the value in in the current row. Sub Find_Parent_Quantity() 'Find the Parent's Quantity and place it in Column K Dim Rng As Range, Dn As Range, n As...

i have filtered data and trying to do the calculation with the one row above or one row down of the filtered data .how to achieve that . please advise? Sub GarsButSuspense() c = 64 rc = Cells(Rows.Count, "A").End(xlUp).Row With Range("A1", Cells(rc, c)) .AutoFilter Field:=64...

Is it possible to make the vba code below a UDF function? Instead of running macro with F8 everytime, I'd like to use it with a UDF function only for specific cells? Thanks! Sub Intervals() Dim r As range, C As range With Cells(1).CurrentRegion With .Offset(1).Resize(.Rows.Count...

Hi everybody, I have this VBA code which works on the data starting from Row2 of worksheet. Instead of Row2, I want it to start from row5. I tried to change it a little but I was not successful. How can i do this? please. thanks. Sub Intervals() Dim R As Range, C As Range With...

Hey all, My first time posting on this forum. :) I'm troubled by an annoying problem in my code. My goal is to transpose some data from a vertical to a horizontal structure. A date is looked up in a datasheet and everytime it finds that date, it should copy a value next to it to my summary...