I am working with multiple worksheets in Excel which has data sorte
collected by a unique number. I have instances where I need to tak
data from one worksheet and include it with data from another shee
(keep in mind the unique number is on every worksheet). My problem i
this:

1. Match up unique number on different worksheets.
2. Move 1 or more columns of data (1 row only) to the other worksheet
In essence, create as many columns as needed for the additional data.

To keep my data in pristine condition, i.e. no modifications t
worksheets, the best solution for me would be the creation of a ne
worksheet where I can extract data from the various worksheets (1-10
and compile a custom worksheet with the data I am interested in.

I can send examples of the spreadsheets if needed.

Thanks,

Ji

--
Jim1
-----------------------------------------------------------------------
Jim15's Profile: http://www.excelforum.com/member.php...fo&userid=2630
View this thread: http://www.excelforum.com/showthread.php?threadid=46836