Looping help, VBA, copy one row (data in 3 columns) and paste in another sheet to 12rows

HI,

I am trying to build looping in VBA, as i am new to VBA with basic skills i couldn't find the right technique to do this task, it is really more time consuming to do manually so am looking run this as loop through VBA

I have list of details in one sheet which to be copied to another sheet for 12 rows each and continues so on until it covers all rows from sheet 1

Sheet1: column G, column H and column I contains data, this data updates every time when i paste new data in another sheet, so i number of rows are not fixed ( may be xldown code helps)

procedure: copy row data from sheet 1 which includes data from G2, H2 & I2 and paste in sheet2 A2 to A14 (it should paste for 12 rows) and mean while it also paste B2 to B14 & C2 to C14.
and next step is go back to sheet 1 copy G3,H3 & I3 and paste in sheet 2 from A15 to A26 (next 12 rows) and this will continue until it covers all data from sheet 1

could anyone help me to build this code please

@holla_hc welcome to the excel forum.


Maybe I can't help you with your problem, but this would be a great start.


HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Hi Oeldere

Thanks for quick reply, i have attached a sample file to demonstrate the issue which i am facing, this is not the final workbook which i a working but i hope it gives picture for what i am looking for

Hi
Try

Please Login or Register  to view this content.