Hi 'nan'-

As long as your data is arranged in consecutive columns and rows with
captions (field names) in the first row, there is no problem.

Place your cell selector in your records (anywhere), then go to DataSort
and specify up to three sort fields, ascending/descending. The records will
be sorted accordingly, including the content in hidden columns.

HTH |:)

"nanimadrina" wrote:

I want to sort on a column of data (card #) where my worksheet has hidden
columns. I read in help that I should unhide the columns, but I am trying to
avoid that because it is a corporate worksheet and I have to copy/paste data
into it each month.

Is there any other way that I can accomplish a sort with hidden columns? I
have zero experience with macros...would a macro be able to sort data with
hidden columns in it?

HELP! I'm trying to find a way to save hundreds of hours/year in gas
receipt reconciliations...