Matching rows of data using number.
 

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

Matching rows of data using number.
 

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