Hi, i have an issue, this code is kind of working the problem is that in column K i have formulas that will only display data when the formula is correct, the problem is when the code runs it paste the items offset to the last formula, can i get it to paste offset to the last value instead?
Code:
Sheets("Sheet1").Range("K" & Rows.Count).End(xlUp).Offset(1, Sheets("Sheet1").Range("M1").Value).Resize(10, 1).Value = Sheets("Sheet1").Range("G3:G12").Value