View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TUNGANA KURMA RAJU TUNGANA KURMA RAJU is offline
external usenet poster
 
Posts: 171
Default fetch values from w/sheet

I have a w/sheet in which 4 columns data entered through userform every day.
I have userform in textbox1 if a value entered,clicked a commandbutton
"Fetch"
I need code for -match the textbox1 value fron w/sheet range A:A from down
wards (i.e if usedrange in Col A is A1:A25 match should begin from A25:A1),if
match found ,find today's date exists in Corresponding Column B:B,if found
fetch corresponding row values (range C:C,range D:D values )to userform
textbox2 and textbox3.if today's date not found do nothing.