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

error.. Cheers!! 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, --copy the value given in cell A4 in the input box --wait for me

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

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

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