Sorting Columns

[Bernie]

Hi,
I need to sort columns, except for the first two, and the last. Just
the ones in the middle. A column will be added in the middle when
another macro is run.

Thanks,
Bern

 

[Joseph Meehan]

Hi,
I need to sort columns, except for the first two, and the last. Just
the ones in the middle. A column will be added in the middle when
another macro is run.

Thanks,
Bern

What you want to do is an MS Excel spreadsheet function. Spread sheets
are great for that kind of thing. They work with rows and columns.

Access (the subject of this newsgroup) is a database and databases worth
with records. It is sort of like having index cards with different kinds of
data on each line. They also allow for relationships between types of
records (index card types)

You can move data from one or more tables in Access to an Excel
spreadsheet and work with it, in effect moving the data on say line 3 and 6
to different cards, and bring that re-organized data back to Access.

Under normal use, this should never be necessary however.