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, Kanwaljit Singh Dhunna < > kanw

Re: $$Excel-Macros$$ Little Macro

2015-02-04 Thread Vaibhav Joshi
Yes, check this... Cheers!! On Wed, Feb 4, 2015 at 11:49 PM, Kanwaljit Singh Dhunna wrote: > Hi Vaibhav, > > A little tweak would do wonders ! > > In Column F1 I have a Validation List "Yes,No" > If I select Yes, then the result is printed, but I have selected No, then > only Status is updated

Re: $$Excel-Macros$$ Little Macro

2015-02-04 Thread Kanwaljit Singh Dhunna
Hi Vaibhav, A little tweak would do wonders ! In Column F1 I have a Validation List "Yes,No" If I select Yes, then the result is printed, but I have selected No, then only Status is updated in Sheet but no printing is done. On Sun, Feb 1, 2015 at 4:21 PM, Vaibhav Joshi wrote: > It gives status

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: > >> :)) >> >> You can see the smile ! >> May God bless

Re: $$Excel-Macros$$ Little Macro

2015-02-01 Thread Vaibhav Joshi
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 Yours Life ! > > A curious point. Why the column C needs to be b

Re: $$Excel-Macros$$ Little Macro

2015-02-01 Thread Kanwaljit Singh Dhunna
:)) You can see the smile ! May God bless you with Bigger Smiley Moments in Yours Life ! A curious point. Why the column C needs to be blanked *manually* before running anything ! Is there some issue in doing it via Coding ? On Sun, Feb 1, 2015 at 12:12 PM, Vaibhav Joshi wro

Re: $$Excel-Macros$$ Little Macro

2015-01-31 Thread Vaibhav Joshi
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 Internet Explorer & by o

Re: $$Excel-Macros$$ Little Macro

2015-01-31 Thread Kanwaljit Singh Dhunna
Hi Vaibhav, Thanks for the reply. I found some sample values. AGRS11370C - 01026025086 AGRS11370C - 01174026662 AGRS11370C - 01026053751 Above are correct values with me. You can use any incremental number with AGRS11370C to check for incorrect values. On Sat, Jan 31, 2015 at 8:02 P

Re: $$Excel-Macros$$ Little Macro

2015-01-31 Thread Vaibhav Joshi
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 wrote: > Dear Experts, > > I am assessing the following site for a pre-defined list by entering the > requited two field like > > *P

$$Excel-Macros$$ Little Macro

2015-01-31 Thread Kanwaljit Singh Dhunna
Dear Experts, I am assessing the following site for a pre-defined list by entering the requited two field like *PTLP10490E and 091189600169286.* https://onlineservices.tin.egov-nsdl.com/TIN/JSP/tds/linktoUnAuthorizedInput.jsp The resuting page returns No Records found. But if the result is foun