Why not use =vlookup() or =index(match()) and then change the formulas to
values?

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

dudemango wrote:

hey all, yeh basically i have two worksheets, one with a row of data
(we'll call this data for now) that needs to be special pasted into the
other worksheet (week totals). on the week totals worksheet there is a
list of weeks, on the data worksheet there is a date. i need the data
from the data worksheet to be special pasted (i need only the values)
in the row on week totals which the date matches. if that doesn't make
sense i'll try and explain it again :)

--
dudemango
------------------------------------------------------------------------
dudemango's Profile: http://www.excelforum.com/member.php...o&userid=31137
View this thread: http://www.excelforum.com/showthread...hreadid=507998

--

Dave Peterson