$$Excel-Macros$$ Excellent QA Analyst/Mobile Tester Available Immediately on C2C basis

s/ Mac and Android/ iOS platforms.* · *$ Rate**:** Open for discussion* · *Overall** Experience:** 6+ Yrs.* · *Availability to Join**:** 1 Week* · *Current Location**:** MD* Regards Ashish Kumar CFACT Consulting Services Meadow Park Tower 10440

$$Excel-Macros$$ Excellent C++/Software Engineer available Immediately on C2C basis

.* · *US* *Experience**:** No.* · *Availab**ility to Join**:** Immediately* · *Current Location**:** Austin TX* · *Relocation** Preference**:** Austin TX* Regards Ashish Kumar CFACT Consulting Services Meadow Park Tower 10440 North Central Expwy Suite 643

$$Excel-Macros$$ Hot Consultant available Immediately on C2C basis

/ East coast of US* *IMMEDIATE* *EAD* Regards Ashish Kumar CFACT Consulting Services Meadow Park Tower 10440 North Central Expwy Suite 643 Dallas, Texas 75231 Cell - *214 295 6356 (Direct)* Fax - (214) 698 8630 *ashis...@cfactcs.com <ashis...@cfactcs.com>* T

$$Excel-Macros$$ Ribbon_Gallery_Items

Dear Sunil Kumar Yadav, Don't violating our group rules. Go thru our group rules once before posting your queries. Regards Ashish Kumar On Sunday, July 19, 2015 at 11:51:58 AM UTC+5:30, Sunil Kumar Yadav wrote: Hi Experts I need your little help...please check my file i want to call my

Re: $$Excel-Macros$$ Uday File

Elaborate more -- 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 Please Help,

Re: $$Excel-Macros$$

Share Example. ?? Regards Ashish On 14 May 2015 at 11:18, Rakesh rksharma...@gmail.com wrote: Dear Experts, can you please tell me how to get 2nd,3rd... values with the Vlookup. Thanks Rakesh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ week based time-sheet Using master tracker

Hi Sandeep, Elaborate more. What kind of output you want...! 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,

Re: $$Excel-Macros$$ Re: formula required in column c excluding Zero

Elaborate more!! 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,

Re: $$Excel-Macros$$ Re: HOW COMPARE LIST OF FILE WITH EXCEL SHEET

Dear Mandeep, Great Work Buddy. Nice Solution provided by you. Regards Ashish On 16 April 2015 at 18:15, Mandeep Baluja rockerna...@gmail.com wrote: chk dis out. Regards, Mandeep Baluja -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Re: Multiple Sheets data consolidation into one sheet VBA

Hi Vaibhav Bhai. Superb.!! 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

Re: $$Excel-Macros$$ Find Second Highest value from data

Hi, Check this one too.. for auto Highlight Second Highest Value. 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

Re: $$Excel-Macros$$ Need some formula or MACROS

Hi Vaibhav Bhai, It's perfect .. !! superb :) 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

Re: $$Excel-Macros$$ Combining a Mid Function and Right Function into one statement

Hi Mychele, PFA 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

Re: $$Excel-Macros$$ Macro to Copy Active Sheet

Vaibhav Bhai, Sheet is working perfect. Great work!! -- 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.

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

Hi Eugene, Welcome..!! 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

Re: $$Excel-Macros$$ Mail from excel using gmail

Hi, change port no. to 465 also you need to enable smpt / imap services for your Google account and, incoming server pop up - 995 Reply back if you facing problem. 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

Re: $$Excel-Macros$$ Mail from excel using gmail

I think your internet connection is slow. -- 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

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

Hi Eugene, PFA, Filter your data then after hit the button 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,

Re: $$Excel-Macros$$ MOS Certificate Query

HI MV, Check this : http://education-portal.com/microsoft_office_specialist_certification_online.html 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 @

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

It's working Superb Vaibhav Bhai you are Great!!! -- 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

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

Hi Gaurav, Start new thread for new queries...!! Regaeds Ashish On 3 February 2015 at 02:07, Gaurav Devrani ​​ gauravdev1...@gmail.com wrote: No its new question. having trouble sending email to multiple recipients... When I run my macro. It is sending email individually and pop up every

Re: $$Excel-Macros$$ multi mailer

Hi Gaurav, PFA 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

Re: $$Excel-Macros$$ Networkdays

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

Re: $$Excel-Macros$$ Colour the Group Rows

Dear Ganesh, Go in Conditional Format tab and click on Manage Rules option and try to understand how the formula works. I think, you no need a macro for it. 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

Re: $$Excel-Macros$$ Wrong entry of a number

Hi Bhalara, Select the cell Go to in Format Cell Click on Text Enter Now, type your No. 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

Re: $$Excel-Macros$$ Colour the Group Rows

Vaibhav Bhai, Nice Solution. 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

Re: $$Excel-Macros$$ Re: Search Box - Event Macro ??

Solution is provided by Vaibhav Joshi. @ Vaibhav Joshi - Excellent Solution Vaibhav Bhai. 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

Re: $$Excel-Macros$$ Networkdays

Thank you Vaibhav Bhai...!!! 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

Re: $$Excel-Macros$$ Re: How to Sort Data

Check in Sheet 3. Hit the Button. 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

Re: $$Excel-Macros$$ Re: How to Sort Data

Hi Sachin, Which Msg. -- 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 Please

Re: $$Excel-Macros$$ Re: How to Sort Data

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

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Welcome Rahul Chavan you are working in Bharat Vikas Group. -- 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

Re: $$Excel-Macros$$ Networkdays

Hi Vijay, PFA 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

Re: $$Excel-Macros$$ find extract strings from column to another.

Vaibhav Bhai, It's Working Perfect!! Superb. 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

Re: $$Excel-Macros$$ Re: sum values with col/row criteria

Hi Vaibhav Bhai, Superb Solution, Formula working great!! 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,

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Hi, Hardly it's take 3 second for showing Batch Details. Did you checked the count of Batch Data which was in the user form. The Count is more than 5000. It's heavy..!! Yes We have two more Alternate Options for it. First is, Use the First Sheet, which I'hve send to you on dated 17th Jan.

Re: $$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

Thankyou Vaibhav Bhai. -- 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 Please

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Welcome...!!! -- 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 Please Help,

Re: $$Excel-Macros$$ Re: VBA Intersect Range...

Charles, PFA for find last value in column. 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

Re: $$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

PFA 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 Please Help,

Re: $$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

Thanks for ACK. Vaibhav Bhai. Say Cheers...!!! 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

Re: $$Excel-Macros$$ VBA - Cell with comma separated serial numbers - send list to individual cells

Formula is working Well. Nice Solution Vaibhav bhai. 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

Re: $$Excel-Macros$$ VBA - Cell with comma separated serial numbers - send list to individual cells

Elaborate more with Example On 22 January 2015 at 12:12, sswcharlie swch...@gmail.com wrote: HI Have cells that have had serial numbers entered (up to 50 serial numbers) each separated by a comma. Is there a VBA argument that can take the cell and transfer each serial number to its own

Re: $$Excel-Macros$$ VBA - Cell with comma separated serial numbers - send list to individual cells

Nice solution Vaibhav Bhai. 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

Re: $$Excel-Macros$$ VBA - Cell with comma separated serial numbers - send list to individual cells

Double Cheers to you. -- 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 Please Help,

Re: $$Excel-Macros$$ VBA - Cell with comma separated serial numbers - send list to individual cells

Hi Charlie, Check this. 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

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Hi Vaibhav Bhai, Thanks..!! 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

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Thanks...!! -- 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 Please Help, Urgent,

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Thanks. Pravin ...!! -- 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 Please Help,

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Thanks Vaibhav Bhai!!! 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

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

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

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

which field you want to pick as batch in GGRN sheet from Batch sheet. -- 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

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Share the password ...? -- 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 Please

Re: $$Excel-Macros$$ Data Copy from one sheet (or Form) to another sheet

Hi Ashish Bhalara, PFA 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

Re: $$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file

Nice Solution Vaibhav Sir. Regaards 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

Re: $$Excel-Macros$$ Check Image Info

Nice Solution Vaibhav Sir. 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

Re: $$Excel-Macros$$ Do while loop question

Nice Solution Vaibhav Sir. 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

Re: $$Excel-Macros$$ Do while loop question

Nice Solution Vaibhav Sir. Regards Ashish On 12 January 2015 at 19:57, Vaibhav Joshi v...@vabs.in wrote: Hi Liron try below code.. *Sub Test_4()* *Dim i As Long* *Dim countErr As Long* *countErr = 0* *i = 2* *For Each c In Range(A2:H5) 'change A2:H5 to your range* *If c.Value 0.18

Re: $$Excel-Macros$$ Iterating Filtered list using VBA

Nice Solution Vaibhav Sir Regards Ashish On 12 January 2015 at 20:05, Vaibhav Joshi v...@vabs.in wrote: Cheers Nitin appreciate your acknowledgement! ᐧ On Mon, Jan 12, 2015 at 7:32 PM, Nitin Balodi nitinbal...@live.com wrote: Hi Vaibhav, Many thanks, code worked. Regards. Yours

Re: $$Excel-Macros$$ Do while loop question

Cheers Sir Cheers... On 12 January 2015 at 20:04, Vaibhav Joshi v...@vabs.in wrote: Thanks Ashish !! Cheers!! ᐧ On Mon, Jan 12, 2015 at 8:01 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Nice Solution Vaibhav Sir. Regards Ashish On 12 January 2015 at 19:57, Vaibhav Joshi v

Re: $$Excel-Macros$$ Do while loop question

Nice Solution Vaibhav Sir. Regards Ashish On 12 January 2015 at 20:53, Vaibhav Joshi v...@vabs.in wrote: try this code.. Sub Test_4() Dim i As Long Dim countErr As Long countErr = 0 i = 2 For Each c In Range(A3:H6930) If c.Value 0.18 And IsNumeric(c.Value) Then Cells(c.Row,

Re: $$Excel-Macros$$ Do while loop question

Nice Solution Vaibhav Sir. Regards Ashish On 13 January 2015 at 10:37, Vaibhav Joshi v...@vabs.in wrote: try this Sub Test_4() Dim i As Long Dim countErr As Long countErr = 0 i = 2 On Error Resume Next For Each c In Range(A3:H6930) 'A2:H30 If c.Value 0.18 And IsNumeric(c.Value)

Re: $$Excel-Macros$$ Data Fetch From Particular URL

Yes, Vaibhav Joshi is the Best. 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

Re: $$Excel-Macros$$ Change date of all cells in an excel column

Superb Solution Vaibhav Bhai. -- 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

Re: $$Excel-Macros$$ Pivot Query

Hi Ashu, Check this. 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,

Re: $$Excel-Macros$$ Pivot Query

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

Re: $$Excel-Macros$$ Pivot Query

Hi Ashu, PFA.! 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,

Re: $$Excel-Macros$$ Pivot Query

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

Re: $$Excel-Macros$$ How to extract only numbers

Hi Ashu, You want resolution by VBA or formula. Reply. Regards Ashish On 23 December 2014 at 11:10, Ashu k direct2as...@gmail.com wrote: Dear Seniors, I have Data in Cell A1 like sffdsd14563jhgh85fg98cn4 in string. I want extract only Numbers and delete rest of string. It's possible.

Re: $$Excel-Macros$$ How to extract only numbers

Hi Ashu, Check this Resolved by VBA. HIT the button and select your data and press OK. 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

Re: $$Excel-Macros$$ cells.find

Hi ashakala, you want to find specific word in sheet. On 19 December 2014 at 20:40, ashakal...@gmail.com wrote: Can anyone help me with below code, Dim range1 As Range range1 = Cells.Find(what:=range) -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

Vaibhav Bhai, Superb..!! 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

Re: $$Excel-Macros$$ cells.find

Hi Ashakala, PFA 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

Re: $$Excel-Macros$$ Help required for Match DATA

Hi Ashu, Use Simple Vlookup function which is suggested by Vaibhav Sir. and Delete NA# with help of filter. It's simple. 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 @

Re: $$Excel-Macros$$ Help required for Match DATA

Hi Ashu, Check this!! 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

Re: $$Excel-Macros$$ Help required for Match DATA

Welcome Ashu. -- 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 Please Help,

Re: $$Excel-Macros$$ Distribute numbers to names

Vaibhav Bhai, SUperb Solution. 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

Re: $$Excel-Macros$$ pdf file rename

Hi Chintan, PFA 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

Re: $$Excel-Macros$$ pdf file rename

Thanks Vaibhav Bhai. On 16 December 2014 at 22:42, Vaibhav Joshi v...@vabs.in wrote: Good one ashish!! + *I did not do this for you. God is here working through me for you.* -- 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$$ pdf file rename

Welcome Chintan -- 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 Please Help,

Re: $$Excel-Macros$$ Array_concept

Hi Sam, Long Time Bro. Welcome Back...!! :) Regards Ashish On 13 December 2014 at 18:32, Sam Mathai Chacko samde...@gmail.com wrote: Mandeep, It's not like that. For that you'll need to understand how Transpose works. Try this first ;) ARR =

Re: $$Excel-Macros$$ Date query for conditional format

Hi Ashish, PFA 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

Re: $$Excel-Macros$$ Put Text Strings from Excel file to Outlook calander

Working Superb. WoW 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,

Re: $$Excel-Macros$$ Discussion

Hi Mandeep, Activate method works only on a single Cell, which much be inside the current selection and brings the cursor in that Cell. And, With the help of select method you can select any range, but does not let you define which cell has the cursor. Regards Ashish -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ How to protect only few cells

Hi Putta, Steps for Lock cells : Step 1: Select all cells in current worksheet with pressing the Ctrl key and A key together. Step 2: Right click, and select the Format Cell item from the context menu. Step 3: In the Format Cells dialog box, uncheck the Locked option under Protection tab, and

Re: $$Excel-Macros$$ How to protect only few cells

Welcome Putta. -- 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 Please Help,

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

Hi Amar, Check this :- SubJect - Copy paste data from one sheet to another based on click Query Raised in Group - 28th Nov, 2014. Status - Resolved. 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

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

Hi Amar, If it's not useful then share your requirement sheet with required output. 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

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

Hi Amar, PFA Change the Data Range according to your requirement. Don't paste the data in this Sheet. If you want to Copy range from AAA sheet to BBB, then Paste your Data in AAA and Save it on Desktop and Create a blank Sheet on Desktop named BBB. Regards Ashish -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Querry production analysis

Hi Vaibhav Bhai, It's Simple and Superb Solution. 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

Re: $$Excel-Macros$$ row data copy to next sheet

Hi Vaibhav Bhai, It's Working Superb. 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

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

me for you.* On Sat, Nov 29, 2014 at 9:49 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Joseph, PFA 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

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi Joseph, PFA 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

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi Joseph, PFA 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

Re: $$Excel-Macros$$ Changing value to percentage

Hi Chandra Shekar, Use this formula : =A1 % 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

Re: $$Excel-Macros$$ Changing value to percentage

Dear Mandeep, Are you trying this formula. 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.

Re: $$Excel-Macros$$ Changing value to percentage

Hi Mandeep, If your Data in Cell A1 then put the formula in B1. This is concatenate function. Try it...!! 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 @

Re: $$Excel-Macros$$ Need Help

Hi Chandru, PFA Regards Ashish On 24 November 2014 at 11:57, Chandru chandr...@gmail.com wrote: I need Excel formula or VBA for the following. *) To set cell width(for headers). *) To make hyper link text blue. *) Font Formatting(for headers). Regards, Chandru -- Are you

Re: $$Excel-Macros$$ Re: Need macro to copy date from excel file to another excel file

Hi Yudy, Share your data with example. Regards Ashish On Sun Nov 16 2014 at 3:37:04 PM yudy0...@gmail.com wrote: Hello , Can anyone please help me with a solution .Yudy On Friday, November 14, 2014 11:31:53 PM UTC+5:30, yudy...@gmail.com wrote: Hello , I am in need of macro to

Re: $$Excel-Macros$$ Help needed

Hi Ravinder, PFA Regards Ashish On Sun Nov 16 2014 at 5:10:24 PM Ravinder Kumar ravinderbhardwa...@gmail.com wrote: Hi All, Please help me in the attached data, please share also the way to resolve it. Regards, Ravindra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

  1   2   3   >