Create a new workbook--copy the worksheet with the most data to be kept to that
new workbook.

Then use a bunch of =vlookup()'s to retrieve values from each worksheet.

For more info about =vlookup()...
You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html

Jim15 wrote:

I am working with multiple worksheets in Excel which has data sorted
collected by a unique number. I have instances where I need to take
data from one worksheet and include it with data from another sheet
(keep in mind the unique number is on every worksheet). My problem is
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 to
worksheets, the best solution for me would be the creation of a new
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,

Jim

--
Jim15
------------------------------------------------------------------------
Jim15's Profile: http://www.excelforum.com/member.php...o&userid=26300
View this thread: http://www.excelforum.com/showthread...hreadid=468368

--

Dave Peterson