ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   fetch values from w/sheet (https://www.excelbanter.com/excel-discussion-misc-queries/226378-fetch-values-w-sheet.html)

TUNGANA KURMA RAJU

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.


All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com