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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
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,676
Messages
6,126,170
Members
449,296
Latest member
tinneytwin

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