Re: $$Excel-Macros$$ Networkdays

2015-01-31 Thread Vijay Kr. Aggarwal
Thank you so much Ashish, Paul and Vaibhav !!! On Wed, Jan 28, 2015 at 9:41 PM, Vijay Kr. Aggarwal < vjaggarwal2...@gmail.com> wrote: > Dear All, > I need a formula which is able to > >- calculate the duration in (days, hrs, mins) between two date\time >values (eg 05/12/2012 5:30 PMand

Re: $$Excel-Macros$$ Networkdays

2015-01-31 Thread Ashish Kumar
Welcome Vijay, Regards Ashish -- 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) Use concise, accurate thread titles. Poor thread titles, like Plea

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

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

Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

2015-01-31 Thread Vaibhav Joshi
Hi Share sample chart.. On Fri, Jan 30, 2015 at 8:32 PM, Nitin Balodi wrote: > Vaibhav, its giving me subscript out of range error. I am thinking if we > have to put Sheet name before range (like Sheet1!Range1, Sheet1!Range2). > > I have chart and data in the same sheet and tried to include s

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