Matching rows of data using number.

[Jim15]

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

[Dave Peterson]

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