Hello!!
Yet another question for this stellar community...
I'd like to be able to sort my worksheets by the data headers in the first row (or if not those, then I suppose by column numbers, although words would be easier). However, there's a single merged cell in the second row(spanning the entire page, as a visual separator) which prevents any easy-access-Excel-preset sorting. And I haven't found a way to specify that my table has two header rows (is this possible? the second row doesn't really have any content, after all...).
So, it looks like I'll need to figure out some macro action. But that's above my head, I'm afraid. And so I turn once again to you wonderful people who help the code-challenged like myself.
Any suggestions? Please???
(sorry for the dismal tone -- it's after 5pm on a Friday, and MY choice would be to remove that culprit second line, and put the information in the document header...)
Thank you in advance, fine people.
elise
Yet another question for this stellar community...
I'd like to be able to sort my worksheets by the data headers in the first row (or if not those, then I suppose by column numbers, although words would be easier). However, there's a single merged cell in the second row(spanning the entire page, as a visual separator) which prevents any easy-access-Excel-preset sorting. And I haven't found a way to specify that my table has two header rows (is this possible? the second row doesn't really have any content, after all...).
So, it looks like I'll need to figure out some macro action. But that's above my head, I'm afraid. And so I turn once again to you wonderful people who help the code-challenged like myself.
Any suggestions? Please???
(sorry for the dismal tone -- it's after 5pm on a Friday, and MY choice would be to remove that culprit second line, and put the information in the document header...)
Thank you in advance, fine people.
elise