Re: $$Excel-Macros$$ Macro Required

2015-06-30 Thread Kanwaljit Singh Dhunna
gt;> >> >> >> On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna < >> kanwal...@gmail.com> wrote: >> >>> Ok Vaibhav. Even though I have very little idea about VB (Just read the >>> codes and try to understand them) I will give it a shot. >&

Re: $$Excel-Macros$$ find exact value contains special characters like *, ?, #, " excel cells using match function

2015-05-06 Thread Kanwaljit Singh Dhunna
iving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere R

Re: $$Excel-Macros$$ Allocating plots of Lands

2015-02-08 Thread Kanwaljit Singh Dhunna
Yes Vaibhav ! As Usual you are right ! On Sun, Feb 8, 2015 at 10:47 PM, Vaibhav Joshi wrote: > Also you can do using solver > > On Sun, Feb 8, 2015 at 12:00 AM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hello Sir, >> >> 2858 hectares

Re: $$Excel-Macros$$ Macro Required

2015-02-07 Thread Kanwaljit Singh Dhunna
egroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need

Re: $$Excel-Macros$$ Allocating plots of Lands

2015-02-07 Thread Kanwaljit Singh Dhunna
, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwa

Re: $$Excel-Macros$$ Macro Required

2015-02-06 Thread Kanwaljit Singh Dhunna
MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/grou

Re: $$Excel-Macros$$ Macro Required

2015-02-06 Thread Kanwaljit Singh Dhunna
ribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https:

Re: $$Excel-Macros$$ Macro Required

2015-02-06 Thread Kanwaljit Singh Dhunna
gt; solving Queries at par with VBA experts.. > > Yes i did had hands on it & I have trial ready with me, wanted to see your > work before posting... > > Appreciate your positive response! > > Cheers!! > > > On Fri, Feb 6, 2015 at 2:51 PM, Kanwaljit Singh Dhunna <

Re: $$Excel-Macros$$ Macro Required

2015-02-06 Thread Kanwaljit Singh Dhunna
rts. Have you tried your hands on it ? On Fri, Feb 6, 2015 at 2:20 PM, Vaibhav Joshi wrote: > Hi Kanwaljit > > Any luck? > > On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi wrote: > >> yes, you an do it... >> >> >> >> On Thu, Feb 5, 2015 at 5:02 PM,

Re: $$Excel-Macros$$ Macro Required

2015-02-05 Thread Kanwaljit Singh Dhunna
Ok Vaibhav. Even though I have very little idea about VB (Just read the codes and try to understand them) I will give it a shot. On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote: > i want you to work on present requirement... > > On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Sin

Re: $$Excel-Macros$$ Macro Required

2015-02-05 Thread Kanwaljit Singh Dhunna
!! > > > On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hi Experts, >> >> I have attached a sheet. >> I wish there could be a macro which when run >> --assess the website given in column A1, >> -

$$Excel-Macros$$ Macro Required

2015-02-05 Thread Kanwaljit Singh Dhunna
resulting values and paste them into the required columns in the sheet (if the input value is invalid then only Mark INVALIDPAN in column B) --copy and value given in Next Cell i.e., A5 and so on till the List is exhausted. Hope I am clear ! -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739

Re: $$Excel-Macros$$ Little Macro

2015-02-05 Thread Kanwaljit Singh Dhunna
That Was Amazing Indeed ! How do you do it ! Kindly share what should be the First step in Learning VBA. I am seriously into this now... On Thu, Feb 5, 2015 at 12:19 PM, Vaibhav Joshi wrote: > Yes, check this... > > Cheers!! > > > On Wed, Feb 4, 2015 at 11:49 PM, Kanw

Re: $$Excel-Macros$$ Little Macro

2015-02-04 Thread Kanwaljit Singh Dhunna
> It gives status. Even if you dont do, excel will overwrite it. > > Cheers!! > On Feb 1, 2015 4:13 PM, "Kanwaljit Singh Dhunna" > wrote: > >> :)) >> >> You can see the smile ! >> May God bless you with Bigger Smiley Moments in Yo

Re: $$Excel-Macros$$ Understanding the macro code

2015-02-04 Thread Kanwaljit Singh Dhunna
--- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send

$$Excel-Macros$$ Macro Required

2015-02-04 Thread Kanwaljit Singh Dhunna
resulting values and paste them into the required columns in the sheet (if the input value is invalid then only Mark INVALIDPAN in column B) --copy *the *value given in Next Cell i.e., A5 and so on till the List is exhausted. Hope I am clear ! -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739

$$Excel-Macros$$ Macro Required

2015-02-04 Thread Kanwaljit Singh Dhunna
resulting values and paste them into the required columns in the sheet (if the input value is invalid then only Mark INVALIDPAN in column B) --copy and value given in Next Cell i.e., A5 and so on till the List is exhausted. Hope I am clear ! Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911

Re: $$Excel-Macros$$ Little Macro

2015-02-01 Thread Kanwaljit Singh Dhunna
Got it Now ! Thanks a Lot ! On Sun, Feb 1, 2015 at 4:21 PM, Vaibhav Joshi wrote: > It gives status. Even if you dont do, excel will overwrite it. > > Cheers!! > On Feb 1, 2015 4:13 PM, "Kanwaljit Singh Dhunna" > wrote: > >> :)) >> >

Re: $$Excel-Macros$$ Little Macro

2015-02-01 Thread Kanwaljit Singh Dhunna
wrote: > Dear Kanwaljit Singh Dhunna, > > Check attachment, you need to fill data in col. A & B, keep col C > blank b4 running macro. > > Check that you have set correct printer as your default printer as > data will be sent directly for print. > > Press blue butto

Re: $$Excel-Macros$$ Little Macro

2015-01-31 Thread Kanwaljit Singh Dhunna
PM, Vaibhav Joshi wrote: > hi > > can you send combination of sample data which has value to create macro > for sending result to printer.. > > On Sat, Jan 31, 2015 at 7:35 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Dear Experts, >>

$$Excel-Macros$$ Little Macro

2015-01-31 Thread Kanwaljit Singh Dhunna
e is sent to printer automatically. Otherwise the page is not sent to printer and I can feed the next value. Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* --

Re: $$Excel-Macros$$ Please suggest

2015-01-21 Thread Kanwaljit Singh Dhunna
send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA

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

2014-11-24 Thread Kanwaljit Singh Dhunna
op receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. &g

Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

2014-10-09 Thread Kanwaljit Singh Dhunna
Have a Look ! I hope you are aware of how to enter an Array Formula ! On Thu, Oct 9, 2014 at 9:07 PM, Sundarvelan N wrote: > Friends. > > I tried all your suggestions i did not got the answer > > Thanks > N.Sundarvelan > 9600160150 > > On Thu, Oct 9, 2014 at 8:14

Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

2014-10-09 Thread Kanwaljit Singh Dhunna
any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to

$$Excel-Macros$$ WDV Method

2014-08-15 Thread Kanwaljit Singh Dhunna
the asset is in fractions, i.e., 2 Year 2 months, the rate does not depreciate the asset accurately and the salvage value is different than the actual salvage value. Please guide me how to solve it. I have attached a file. -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

2013-07-16 Thread Kanwaljit Singh Dhunna
re subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

2013-07-16 Thread Kanwaljit Singh Dhunna
gt; > > > > > On Tue, Jul 16, 2013 at 7:51 PM, wrote: > >> ** >> Dear All, >> My question is also the same why we are using choose funtion here! If any >> one please explain the same then will be very thankful. >> >> >> Sandeep Chhajer.

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

2013-07-16 Thread Kanwaljit Singh Dhunna
e answered. >>>>> 2) Don't post a question 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. >&

Re: $$Excel-Macros$$ Re: Vlookup Choose Query - HELP

2013-07-16 Thread Kanwaljit Singh Dhunna
ledge 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 > members are not responsible for any loss. > --- > You receive

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

2013-07-16 Thread Kanwaljit Singh Dhunna
ps "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros...@**googlegroups.com. >>> To post to this group, send email to excel-...@googlegroups.com. >>> Visit this group at &

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-24 Thread Kanwaljit Singh
.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950

Re: $$Excel-Macros$$ Round off in multiple of 25 paise!

2013-04-17 Thread Kanwaljit Singh
orum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-ma

Re: $$Excel-Macros$$ Round off in multiple of 25 paise!

2013-04-17 Thread Kanwaljit Singh
ail to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- Are you =

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

2013-02-17 Thread Kanwaljit Singh
bscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Sincere Regards CA Kanwaljit

Re: $$Excel-Macros$$ Remove highlighted number

2012-11-29 Thread Kanwaljit Singh
his message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://gr

Re: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup

2012-11-08 Thread Kanwaljit Singh
.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ EXCELLENT MIND READING

2012-09-02 Thread Kanwaljit Singh
t; dguille...@gmail.com > > *From:* Kanwaljit Singh > *Sent:* Sunday, September 02, 2012 1:49 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ EXCELLENT MIND READING > > Hi, > > Someone Noted how it works ? > > On Sat, Sep 1, 2012 at 1

Re: $$Excel-Macros$$ EXCELLENT MIND READING

2012-09-01 Thread Kanwaljit Singh
s message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > --

Re: $$Excel-Macros$$ Re: Download MS Office 2013 (Trial version)

2012-08-17 Thread Kanwaljit Singh
his 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$$ Regarding stock Prices link to website (nseindia)

2012-07-23 Thread Kanwaljit Singh
; > 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 > > To unsubscribe, send a blank email to > ex

Re: $$Excel-Macros$$ need for mula undertanding?

2012-05-13 Thread Kanwaljit Singh
't post a question 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 >

Re: $$Excel-Macros$$ need for mula undertanding?

2012-05-12 Thread Kanwaljit Singh
; 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. > > > ------ > To post to this group, send email to excel-macros@googlegroups.com > --

Re: $$Excel-Macros$$ need for mula undertanding?

2012-05-12 Thread Kanwaljit Singh
; ------ > To post to this group, send email to excel-macros@googlegroups.com > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- FORUM RULES (986+ members already B

Re: $$Excel-Macros$$ need for mula undertanding?

2012-05-12 Thread Kanwaljit Singh
natures are prohibited. > > 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 t

Re: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

2012-03-02 Thread Kanwaljit Singh
loss. > > > ------ > To post to this group, send email to excel-macros@googlegroups.com > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- FORUM RULES (98

Re: $$Excel-Macros$$ APPLICABLE ACCOUNTING STANDARDS

2011-12-20 Thread kanwaljit Singh
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$$ Increasing rows in Excel 2010

2011-09-22 Thread kanwaljit Singh
information... > It will be really imagine.. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > On Thu, Se

Re: $$Excel-Macros$$ Increasing rows in Excel 2010

2011-09-22 Thread kanwaljit Singh
To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-03-02 Thread kanwaljit Singh
http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><>&

Re: $$Excel-Macros$$ Open Internet Explorer automatically from Excel

2010-12-05 Thread kanwaljit Singh
oup @ 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.blogspot.com > > To post to this group, send email to excel-mac