Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Sheet & Copy Stuff | Excel Worksheet Functions | |||
macro to create, name sheet and copy. | Excel Discussion (Misc queries) | |||
copy columns with order reversed | Excel Discussion (Misc queries) | |||
How do I create a fundraiser order sheet? | Excel Discussion (Misc queries) | |||
How to create a Macro to Copy Information in one sheet to another sheet. | Excel Programming |