ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   transfer of columns from one sheet to another (https://www.excelbanter.com/excel-programming/358548-transfer-columns-one-sheet-another.html)

[email protected]

transfer of columns from one sheet to another
 
Hi, i'm having the hardest time trying to transfer data from one sheet
to another sheet. The data that I receive comes from different sources

and are always in different order, however, the column name is always
the same. I wanted to transfer only the columns that I need to another

sheet within the same workbook in a specified order. In other words, I
want to make a template so that each time I copy and paste the data
that I received into sheet 1, I want the columns to be automatically
transferred to sheet 2 in the specified order. It doesn't matter if
its in excel formatting or vba, but if only availble in vba format,
then very clear descriptions will be greatly appreciated. I would be
very thankful for any help on this matter.



All times are GMT +1. The time now is 06:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com