Re: $$Excel-Macros$$ User form Query box

2012-10-08 Thread prabhat.shrivasta...@gmail.com
hi Ashish, Pl provide the solution, if you can. On Sunday, October 7, 2012 11:48:00 AM UTC+5:30, prabhat.sh...@gmail.com wrote: Hi Ashish, The excel list is consists of account nos in text format in column A i.e. 05223300056, 05223300057, 05223300058 so on rest will be

$$Excel-Macros$$ Re: User form Query box

2012-10-07 Thread prabhat.shrivasta...@gmail.com
On Sunday, October 7, 2012 11:03:46 AM UTC+5:30, prabhat.sh...@gmail.com wrote: 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

$$Excel-Macros$$ Re: User form Query box

2012-10-07 Thread prabhat.shrivasta...@gmail.com
On Sunday, October 7, 2012 11:03:46 AM UTC+5:30, prabhat.sh...@gmail.com wrote: 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

Re: $$Excel-Macros$$ User form Query box

2012-10-07 Thread prabhat.shrivasta...@gmail.com
Hi Ashish, The excel list is consists of account nos in text format in column A i.e. 05223300056, 05223300057, 05223300058 so on rest will be done by query excel forms/input box. Regards, Prabhat Shrivastava On Sunday, October 7, 2012 11:22:00 AM UTC+5:30, ashish wrote: can

$$Excel-Macros$$ User form Query box

2012-10-06 Thread prabhat.shrivasta...@gmail.com
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

$$Excel-Macros$$ Re: Find the cell value from other sheet

2012-04-30 Thread prabhat.shrivasta...@gmail.com
thanks don for your kind help, rajan, your function giving some error... anyways thanks a lot to you both, this is really very to seeing people helping other with their skills Thanks Ashish for creating such a nice group with good people like, Don, Rajan, Noorain, Dipilthanks buddy

$$Excel-Macros$$ Find the cell value from other sheet

2012-04-29 Thread prabhat.shrivasta...@gmail.com
Dear Frnds, I've a data sheet(reports) containing some data text in several row of entire sheet have another sheet(user ids) in column A containing few words these words may be or may not be the part of other sheet(report) text in cell of column A, now i wanna know if the sheet(user ids) text

RE: $$Excel-Macros$$ Find the cell value from other sheet

2012-04-29 Thread prabhat.shrivasta...@gmail.com
Thanks for your revert rajan, but i've one query ma sheet(report) contains text line as A112354 xyz abc etc or xyz A112354 abc etc in several row of sheet and other sheet(user id) contains only A1123 now i want to know if A1123 available in sheet(report) or nt... Regards, Prabhat S -- FORUM

RE: $$Excel-Macros$$ Macro to search text based on an array

2012-04-21 Thread prabhat.shrivasta...@gmail.com
Files contains user ids.. Regards, Prabhat S -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be

RE: $$Excel-Macros$$ Macro to search text based on an array

2012-04-21 Thread prabhat.shrivasta...@gmail.com
Actually these files are thr part of some imported system reports of ma bank which can not be transit outside the bank, Hence can't share, we create a sample file at our own by giving subject as below Report name date USER IDS DATETIMEREASON Pls copy paste these details in text

$$Excel-Macros$$ Macro to search text based on an array

2012-04-20 Thread prabhat.shrivasta...@gmail.com
Dear Experts, I'm preparing a macro to checks some reports, I have a folder that contains some text files with user ids other details with different files names an excel sheet contains the user ids. Now i wanna know if any of user ids mentioned in excel sheet are matching with user ids

RE: $$Excel-Macros$$ Macro to search text based on an array

2012-04-20 Thread prabhat.shrivasta...@gmail.com
Hi rajan, Thks fot yr revert, there arnd morethan 10 text files with diffrent headers but all files having the user ids as mentioned on excel sheet. Awaitaing yr response in this.. Regards, Prabhat S -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

$$Excel-Macros$$ lotus notes email

2012-03-20 Thread prabhat.shrivasta...@gmail.com
Dear all, pl help me to get the e mail ids that mentioned in a excel to copy at recipient of lotus notes... Say suppose that e mail ids mentioned in a excel particular cell i.e. cell c1, i want that all email ids get copied and paste at receipint of lotus note... Thanks fot your help in

Re: $$Excel-Macros$$ how to send mails from lotus notes

2012-02-17 Thread prabhat.shrivasta...@gmail.com
*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Fri, Feb 17, 2012 at 10:56 PM, prabhat.shrivasta...@gmail.com prabhat.shrivasta...@gmail.com wrote: hello experts, request you all to share a macro to send email contains the data report

$$Excel-Macros$$ how to create a user form return with vlookup query

2012-01-10 Thread prabhat.shrivasta...@gmail.com
I've a database with following headers Query ref nolocationCustomer name Query resolution Query120112-001 delhi xyz xyz abc Now i want help to create a forn in which if i entered the above query ref than all corrosponded details should return

Re: $$Excel-Macros$$ vlookup return with pcture assinged

2011-10-15 Thread prabhat.shrivasta...@gmail.com
://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Oct 14, 2011 at 8:23 PM, prabhat.shrivasta...@gmail.com prabhat.shrivasta...@gmail.com wrote: The file need to run on ms excel 2003 version. Rgrds.Prabhat On Oct 14, 12

$$Excel-Macros$$ vlookup return with pcture assinged

2011-10-14 Thread prabhat.shrivasta...@gmail.com
Good morning experts Need your valueable help to complete ma project, i have three n more pics in name of ram, shyam, n more pasted on diffrent sheet now i want if i write ram in a assinged cell ram's pic appear in selected area of sheet n so on. I dont wanna use macro for thisi need this

Re: $$Excel-Macros$$ vlookup return with pcture assinged

2011-10-14 Thread prabhat.shrivasta...@gmail.com
The file need to run on ms excel 2003 version. Rgrds.Prabhat On Oct 14, 12:03 pm, ashish koul koul.ash...@gmail.com wrote: see if it helps On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com prabhat.shrivasta...@gmail.com wrote: Good morning experts Need your

$$Excel-Macros$$ How to lookup multiple data range

2009-04-08 Thread prabhat.shrivasta...@gmail.com
Dear All, I want to know the to a lookup value from multiple data range or data files. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ Re: Fwd: Can you break password of attached sheet also let me solution.

2009-04-07 Thread prabhat.shrivasta...@gmail.com
how u unprotected this file??? Wot is the mathod to unprotect a file On Apr 6, 6:35 pm, Mudassar Ramzan johnplaye...@gmail.com wrote: Please find unprotected file and VBA password is 12345. Thanks regards, || Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 | 0321