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 w

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

2012-10-06 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$$ Re: User form & Query box

2012-10-06 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 in

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

2012-10-06 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 in

$$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 en

$$Excel-Macros$$ lotus notes mails

2012-05-03 Thread prabhat.shrivasta...@gmail.com
Dear Experts, I need urgent help to developed the macro, i've a list of my customer as Customer Name Address Client Code Mailid Amout Due I'm using the lotus notes application & wanna send them individual email with above data fitted in our standard format, the client code is a unique val

$$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 for

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 --

$$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$$ 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 f

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

2012-04-20 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 an

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 t

$$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 ment

$$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 advace.

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

2012-02-17 Thread prabhat.shrivasta...@gmail.com
nks & regards, > Noorain Ansari > *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: > >

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

2012-02-17 Thread prabhat.shrivasta...@gmail.com
hello experts, request you all to share a macro to send email contains the data report from excel sheet as body of mail to particular receipients. pl share a example workbook for better undrstanding... thanks in advance.. regards.prabhat -- FORUM RULES (986+ members already BANNED for viola

$$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 either

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

2011-10-15 Thread prabhat.shrivasta...@gmail.com
lmacroworld.blogspot.com/*<http://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 n

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 wrote: > see if it helps > > On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com < > > > > > > prabhat.shrivasta...@gmail.com> wrote: > > G

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

2011-10-13 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

$$Excel-Macros$$ VBA to get Cursor Position automatically

2010-01-15 Thread prabhat.shrivasta...@gmail.com
Plaese help me to get the marco to get cursor position automatically in defined cells. -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$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 Tutorials(Vide

$$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" wrote: > Please find unprotected file and VBA password is 12345. > > Thanks & regards, > > || Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 | > 0321 7325277 || > >

$$Excel-Macros$$ How to avoid NA# or remove NA# when there is no value found by vlookup.

2009-02-25 Thread prabhat.shrivasta...@gmail.com
Dear All, Pls help me out to avoid NA# error while there is no value found by Vlookup. let suppose if there is in a cloumn i did not found any value in define range than result would come as NA#. Now i want get the result other than NA# or result define by me. Thanks and Regrds Prabhat Shrivasta

$$Excel-Macros$$ Want a formula to lookup multiple value in single coloumn values.

2009-02-18 Thread prabhat.shrivasta...@gmail.com
Dear All, I want to know the formula to which retrieve multiple data from single column. 1 a 2 b 1 c 1 d 3 e 4 f lookup Value is 1 and data should retrieve all written in front of 1 i.e. a,c and d. Thanks and Rgds Prabhat Shrivastava --~--~-~--~~~---~--