View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bryan Bryan is offline
external usenet poster
 
Posts: 114
Default Create copy of sheet using VB with columns in different order

I have a data sheet with column headings. I have a second sheet with
column A containing the preferred order of the columns and only the
needed columns. This can be changed to just be column headings if it's
easier.

I want to make a third sheet (or use the second one if we just use
column headings) with the columns of data taken from the first sheet
in the right order, skipping any columns not on the list and somehow
letting me know if a required column didnn't exist on the first data
sheet. Make sense? Please help me get started on this. I'm still
somewhat new to VB as I do about one little task with it every year or
two.