Re: $$Excel-Macros$$ Macro Required

, 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. On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi v...@vabs.in wrote: i want you to work

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

. 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 to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

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

Yes Vaibhav ! As Usual you are right ! On Sun, Feb 8, 2015 at 10:47 PM, Vaibhav Joshi v...@vabs.in 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 to be allocated between three surveyors

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

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 to.* *IF U LOSE, DON'T LOSE THE LESSON

Re: $$Excel-Macros$$ Macro Required

. -- 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.* -- 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 page

Re: $$Excel-Macros$$ Macro Required

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

Re: $$Excel-Macros$$ Macro Required

hands on it ? On Fri, Feb 6, 2015 at 2:20 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Kanwaljit Any luck? On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi v...@vabs.in wrote: yes, you an do it... On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna kanwal...@gmail.com wrote: Ok Vaibhav

Re: $$Excel-Macros$$ Macro Required

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 kanwal...@gmail.com wrote: Hi Vaibhav, Thanks for the Concern ! I

Re: $$Excel-Macros$$ Macro Required

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 Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really

$$Excel-Macros$$ Macro Required

the 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

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 v...@vabs.in wrote: Yes, check this... Cheers!! On Wed, Feb 4, 2015 at 11:49 PM, Kanwaljit Singh Dhunna

Re: $$Excel-Macros$$ Macro Required

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 v...@vabs.in wrote: i want you to work on present requirement... On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh

Re: $$Excel-Macros$$ Macro Required

, 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, --copy the value given in cell A4 in the input box --wait for me to enter the Captcha MANUALLY

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

-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 to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

$$Excel-Macros$$ Macro Required

the 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

Re: $$Excel-Macros$$ Little Macro

: It gives status. Even if you dont do, excel will overwrite it. Cheers!! On Feb 1, 2015 4:13 PM, Kanwaljit Singh Dhunna kanwal...@gmail.com wrote: :)) You can see the smile ! May God bless you with Bigger Smiley Moments in Yours Life ! A curious point. Why the column C needs

$$Excel-Macros$$ Macro Required

the 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

...@vabs.in 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 button to run Macro Macro will one

Re: $$Excel-Macros$$ Little Macro

Got it Now ! Thanks a Lot ! On Sun, Feb 1, 2015 at 4:21 PM, Vaibhav Joshi v...@vabs.in wrote: It gives status. Even if you dont do, excel will overwrite it. Cheers!! On Feb 1, 2015 4:13 PM, Kanwaljit Singh Dhunna kanwal...@gmail.com wrote: :)) You can see the smile

$$Excel-Macros$$ Little Macro

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.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ Little Macro

PM, Vaibhav Joshi v...@vabs.in 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, I am assessing the following site for a pre

Re: $$Excel-Macros$$ Please suggest

/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 to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- 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

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

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

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

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

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

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 nsund...@gmail.com 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 PM, Kanwaljit Singh

$$Excel-Macros$$ WDV Method

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

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/groups/opt_out. -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

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

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 =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 page of this forum @ https

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

://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out . -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- 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 page

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

, chhajersand...@gmail.com 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. Sent on my BlackBerry® from Vodafone -- *From: * Kanwaljit Singh Dhunna

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

-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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sincere Regards CA Kanwaljit Singh Dhunna

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

/groups/opt_out. -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- 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 page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1

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

@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 =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

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

://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 =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

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

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://groups.google.com/group/excel-macros?hl=en. -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739

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

://groups.google.com/group/excel-macros?hl=en. -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread

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

...@googlegroups.com. -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

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

...@gmail.com *From:* Kanwaljit Singh kanwal...@gmail.com *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 12:58 PM, Sarika Parab sarikap

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

, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- Join official facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Regarding stock Prices link to website (nseindia)

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- -- FORUM RULES (986+ members already BANNED for violation) 1

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

. -- 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 BANNED for violation) 1) Use

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

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 (986+ members already

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

Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- 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

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

. -- 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 BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

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

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 -- Sincere Regards CA Kanwaljit Singh

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

. -- 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 (934+ members already BANNED

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

://www.facebook.com/discussexcel -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

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

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, Sep 22, 2011 at 3:10 PM, kanwaljit Singh kanwal

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

on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- -- Some important links for excel users: 1. Follow us

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

@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007