i have in column a many total rows like so 'Total 01/08/2006' and on
each total row in column C a total value.

I want to create a column in a separate book that has on the top row a
month (example August) with days of the month 1-31 below. For each day
i would like to look up in the other workbook and retreave the total
value for each day.

I can do this as a formula but want to consider that easiness of
running it in VB


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=563813