![]() |
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