$$Excel-Macros$$ Excel hyperlink help required

2017-10-12 Thread Sourabh Salgotra
Respected Group Members kindly download the sample file for detail. Thanks & Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook pag

$$Excel-Macros$$ insert option is disabled in context menu

2015-08-01 Thread Sourabh Salgotra
Dear Sir, please help me to enable the insert option context menu. Thanks & Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E

Re: $$Excel-Macros$$ Excel Tip

2015-02-26 Thread Sourabh Salgotra
gt;> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> m

Re: $$Excel-Macros$$ Pick from drop down list disable on moust right click

2014-11-08 Thread Sourabh Salgotra
ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks & Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y

Re: $$Excel-Macros$$ plz solve my query sorting and unique data

2014-06-23 Thread Sourabh Salgotra
> Duplicates (under Data tab) will give you the same results. >> >> Regards, Abhishek >> >> >> On Sat, Jun 21, 2014 at 4:11 PM, Sourabh Salgotra >> wrote: >> >>> Dear Sir, >>> >>> plz solve

$$Excel-Macros$$ plz solve my query sorting and unique data

2014-06-21 Thread Sourabh Salgotra
Dear Sir, plz solve my query related to getting the unique and sorting data from the list. sample sheet attached. Thanks & Regards Sourabh Contact Numbers: +91-94630-49202 Website:

$$Excel-Macros$$ Macro to allow copy paste in Drop-Down list with validation intact

2012-10-05 Thread Sourabh
p me with this, I have written a macro but its not working can you please check or advice what am i missing or doing wrong. I am attaching the macro enable Excel sheet for your reference so that you can have look at the macro that i have written. Thanks Sourabh -- Join official facebo

Re: $$Excel-Macros$$ Introduce Yourself !!

2012-06-10 Thread Sourabh Salgotra
My name is Sourabh Salgotra, I'm from Batala(Punjab). I am running computer hardware business. i like biking, listening qwallis, old is gold song, ghazal's. On Sun, Jun 10, 2012 at 12:17 PM, wrote: > ** > Hi Excel Buddies! > > My name is Pooja Sharma, I'm from New

Re: $$Excel-Macros$$ Sorting Alphabetically with formula

2012-06-09 Thread Sourabh Salgotra
st to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza z

Re: $$Excel-Macros$$ Records found but unable to get proper result.

2012-06-05 Thread Sourabh Salgotra
ethod. On Mon, Jun 4, 2012 at 8:59 PM, ashish koul wrote: > > see if it helps > > > On Mon, Jun 4, 2012 at 8:48 PM, Sourabh Salgotra wrote: > >> Dear Sir, >> >>i have little knowledge about vba. that's why i am asking sol >> with in

Re: $$Excel-Macros$$ Records found but unable to get proper result.

2012-06-04 Thread Sourabh Salgotra
Excel > SalesAid Software > dguille...@gmail.com > > *From:* Sourabh Salgotra > *Sent:* Sunday, June 03, 2012 12:53 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Records found but unable to get proper > result. > > thanks for help. >

Re: $$Excel-Macros$$ Records found but unable to get proper result.

2012-06-03 Thread Sourabh Salgotra
> > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Sourabh Salgotra > *Sent:* Sunday, June 03, 2012 5:08 AM > *To:* excel-macros@googlegroups.com > *Cc:* Don Guillett ; rajanverma1...@gmail.com ; > noorain.ans...@gm

$$Excel-Macros$$ Records found but unable to get proper result.

2012-06-03 Thread Sourabh Salgotra
MANUFACTURING PROCESS 7 BF 2P CHEMISTRY PRACTICAL 8 BF 4P ELECTICAL TECHNOLOGY PRACTICAL 9 BF 7 INDIAN CONSTITUTION AND ETHICS sample sheet attached Thanks & Regards Sourabh Contact Num

Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION

2012-05-04 Thread Sourabh Salgotra
or the formula. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Sourabh Salgotra > *Sent:* Friday, May 04, 2012 1:03 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION

Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION

2012-05-03 Thread Sourabh Salgotra
t; On Thu, May 3, 2012 at 9:33 PM, Sourabh Salgotra wrote: > >> >> DEAR SIR, >>PLZ DOWNLOAD THE ATTACHED FILE AND GIVE THE CODE FOR >> CREATING FUNCTION TO CALCULATE WEIGHT AGE AND GRADE >> >> >> --

Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION

2012-05-03 Thread Sourabh Salgotra
Criteria for Calculation/ > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sourabh Salgotra > *Se

Re: $$Excel-Macros$$ regarding pivot table problem

2012-04-09 Thread Sourabh Salgotra
--- > To post to this group, send email to excel-macros@googlegroups.com > -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy --

Re: $$Excel-Macros$$ REG:$$Column to table formula not working

2012-03-28 Thread Sourabh Salgotra
chk this one. -- 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 answered. 2) Don't post a questio

Re: $$Excel-Macros$$ REG:$$Column to table formula not working

2012-03-28 Thread Sourabh Salgotra
-- > To post to this group, send email to excel-macros@googlegroups.com > -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay

Re: $$Excel-Macros$$ Urgent Help Required...!

2012-03-02 Thread Sourabh Salgotra
t to this group, send email to excel-macros@googlegroups.com > > -- > 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 &g

Re: $$Excel-Macros$$ Urgent Help Required...!

2012-03-02 Thread Sourabh Salgotra
ibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------ > To post to this group

Re: $$Excel-Macros$$ help needed??

2012-02-26 Thread Sourabh Salgotra
thanks for help sir i am already done with if statement. chk attachment. and provide other solution vlookup/index-match On Sun, Feb 26, 2012 at 9:33 PM, xlstime wrote: > please find the attachment > > On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote: > >> Dear sir,

Re: $$Excel-Macros$$ vlookup and index/match functions help required

2012-02-07 Thread Sourabh Salgotra
nsible for any loss. > > > ------ > To post to this group, send email to excel-macros@googlegroups.com > -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy muj

Re: $$Excel-Macros$$ vlookup and index/match functions help required

2012-02-07 Thread Sourabh Salgotra
thanx for help but its giving #na on entering 3.2 in any cell in bucket 3.2 to 4 range 4.1 to 5 range 5.1 to 6 range 6.1 to 7 range On Tue, Feb 7, 2012 at 8:39 PM, NOORAIN ANSARI wrote: > Dear Sourabh, > > Sort the data and use it.. > > =LOOKUP(B3&"*",$G$3:$G$

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread Sourabh Salgotra
ners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- mujhay dukh is baat ka nahin kay meri zaat ko mu

Re: $$Excel-Macros$$ RE: Array Help

2012-01-20 Thread Sourabh Salgotra
many -2 thanks to all of u -- 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 answered. 2) Don't p

Re: $$Excel-Macros$$ FW: Hidden file

2012-01-20 Thread Sourabh Salgotra
go to run type cmd @command prompt type attrib -r -s -h -a filename -- 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 atte

Re: $$Excel-Macros$$ query about translate

2012-01-20 Thread Sourabh Salgotra
> > -- > To post to this group, send email to excel-macros@googlegroups.com > -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is

Re: $$Excel-Macros$$ Excel - Array Help

2012-01-19 Thread Sourabh Salgotra
and plz explain the sum formula of counting unique records On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra wrote: > Thank you so much sir, if we want without help. col > > > On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI > wrote: > >> Dear Sourabh, >>

Re: $$Excel-Macros$$ Excel - Array Help

2012-01-19 Thread Sourabh Salgotra
Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI wrote: > Dear Sourabh, > > Please see attached sheet. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://exce

Re: $$Excel-Macros$$ Excel - Array Help

2012-01-19 Thread Sourabh Salgotra
; > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- mujhay

Re: $$Excel-Macros$$ urgent query on dropdown list

2011-12-14 Thread Sourabh Salgotra
very very thanks sir. i want the list in dropdown list in sorted order. On Thu, Dec 15, 2011 at 9:17 AM, NOORAIN ANSARI wrote: > Dear Sourabh, > > Please see attached sheet.. > > -- > Thanks & regards, > Noorain Ansari > *http://excelma

Re: $$Excel-Macros$$ urgent query on dropdown list

2011-12-14 Thread Sourabh Salgotra
thanks to all of you for help but in this sol name are repeating and not in sorted order On Thu, Dec 15, 2011 at 12:25 AM, Maries wrote: > Find the attachment... > > > On Wed, Dec 14, 2011 at 10:00 PM, Haseeb Avarakkan < > haseeb.avarak...@gmail.com> wrote: > >

$$Excel-Macros$$ plz explain the working of fourmula

2011-12-14 Thread Sourabh Salgotra
;"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"}, > ">"&{"DD";"EE";"FF";"EE";"GG";"BB";"FF";&qu

Re: $$Excel-Macros$$ urgent query on dropdown list

2011-12-13 Thread Sourabh Salgotra
uot;EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"}, > ">"&{"DD";"EE";"FF";"EE";"GG";"BB";"FF";&qu

Re: $$Excel-Macros$$ urgent query on dropdown list

2011-12-13 Thread Sourabh Salgotra
thanks for help plz explain the following fourmula i have done everything with these fourmulas =INDEX(sname,MATCH(0,COUNTIF($C$1:$C1,sname),0)) =INDEX(eroll,MATCH(0,COUNTIF($B$1:$B1,eroll)+(sname<>image!$A$14),0)) but the list is not in sorted order. On Wed, Dec 14, 2011 at 5:26 AM, S

Re: $$Excel-Macros$$ urgent query on dropdown list

2011-12-13 Thread Sourabh Salgotra
ot;GG";"DD";"TT";"FF";"VV";"VV";"FF"}, ">"&{"DD";"EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";&qu

Re: $$Excel-Macros$$ urgent query on dropdown list

2011-12-13 Thread Sourabh Salgotra
acro can: > 1. make a list from your existing full list > 2. As each name is selected, remove it from the created list. Or, if no > longer needed, the original list. > etc > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Sourabh Salgotra &g

$$Excel-Macros$$ urgent query on dropdown list

2011-12-13 Thread Sourabh Salgotra
Dear Sir, plz download the attached file. detail query in file. Thanks & Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BA

Re: $$Excel-Macros$$ need correction in the formula

2011-11-22 Thread Sourabh Salgotra
> 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ---

Re: $$Excel-Macros$$ SUM Reg.

2011-11-11 Thread Sourabh Salgotra
on in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

2011-10-01 Thread Sourabh Salgotra
p;"!$B$2:$B$9"))),ROW(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"))-MIN(ROW(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9")))+1,""),ROW(A1))),"",INDEX(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$A$2:$A$9&q

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

2011-10-01 Thread Sourabh Salgotra
second post, you will not get that #NUM error. Check > the attached file in my previous post. > > Sam > > > On Sat, Oct 1, 2011 at 10:12 PM, Sourabh Salgotra wrote: > >> VERY VERY THANKS SIR FOR HELPING ME I HAVE ONE QUERY ALSO PENDING >> >> I WANT THAT WHIC

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

2011-10-01 Thread Sourabh Salgotra
group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.b

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

2011-10-01 Thread Sourabh Salgotra
On Sat, Oct 1, 2011 at 1:23 PM, Sourabh Salgotra wrote: > thanks for help > > but in this sheet all the data returned from the selected sheet searching > not working. > > i want 2 solutions > > 1 choose sheet > 2 search data (which is in c3 cols) if u type singh in

Re: $$Excel-Macros$$ Fwd: date format help

2011-09-30 Thread Sourabh Salgotra
; 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups

$$Excel-Macros$$ want to run a perl script on unix from excel . Possible ?

2010-09-26 Thread Sourabh
Hey friends , Do help me find a code which can run scripts in unix terminals, Thanks, S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailyt