The code I wrote is as above. I want to get the data to the sheet which I am on(active sheet) from another sheet with offset function. How can I do this? Is there any other function that can do this except offset?

Insert Delete Format & Center Erg%98_8 Conditional Format as Cell Formatting Table Stvles Ecations - ProjectData_PowerBI_Group 18--.xlsm - [Module 1 (Code)] Clear Sort & Find & Filter Select Analyze Sensitivity Data Ln 9, Col 1 rmat Debug Run Tools Add-Ins Window Help (General) Sub macrol() macro1 -) Dim 1ROW AS Long iRow = Cells (Rows.Count, 1). End (xlUp) .ROW LYSIS) VERBI) For i = 2 To Row Sheets("DATA FOR POWERBI").Cells(i, 1).Value = Sheets("SALES-SAMLA").Range("A2").Offset(i, 1).Select Next i 5) End Sub X Sub age Interval() 4 + 7.04.2017 8.08.2018 280 411 68 23 66-70 20-25 M F 8