LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Sheet & Copy Stuff littleredhairedgirl Excel Worksheet Functions 0 October 24th 09 01:22 PM
macro to create, name sheet and copy. sutha Excel Discussion (Misc queries) 4 December 23rd 08 01:53 PM
copy columns with order reversed Karra Excel Discussion (Misc queries) 1 December 11th 07 06:18 PM
How do I create a fundraiser order sheet? kathy Excel Discussion (Misc queries) 0 August 23rd 05 08:44 PM
How to create a Macro to Copy Information in one sheet to another sheet. poppy Excel Programming 3 July 28th 04 07:26 AM


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"