![]() |
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