This question is asked better with the help of an example.....

I have a spreadsheet with data in following format....

ColumnA ColumnB ColumnC ColumnD
date1 1 abc
date1 2 def
date1 4 ghi
date2 2 abc
date2 5 ghi
date2 1 def
date2 6 abc
date3 4 def
date3 7 abc

and I would like to get this data in the following format....

date1 date2 date3 date4
1 abc def
2 def abc
3
4 def
5 ghi
6 abc
7 abc


and then I need to do further processing on this data (which I can
do).

Basically what I am looking for is, in my first spreadsheet identify
each row by a given date (columnA) and corresponding value in columnB
of that row, and now find a cell that is intersection of these ColumnA
and ColumnB values in second spreadhseet and fill in the value of
ColumnC (from spreadsheet 1) into that intersection cell in second
spreadsheet. As my first spreadsheet changes very often I am trying to
get my second spreadsheet modified with those changes and then
everything else I have in second spreadsheet will also change
automatically.

Any help is appriciated.
Thanks,
Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=555672