Why is coding easier than using excel - or getting information for it :o) I've got an excel doc with about 8 worksheets in it. The 8 worksheets are broken down into (say) 4 columns.
I'm trying to create a 9th worksheet with the exact same 4 columns. But on the worksheet i want it to be populated by the the other worksheets columns. An example is needed i think; Each worksheet has the following columns, and each column is populated. col1 col2 col3 col4 On worksheet 9 i want col1 to be populated with all the col1 data from worksheet 1-8. Then in col2 I want this to be populated with the data from worksheet 1-8 in col2 and so on..... Any ideas how to do this? Thanks, Andy J ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:29:61 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/29 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:29 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.29 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
