View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] joepark311@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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.