|User form & Query box||prabhat.sh...@gmail.com||10/6/12 10:33 PM|
This group help me a lot for ma assignment time to time, I m really happy to be the member of this group.
here again, I've some query & require help from expert of this group. I need to create a user input form.
I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) & return me with the result that "Data Available" or "Data Not Available", if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format & unique.
Request your help to get a sample sheet with the above condition,
Thanks for help in this matter.
Thanks & Regards,
|Re: $$Excel-Macros$$ User form & Query box||ashish koul||10/6/12 10:50 PM|
can you share the sample file
P Before printing, think about the environment.
|Re: User form & Query box||prabhat.sh...@gmail.com||10/6/12 11:09 PM|
|Re: User form & Query box||prabhat.sh...@gmail.com||10/6/12 11:14 PM|
|Re: $$Excel-Macros$$ User form & Query box||prabhat.sh...@gmail.com||10/6/12 11:18 PM|
The excel list is consists of account nos in text format in column A i.e. 052233000000056, 052233000000057, 052233000000058 & so on rest will be done by query excel forms/input box.
|Re: $$Excel-Macros$$ User form & Query box||prabhat.sh...@gmail.com||10/8/12 9:48 AM|
Pl provide the solution, if you can.....