| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I fetch multiple rows back using VLOOKUP? | Excel Worksheet Functions | |||
| Use of Indirect function to fetch data from another Excel file | Excel Worksheet Functions | |||
| how to fetch a row and post the row into another sheelt | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
Threaded Mode
