Hi,
I want to create simple excel report for that data will be copied from different workbook, but i want to copy specific columns from each workbook. data will be match based on column names and will be pasted accordingly
For ex.
Report file column names are
A:Name
B:DOB
C:Last Name...
What i would like to do is create a macro to copy data from column B and then paste the values into a table on another sheet. The Data in column B will not always be consistent. Sometimes it may be B2:B610 that has data that needs to be copied, sometimes it may just be B2:B3, and other occasions...
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.