Macro for copy data for only two same column

 Blocked Profile -
i want macro for copy data for only two same column in all worksheets to one new worksheet in a workbook , column name like B or F . in all the sheets first row is same so we have to take only from sheet1 rest we take data not first row from all sheets. and write sheet name also in column A of new worksheet of that workbook

1 reply


Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.