$$Excel-Macros$$ Required Conditional formatting

-- 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, Need Help,

Re: $$Excel-Macros$$ Sumproduct Multiple Criteria formula

Great Ankur SirExcellent On Sun, Jun 24, 2018 at 12:02 AM, ankur wrote: > hi amar takale > > *Solution is attached as per your requirement ,i have not used sumproduct* > > *May this file help you* > > > > > > *With Regards:* > > *CMA** Ankur P

Re: $$Excel-Macros$$ Exclude #N/A & Sumif excel formula

gt; delete the original message. Further, you are not to copy, disclose, or > distribute this e-mail or its contents either partly or completely. Before > opening any attachments please check them for viruses and defects." > > > On Sat, Apr 28, 2018 at 2:16 PM, amar takale wrote: > >>

Re: $$Excel-Macros$$ Date formula complicated Challengeing Required

Any Solution? On Mon, Apr 30, 2018 at 7:29 PM, amar takale <amartak...@gmail.com> wrote: > > -- > 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/discuss

Re: $$Excel-Macros$$ Exclude #N/A & Sumif excel formula

; > > > *For quick responds click here for Message <vhr.ad...@arabianfal.com>* > > On Sat, Apr 28, 2018 at 11:46 AM, amar takale <amartak...@gmail.com> > wrote: > >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It

$$Excel-Macros$$ Exclude #N/A & Sumif excel formula

-- 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, Need Help,

$$Excel-Macros$$ Re: Extract Result date as per categary

any one see this issue? On Thu, Feb 22, 2018 at 6:11 PM, amar takale <amartak...@gmail.com> wrote: > > -- 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/discuss

Re: $$Excel-Macros$$ Re: Import Data From the Web in Excel Query

?? On Thu, Feb 22, 2018 at 10:07 AM, amar takale <amartak...@gmail.com> wrote: > Thank for reply sir > > I explain my issue in excel sheet > > On Thu, Feb 22, 2018 at 6:10 AM, who <david.lanm...@gmail.com> wrote: > >> Hello, >> >> I do not see

Re: $$Excel-Macros$$ Extract Result date as per categary

any one help me On Thu, Feb 22, 2018 at 6:11 PM, amar takale <amartak...@gmail.com> wrote: > > -- > 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/d

Re: $$Excel-Macros$$ Re: Import Data From the Web in Excel Query

a for many companies. > > Is this close to what you want? > > Thanks, David > > On Wednesday, February 21, 2018 at 3:25:23 AM UTC-8, amar takale wrote: > >> >> -- > 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

$$Excel-Macros$$ Import Data From the Web in Excel Query

-- 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, Need Help,

Re: $$Excel-Macros$$ Re: Search any Specific word in all excel tabs

Thanks Genius you are really Genius person. On Sat, Feb 17, 2018 at 2:51 PM, GENIUS wrote: > See the result inside the workbook > > -- > 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

$$Excel-Macros$$ Search any Specific word in all excel tabs

Dear All I want vba code where I serach any any Specific word in all excel tabs where it is input (hidden or unhidden). Regards Amar -- 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$$ Re: Required break chart in excel

> On Fri, 16 Jun 2017 at 12:08 PM, amar takale <amartak...@gmail.com> wrote: > >> http://www.exceldashboardtemplates.com/how-to-show-gaps-in-a-line- >> chart-when-using-the-excel-na-function/ >> >> On Thu, Jun 15, 2017 at 12:53 PM, Rajan Verma <rajan

Re: $$Excel-Macros$$ Re: Required break chart in excel

esday, 6 June 2017 05:39:58 UTC-6, amar takale wrote: > >> Dear all friends >> >> I Required break chart in excel.between data if there are blank cell >> then chart show break. >> >> Actually in blank cell there are formula(yellow cell) which show blank >&g

Re: $$Excel-Macros$$ Required break chart in excel

he window that would pop up, check(tick > mark) logarithmic scale under Axis option category. You will get a break > chart in excel. > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Lead Solution Advisor > Model validation and Valuation, Deloitte US India > Gur

Re: $$Excel-Macros$$ Required break chart in excel

any ideas friends On Thu, Jun 8, 2017 at 11:51 AM, 'Storey Thomas' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: > > > On Thu, 6/8/17, amar takale <amartak...@gmail.com> wrote: > > Subject: Re: $$Ex

Re: $$Excel-Macros$$ When Excel Save then below message show

any reason for this issue? On Thu, Jun 8, 2017 at 9:47 AM, amar takale <amartak...@gmail.com> wrote: > ??? > > On Tue, Jun 6, 2017 at 4:52 PM, amar takale <amartak...@gmail.com> wrote: > >> Dear All >> >> When I save my excel then show message in attache

Re: $$Excel-Macros$$ When Excel Save then below message show

??? On Tue, Jun 6, 2017 at 4:52 PM, amar takale <amartak...@gmail.com> wrote: > Dear All > > When I save my excel then show message in attached doc screen shot,why > this message show? There are no external link in excel. > > Regards > > Amar > > -- &

Re: $$Excel-Macros$$ Required break chart in excel

Hi friends Good Morning Any Idea? On Tue, Jun 6, 2017 at 5:09 PM, amar takale <amartak...@gmail.com> wrote: > Dear all friends > > I Required break chart in excel.between data if there are blank cell then > chart show break. > > Actually in blank cell there are formula

$$Excel-Macros$$ Required break chart in excel

Dear all friends I Required break chart in excel.between data if there are blank cell then chart show break. Actually in blank cell there are formula(yellow cell) which show blank cell (If +is error+blank formula). Finally I need prepare Break chart on yellow cell data range ,Can We do this?

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > - > > > > On Tuesday, January 10, 2017 11:48 > PM,

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

ke.I've done it > before with >nearly 300 > workbooks. > > Paul----- > “Do > all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, >

$$Excel-Macros$$ Index+Match+Indirect+Address formula

Dear Friends There are more than 100 Excel Sheets (Company Name like AAB, Infy, TATA) in folder. Each Sheet there are 3 tab (Profit & loss A/C, Balalnce Sheet, Cash Flow from 10 years).I Required Separate one Output Excel sheet where I extract specific data (like Net sales, Net Profit, Share

Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template

ss > information > On Dec 29, 2016 10:04 AM, > "margaretatolliver via MS EXCEL AND VBA MACROS" > <excel-macros@googlegroups.com> > wrote: > > > -- -- > > On Thu, 12/29/16, amar takale <amartak...@gmail.com> > wrot

Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template

-macros@googlegroups.com> wrote: > >> >> ---- >> On Thu, 12/29/16, amar takale <amartak...@gmail.com> wrote: >> >> Subject: Re: $$Excel-Macros$$ CRM (Customer relationship management ) >> excel template >> To: excel-macro

Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template

Dear Paul Sir Good Morning Can you see in this matter? Regards Amar T On Thu, Dec 29, 2016 at 9:49 AM, amar takale <amartak...@gmail.com> wrote: > Dear Sir > > > > Can you send me Example excel Sheet. > > On Thu, Dec 29, 2016 at 6:52 AM, cronincarmelita vi

Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template

anagement ) excel template >To: excel-macros@googlegroups.com >Date: Wednesday, December 28, 2016, 5:57 PM > > > >On Wed, 12/28/16, amar takale <amartak...@gmail.com> >wrote: > > Subject: Re: $$Excel-

Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template

t; > Dear Friends > > Any Ides? > > On Tue, Dec 27, 2016 > at 10:02 AM, amar takale <amartak...@gmail.com> > wrote: > Dear All Friends, > > Goog Morning > > Can anyone send me CRM (Customer > relationship management ) excel template

Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template

Dear Friends Any Ides? On Tue, Dec 27, 2016 at 10:02 AM, amar takale <amartak...@gmail.com> wrote: > Dear All Friends, > > Goog Morning > > Can anyone send me CRM (Customer relationship management ) excel template > (customer discussion date by date & their follow

$$Excel-Macros$$ CRM (Customer relationship management ) excel template

Dear All Friends, Goog Morning Can anyone send me CRM (Customer relationship management ) excel template (customer discussion date by date & their follow up discussion) in excel.With the goal of improving business relationships with customers. I know this is not possible in excel due to many

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2003 please use it and let me know. i have sent > you request on hangout accept it man > > On Sat, Nov 26, 2016 at 10:56 AM, amar takale <amartak...@gmail.com> > wrote: > >> Dear Sourav >> >> Good morning >> >> but how can I create & save .xml fil

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

like this on your desktop and > the use this tool and let me know if you need any changes. > > Xml file name will be "Test.xml" > > Do Formatting in Sheet2 hehe. > > > On Fri, Nov 25, 2016 at 2:36 PM, amar takale <amartak...@gmail.com> wrote: >

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

no On Fri, Nov 25, 2016 at 11:15 AM, sourav devrani < souravdevrani1...@gmail.com> wrote: > Hi Amar any Progress > > On Fri, Nov 25, 2016 at 10:13 AM, amar takale <amartak...@gmail.com> > wrote: > >> ok >> >> >> On Fri, Nov 25, 2016 at 10:00

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

get time. I create it >> whenever i lose it. >> On 24 Nov 2016 18:18, "amar takale" <amartak...@gmail.com> wrote: >> >>> how to it? >>> >>> On Thu, Nov 24, 2016 at 6:12 PM, sourav devrani < >>> souravdevrani1...@gmail.com&

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

how to it? On Thu, Nov 24, 2016 at 6:12 PM, sourav devrani <souravdevrani1...@gmail.com > wrote: > Do one thing bro Scrap the data from Web. > > On Thu, Nov 24, 2016 at 6:09 PM, amar takale <amartak...@gmail.com> wrote: > >> See screen shot.If possible

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

se web scrapping and fetch data from web into excel and every Click of > Button your data will be refreshed accordingly your web data. > > On Wed, Nov 23, 2016 at 11:26 AM, Kush Shama <kushleshsha...@gmail.com> > wrote: > >> Use import wizard. Select web query and pas

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

On Mon, Nov 21, 2016 at 10:00 AM, amar takale <amartak...@gmail.com> wrote: > Any experts help me on this issue? > > On Fri, Nov 18, 2016 at 12:57 PM, amar takale <amartak...@gmail.com> > wrote: > >> I want update below link excel.All data show in excel like

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

Any experts help me on this issue? On Fri, Nov 18, 2016 at 12:57 PM, amar takale <amartak...@gmail.com> wrote: > I want update below link excel.All data show in excel like in website & > update data after click refresh button > > https://www.nse-india.com/live_market/dyn

$$Excel-Macros$$ Required VBA Code update NSE website data in excel

I want update below link excel.All data show in excel like in website & update data after click refresh button https://www.nse-india.com/live_market/dynaContent/live_watch/equities_stock_watch.htm Is it possible in excel Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

<schreiner_p...@att.net> wrote: > > *See answers below:* > > > On Friday, November 4, 2016 2:00 AM, amar takale <amartak...@gmail.com> > wrote: > > > Dear Paul Sir, > > This is fabulous work! > I think this must be flashing on the front page! :D. And I am Ex

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

ok. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* >

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

Dear Hilary sir pls look into this matter. Also from Paul sir expect lot. On Mon, Oct 24, 2016 at 5:42 PM, amar takale <amartak...@gmail.com> wrote: > Dear Sir > > Thanks for reply.but my requirement not this way (And I am use excel > 2003). I want to search any string from

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

data Regards Amar On Mon, Oct 24, 2016 at 4:18 PM, Hilary Lomotey <resp...@gmail.com> wrote: > See attached, HTH. Cheers > > On Mon, Oct 24, 2016 at 5:35 AM, amar takale <amartak...@gmail.com> wrote: > >> Dear Friends >> any one help me on this issue >> &g

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

Dear Friends any one help me on this issue On Fri, Oct 21, 2016 at 12:09 PM, amar takale <amartak...@gmail.com> wrote: > > -- > 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 @ > htt

Re: $$Excel-Macros$$ Re: top 3 & bottom 3 value

Array formula press (Ctrl+Shift+enter) ={LARGE($A$2:$A$21,{1;2;3;4;5})} On Tue, Apr 19, 2016 at 3:50 PM, amar takale <amartak...@gmail.com> wrote: > use this formula > > =LARGE($A$2:$A$21,{1;2;3;4;5}) > > On Tue, Apr 19, 2016 at 3:21 PM, Rajesh Agarwal <rajey...@gmail

Re: $$Excel-Macros$$ Re: top 3 & bottom 3 value

use this formula =LARGE($A$2:$A$21,{1;2;3;4;5}) On Tue, Apr 19, 2016 at 3:21 PM, Rajesh Agarwal wrote: > Dear Sir > > Required formula for top 3 unique value & bottom 3 unique value excluding > "Zero". > > On Sun, Apr 17, 2016 at 7:06 PM, Rajesh Agarwal

Re: $$Excel-Macros$$ If Condition formula required

> > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ---

Re: $$Excel-Macros$$ Edit Logo possible?

se see a sample attached. Under the Format tab, you can change it as > you may like, including the text. > > HTH > > On Wed, Mar 2, 2016 at 10:25 AM, amar takale <amartak...@gmail.com> wrote: > >> Dear Paul Sir >> >> I was trying every method as per my knowle

Re: $$Excel-Macros$$ If Condition formula required

Dear Paul Sir Pls look into this topic.I think we will use (If+Search) formula but I cant possible how to modified it. Regards Amar On Mon, Feb 29, 2016 at 7:49 PM, amar takale <amartak...@gmail.com> wrote: > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Edit Logo possible?

> > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Tue

$$Excel-Macros$$ Edit Logo possible?

Dear Friends This possible to edit this logo bcos I like this to rename my excel sheet name. Regards Amar -- 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

$$Excel-Macros$$ If Condition formula required

-- 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, Need Help,

Re: $$Excel-Macros$$ If formula Required

the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Wednesday, February 24, 2016 4:46 AM, amar takale <amartak...@gmail.com> > wrote: > > > &

Re: $$Excel-Macros$$ If formula Required

an.” - John Wesley* > ----- > > > On Tuesday, February 23, 2016 8:30 AM, amar takale <amartak...@gmail.com> > wrote: > > > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N

$$Excel-Macros$$ If formula Required

-- 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, Need Help,

Re: $$Excel-Macros$$ Re: VBA Code for Create Name Range

Dear Mandeep pls help me on this issue On Fri, Feb 19, 2016 at 6:33 PM, amar takale <amartak...@gmail.com> wrote: > Pls look in this issue > > -- Forwarded message -- > From: amar takale <amartak...@gmail.com> > Date: Thu, Feb 18, 2016 at 5:55 PM &g

Re: $$Excel-Macros$$ Re: VBA Code for Create Name Range

Dear All,pls guide me above issue & How many name range we kept in excel,there are any limitation? On Wed, Feb 17, 2016 at 2:14 PM, amar takale <amartak...@gmail.com> wrote: > Dear Mandeep,I want also VBA Code create unique sector name range in sheet > > On Tue, Feb 16, 20

Re: $$Excel-Macros$$ Re: VBA Code for Create Name Range

Dear Mandeep,I want also VBA Code create unique sector name range in sheet On Tue, Feb 16, 2016 at 5:38 PM, amar takale <amartak...@gmail.com> wrote: > Dear Mandeep Sir, > > Hi,I have small issue in this matter (all is OK in sheet as per my mind) > but when code create name r

Re: $$Excel-Macros$$ Re: VBA Code for Create Name Range

l create name range through data validation. Another small request can we extract unique sector name in column A in output sheet & then from B column code work as previous. Regards Amar On Mon, Jan 25, 2016 at 6:32 PM, amar takale <amartak...@gmail.com> wrote: > Dear M

Re: $$Excel-Macros$$ Date formula for Age Calculation

Dear Mandeep Very Helpful and thanks providing this helpful knowledge regarding date solution. And Thank you very much for all Regards Amar On Mon, Feb 8, 2016 at 3:06 PM, Mandeep baluja wrote: > Hey Amar, >> > > While doing manipulations with date you must

Re: $$Excel-Macros$$ Date formula for Age Calculation

Dear all thanks for reply but i cant understand what you say.I except only date formula in column D. On Sun, Feb 7, 2016 at 9:36 PM, GENIUS wrote: > LOOK AT THE ATTACHMENT > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

$$Excel-Macros$$ Date formula for Age Calculation

Dear All Here I required Date formula for Age Calculation but in cell date there are some issue Value or text cell format,I cant understand. pls look matter,i try it helper column but some date issue again. Pls provide Date formula without helper column Regards Amar -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Re: VBA Code for Create Name Range

Dear Mandeep sir, Suprb.. Thank you all for your help. I greatly appreciated it Regards Amar On Mon, Jan 25, 2016 at 1:24 PM, Mandeep Baluja wrote: > Check this out !!! Regards, Mandeep baluja >> https://www.linkedin.com/messaging/thread/6086488646137958400 > >

Re: $$Excel-Macros$$ Re: Search specific text or numbers in excel folder

Dear Mandeep Sir Wow. Perfect,You are done it……… I am really thankful for its wonderful VBA Coding. Sorry for late reply due to heavy workload. It's Great output for this Group. Regards Amar On Tue, Jan 19, 2016 at 4:51 PM, Mandeep Baluja wrote: > Check

$$Excel-Macros$$ Search specific text or numbers in excel folder

Dear All experts team, Good morning! Question: how to search specific text or numbers in excel folder. I have folder where there are a lot of excel sheet ( more than 100) & I have to search specific text or numbers in all excel from that folder.If I search specific text or numbers through VBA

Re: $$Excel-Macros$$ Re: Search specific text or numbers in excel folder

heet it is in kept.if I will search then all sheet will be open one by one & a lot of time waste.Through VBA Code I search that number or word excel sheet directly So a lot of time save for me.thats it. Regards Amar Takale On Tue, Jan 19, 2016 at 11:39 AM, Mandeep Baluja <rockerna...@gmail

Re: $$Excel-Macros$$ Re: Sorting Positive & negative numbers rows

Exactly ,continuous positive growth means all arrows should move upwards after click Positive Button & same for negative. On Mon, Dec 7, 2015 at 2:24 PM, Mandeep Baluja wrote: > How to judge the negative trend, I can't see any value which is negative >> here, What pattern

Re: $$Excel-Macros$$ Re: Sorting Positive & negative numbers rows

Dear Mandeep sir I required output is same as you send exact i want. I say you there are need k sheet for criteria(more & less than 0)? if we give this criteria in code then it is ok or not? Regards amar On Mon, Dec 7, 2015 at 3:45 PM, Mandeep Baluja wrote: > Find the

Re: $$Excel-Macros$$ Re: Sorting Positive & negative numbers rows

Dear Mandeep thank for reply,can you give me this sheet after adjust this code in one module On Mon, Dec 7, 2015 at 5:38 PM, Mandeep Baluja wrote: > Hi Amar, > > There are many ways to do it, it depends on you what you're looking for > ,This can be achieved with the help

$$Excel-Macros$$ Sorting Positive & negative numbers rows

Dear All Here I want VBA code for sorting Positive & Negative numbers (%) Criteria Match like: J to P Column Collect all cell Positive growth (%) J to P Column Collect all cell Negative growth (%) If I click Positive tab then all positive growth rows sort one click, same as negative

$$Excel-Macros$$ Latest Value date extract formula required

PFA -- 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, Need

Re: $$Excel-Macros$$ Re: Latest Value date extract formula required

On Tuesday, June 30, 2015 at 12:58:29 PM UTC+5:30, amar takale wrote: PFA -- 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: Latest Value date extract formula required

is different. which i had mentioned in excel sheet *Regards, Kumar Bhanushali* *Re: $$Excel-Macros$$ Re: Latest Value date extract formula required* *amar takale * to: excel-macros 30-06-15 05:44 PM Sent by: *excel-macros@googlegroups.com excel-macros@googlegroups.com* From

Re: $$Excel-Macros$$ Re: Latest Value date extract formula required

/profile/view?id=312532939 On Tuesday, June 30, 2015 at 12:58:29 PM UTC+5:30, amar takale wrote: PFA -- 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$$ Add All field in data validation,any possibility?

: This is for you bro.., do post query in following for further doubts... ExcelVbaLab.com Cheers!! ExcelVbaLab.com On Sat, Jun 20, 2015 at 3:03 PM, amar takale amartak...@gmail.com wrote: PFA -- 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

$$Excel-Macros$$ Add All field in data validation,any possibility?

PFA -- 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, Need

Re: $$Excel-Macros$$ Dynamic chart between data range

, Feb 23, 2015 at 12:10 PM, amar takale amart...@gmail.com wrote: Dear experts I want to update chart as per date change in cell I3 J3.means between date range. i think it done by offset formula through name range. pls guide me Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ Excel Tip

thanks vaibhavji On Sat, Feb 28, 2015 at 11:35 AM, Pol Ktk polkarnat...@gmail.com wrote: very nice easy solution On 23 February 2015 at 20:36, Vaibhav Joshi v...@vabs.in wrote: Convert all date in same format: While receiving data from different sources many time it happens that data

Re: $$Excel-Macros$$ Excel Tip

PFA On Fri, Feb 27, 2015 at 6:21 PM, amar takale amartak...@gmail.com wrote: Dear Sourab How to do it in one attempt only *1 in column B.When I extract date from our database software then paste it one excel then I do *1 to all date but answer is Value,why? Regards Amar On Thu, Feb 26

Re: $$Excel-Macros$$ Excel Tip

TRICK VAIBHAV WORKING PERFECTLY On Thu, Feb 26, 2015 at 12:01 PM, amar takale amartak...@gmail.com wrote: pls look sheet where sheetl1 not change as per you saying. Pls explain me On Thu, Feb 26, 2015 at 10:58 AM, Vaibhav Joshi v...@vabs.in wrote: Dear Amar Data in col b date only, you

Re: $$Excel-Macros$$ Excel Tip

25, 2015 at 5:11 PM, amar takale amartak...@gmail.com wrote: Dear Vabs bro thanks very much for this knowledgeable trick. I discuss here attached file for date issue not converted in same format as per your trick,why? i always use text to column operation trick for same format. On Wed, Feb 25

Re: $$Excel-Macros$$ Excel Tip

Dear Vabs bro thanks very much for this knowledgeable trick. I discuss here attached file for date issue not converted in same format as per your trick,why? i always use text to column operation trick for same format. On Wed, Feb 25, 2015 at 3:46 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers

Re: $$Excel-Macros$$ Dynamic chart between data range

Can any body help me On Mon, Feb 23, 2015 at 12:10 PM, amar takale amartak...@gmail.com wrote: Dear experts I want to update chart as per date change in cell I3 J3.means between date range. i think it done by offset formula through name range. pls guide me Regards Amar -- Are you

$$Excel-Macros$$ Dynamic chart between data range

Dear experts I want to update chart as per date change in cell I3 J3.means between date range. i think it done by offset formula through name range. pls guide me Regards Amar -- 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$$ Change or destroy word page setup through VBA code

Dear Experts Pls tell me solution. On Tue, Jan 20, 2015 at 10:59 AM, amar takale amartak...@gmail.com wrote: any solution? On Mon, Jan 19, 2015 at 4:24 PM, amar takale amartak...@gmail.com wrote: Dear Experts Can anybody tell me why this word not change its pagesetp format. We can change

Re: $$Excel-Macros$$ Change or destroy word page setup through VBA code

any solution? On Mon, Jan 19, 2015 at 4:24 PM, amar takale amartak...@gmail.com wrote: Dear Experts Can anybody tell me why this word not change its pagesetp format. We can change word page setup through VBA code OR destroy this word file page setup through VBA code. Regards Amar

$$Excel-Macros$$ Change or destroy word page setup through VBA code

Dear Experts Can anybody tell me why this word not change its pagesetp format. We can change word page setup through VBA code OR destroy this word file page setup through VBA code. Regards Amar -- 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) !

Re: $$Excel-Macros$$ Happy New 2015

Dear all my excel master friends Wishing you a fabulous 2015 with full of great achievements and experiences Regards Amar On Thu, Jan 1, 2015 at 12:13 PM, Sandeep Sharma sandeepsharma4...@gmail.com wrote: Welcome and wish u Happy new year all Group members. With Regards Sandeep Kumar

Re: $$Excel-Macros$$ Complex formula Solution

:44 PM, amar takale amartak...@gmail.com wrote: Dear experts team, I required formula to extract data as par my criteria but it is very complex criteria but my thought is that everything is possible in excel. Appreciate the help. Let us know in case of any further assistance. Regards Amar

Re: $$Excel-Macros$$ Re: small issue

Dear zafar PFA On Thu, Dec 25, 2014 at 5:17 PM, Zafar Iqbal ziqba...@gmail.com wrote: Format of B5:D5 is TEXT and B7:D7 is General. If Both rows will have same formats then you will get same answer visa vera. On Wednesday, December 24, 2014 2:50:56 PM UTC+3, amar takale wrote

Re: $$Excel-Macros$$ Re: small issue

?ref=hl On Wednesday, December 24, 2014 5:20:56 PM UTC+5:30, amar takale wrote: -- 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

$$Excel-Macros$$ small issue

-- 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, Need Help,

$$Excel-Macros$$ Complex formula Solution

Dear experts team, I required formula to extract data as par my criteria but it is very complex criteria but my thought is that everything is possible in excel. Appreciate the help. Let us know in case of any further assistance. Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

$$Excel-Macros$$ Wish u all A Merry Christmas

Dear All our experts members, Wish u all A Merry Christmas May the Joys of the season Fill your heart with goodwill and cheer. May the chimes of Christmas glory Add up more shine and spread Smiles across the miles Today In the New Year. Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

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

ashish this is not useful for me On Tue, Dec 2, 2014 at 2:01 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: 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 --

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

://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Tuesday, December 2, 2014 1:01:46 PM UTC+5:30, amar takale wrote: Dear all Pls suggest me VBA code for move or copy define name range one sheet to another sheet.Then it is helpful time saving for me

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

Dear all Pls suggest me VBA code for move or copy define name range one sheet to another sheet.Then it is helpful time saving for me. Regards Amar -- 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$$ Re: hyperlink issue for fixed cell

Baluja On Wednesday, November 19, 2014 10:24:36 AM UTC+5:30, amar takale wrote: Dear All friends Pls solve my hyperlink issue. If I give hyperlink for specific cell through button (Here text box) in row in same sheet or different sheet then jump on that cell perfectly but issue is that if i add

$$Excel-Macros$$ hyperlink issue for fixed cell

Dear All friends Pls solve my hyperlink issue. If I give hyperlink for specific cell through button (Here text box) in row in same sheet or different sheet then jump on that cell perfectly but issue is that if i add rows in sheet then hyperlink link change that specific cell. I required fixed

  1   2   3   4   5   >