Hi all,

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 & Segments....

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 & time consuming.

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!

Hop

===================== 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 SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD