Thread: Macro lookup
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
dudemango
 
Posts: n/a
Default Macro lookup


<sheet 1
Week Begining X TITLE X VALUE <- these are the column headings
16 January 2006
23 January 2006
30 January 2006
06 February 2006
13 February 2006

<sheet 2
06 February 2006 <- this date is changed using a spinner
1st column
TITLE
VALUE
2nd column
X TITLE
£200.00
these values in the 2nd column need to be pasted into the row in sheet
1 that contains the date given above in sheet 2

sorry if this is not accurate enough


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