Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help; ther's got to be a better way :-(
Hi,
I have several reports that export into .xls spreadsheeets from SAP. They always export with multiple header lines which makes it hard to sort because doing 'DataSortw/ Header' only keeps the top line as header. I need to keep them all for my boss. I have been doing them manually but the 2 new ones he gave me this morning contain 37,000 rows each. Is there a way to sort all and have the first 6 rows be an exception? Any help is appreciated. Thanks, Nikki |