Hello, and thanks for providing this forum. I use Excel 2010. I do not understand VBA.
I am looking at the Excel Aggregate command video on You Tube at Excel 2010 Magic Trick 797: Check Items In List And Have Them Appear On New Sheet - AGGREGATE - YouTube (Excel Trick 797).
I want to gather...
I want to bring all the data in different sheets(same file) in a single sheet. The data is in the same format shown below in all the sheets.
<tbody>
Description
Drawing no.
EDP
Unit Price
</tbody>
I need to have a single sheet having the same column headings at the top of that...
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.