Transfer certain table values to specific cells in Excel.

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Beginner
Posts: 3
Joined: Wed Dec 10, 2008 1:00 pm

Transfer certain table values to specific cells in Excel.

Postby Beginner » Tue Dec 30, 2008 9:36 pm

Let's say I have created 100 tables with 10 rows and 2 columns.

I want to transfer the 5 values in column 2 in rows 1, 3, 5, 7 and 9.
The values from the first table I want to transfer to Excel worksheet cells A1, A2, A3, A4 and A5. Then the second tables corresponding values to Excel worksheet cells B1, B2, B3, B4 and B5, and so on with the other 98 tables.

Is that possible to program in SPSS?

I don't want to use the menu Export function, since it is only specific values I want transferred, and it's too much work to cut/copy/modify in 100 exported tables.

Who is online

Users browsing this forum: No registered users and 1 guest

cron