Macro

S

Shoaibb

New Member
Joined
Jun 26, 2014
Messages
4
Hi there,

I was writing a macro but need your help. I have hundred sets of three columns consisting 21 rows. I need to write a macro that can copy three columns one by one and paste them below first set of three columns. so that all hundred sets will be one set of three columns.
I have 12 sheets to do this. and then I need to combine all 12 sheets in one sheet. here 12 are the months of year.
I hope, I have explained my problem with my broken English.

Thanks
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Sort by date Sort by votes
Thanks for reply

There are twelve worksheets ( 12 months) in the same workbook. every worksheet have 100 sets of three columns every column have 21 rows.
 
Upvote 0
[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]heading1[/TD]
[TD="width: 64"]heading2[/TD]
[TD="width: 64"]heading3[/TD]
[TD="width: 64"]heading1[/TD]
[TD="width: 64"]heading2[/TD]
[TD="width: 64"]heading3[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]27[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]39[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]I think you want to MOVE columns[/TD]
[/TR]
[TR]
[TD="align: right"]40[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]D,E,F to row 23 and below of[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]46[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]51[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]columns A,B,C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]52[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]58[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]63[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]64[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]69[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]then the same for columns G H I [/TD]
[/TR]
[TR]
[TD="align: right"]70[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]75[/TD]
[TD][/TD]
[TD][/TD]
[TD]and so on[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]76[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]81[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]82[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]87[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]is this correct[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]88[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]93[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]94[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]are there any row headings ?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]100[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]105[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]106[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]109[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]111[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]112[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]117[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]118[/TD]
[TD="align: right"]119[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]121[/TD]
[TD="align: right"]122[/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]124[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]126[/TD]
[TD="align: right"]127[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]129[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
VBA macro for combining and deleting duplicate rows, and adding values from one column
Replies
0
Views
144
Darko
D
D
  • Question Question
Formula references changing when adding a row to a table.
2
Replies
10
Views
142
Peter_SSs
Peter_SSs
G
  • Solved
Combining month label with year
Replies
2
Views
76
gauchofife
G
J
  • Solved
Hiding and showing columns in one operation
Replies
3
Views
133
jh9940
J
J
  • Question Question
Help with Sumifs formula involving dates
Replies
5
Views
161
Joe4
Joe4

Forum statistics

Threads
1,225,624
Messages
6,186,066
Members
453,336
Latest member
Excelnoob223

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top