VBA code to copy data from one sheet to another by matching the cell value with the sheet name

makrumahesh

New Member
Joined
Jul 16, 2012
Messages
2
I am creating a excel sheet with different month details from Jan to dec. and in a consolidated sheet, name all the months in different columns and copy the data from the each months sheets by comparing the consolidated sheets column name and paste it two rows below the column name of the month.. Please someone help with the code.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
More information on this;

if consolidate sheet, range F2= "JANUARY-2021" and is equal to a Sheet name: JANUARY-2021 then
Copy range AG11:AP20 from January -2021 sheet and paste is in consolidated sheet below the January-2021 cell

Please help...
 
Upvote 0

Forum statistics

Threads
1,215,511
Messages
6,125,247
Members
449,217
Latest member
Trystel

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