Thanks for the suggestion. I realize that copy and paste is "the" option but
was just wondering - is there anything magical out there??

"Jim Cone" wrote:


Copy and paste would be my first choice.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Tall Bill"
<Tall
wrote in message
I have a worksheet containing a table consisting of a stub (1st column) and 5
columns contain figures. I would like to create 5 separate tables with the
stub being constant for each table such as:

A B C D E F = original

A B = first table
A C = second table
A D = third table
A E = fourth table
A F = fifth table

Is this possible??