I normally run Ctabs with long banners & export them to excel. But this
causes trouble reading the output and hence I'm requested to split the
entire banner into many separate worksheet each contains only Total & 1 more
variable on the banner ie. sheet "age" will have all tabs with only banner
Total & Age, sheet "segments" will have all tabs with banner Total &
One workaround way to this I think is exporting the massive tabs to Excel,
copying this into many worksheets, deleting vars on the banner untill only 1
var & Total are left in each worksheet. But this seems to be very tedious &
Could you please advise if there is any better way out? and how to do it?
I'm thinking of a script that can help automatically separate the banner
when exporting tabs to Excel but don't know how to make it. Any input is
very very much appreciated.
Thank you so much!
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
For a list of commands to manage subscriptions, send the command