Copy range of cells from sheet to another sheet using offset

You can use it in any of a thousand ways - but you need to better explain what you want - what you are copying, where you are pasting, and the logic behind the two.

Try it like this - no offset needed (unless you want to loop?):

Please Login or Register  to view this content.

As a one liner, that would be:

Please Login or Register  to view this content.

If there is any logic between where you copy and where you paste - like the paste destination is always 6 rows lower than the row with the data

Format the cell in column A on each row with the data, and put "Click Me!" as the entry, and use code like this in the worksheet's selection change event:


1) Copy this code.
2) Right-Click the sheet tab of "Data"
3) Select "View Code"
4) Paste the code into the window that appears.

Please Login or Register  to view this content.

You could also do the reverse, and use formulas in cells of column B on Sheet1, like this in B8:

=Data!B2 & "," & Data!C2 & "," & Data!D2 & "," & Data!E2 & "," & Data!F2