Re: $$Excel-Macros$$ Conditional formatting issue

PFA On Wed, Mar 7, 2018 at 5:08 PM, vikas khen wrote: > Hi All, > > Request all of you to kindly help me on the attached sheet. > > > I need conditional formatting for based on following two conditions > > 1) If the Actual date is less than or equal to Projected date it

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

Hi Amar are you there? On Fri, Feb 23, 2018 at 4:57 PM, amar takale wrote: > ?? > > On Thu, Feb 22, 2018 at 10:07 AM, amar takale > wrote: > >> Thank for reply sir >> >> I explain my issue in excel sheet >> >> On Thu, Feb 22, 2018 at 6:10 AM, who

Re: $$Excel-Macros$$ Re: Formatting Output of Numbers for Printing to File

You can use this. Application.WorksheetFunction.RoundUp(VarArray(LngR, 1), 2) On Sun, Feb 25, 2018 at 5:51 AM, who wrote: > I typed your numbers into a sheet and it automatically formatted as you > have displayed. I checked the format, right clicked into cell and

$$Excel-Macros$$ Data validation Query

Hey Champs Please see my data validation query. and please let me know when you solved it. -- 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

$$Excel-Macros$$ Crack workbook password

Hi guys i have a password protected workbook but i lost my workbook password can anybody tell me how to unlock mu password protected workbook. also i'm sharing my password protected workbook. Regards Sourav Devrani -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Organizational Graphs

Need Help. On Mon, Mar 27, 2017 at 3:40 PM, sourav devrani <souravdevrani1...@gmail.com > wrote: > Hey Folks, > > Please assist me how to create organization chart in excel using VBA. > Need help. > > Also i'm attaching one Snapshot with this mail. > > Regards >

$$Excel-Macros$$ Organizational Graphs

Hey Folks, Please assist me how to create organization chart in excel using VBA. Need help. Also i'm attaching one Snapshot with this mail. Regards Sourav Devrani -- 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

$$Excel-Macros$$ ORG Graphs Using Excel VBA

Hi Guys, I'm creating Org Graphs using Excel VBA but I don't know how to do it. Need your help. Regards Sourav Devrani -- 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

Re: $$Excel-Macros$$ Bell Curve Chart

Thanks Devendra dada :) On Mon, Jan 30, 2017 at 6:18 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Saurav, > > Please check this tutorial. > https://www.youtube.com/watch?v=_PqnDYMO3lw > > On Mon, Jan 30, 2017 at 12:12 PM, sourav devrani < > sour

$$Excel-Macros$$ Bell Curve Chart

Hi Guys, I want to create " Bell Curve Chart " in excel but i don't know how to create this chart and logic behind this. Can you please suggest me how to create. Regards Sourav Devrani -- 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$$ How to hide close button in excel userform using VBA code.

Hey Guys, How to hide close button in excel userform using VBA code. please see the attached snapshot and give me the solution. Thanks & Regards Sourav Devrani -- 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$$ Some changes required

you can also use this file On Thu, Dec 29, 2016 at 11:48 AM, Izhar wrote: > When i run this macro it does not create 27 sheets instead only 7 or 8 and > also shows a message box, can anyone please make the the changes where > required > Thanks in advance > > > -- > Are you

Re: $$Excel-Macros$$ required help for attached file

Sorry sir didn't get your Query On Sat, Dec 3, 2016 at 11:41 AM, jitendra kumar wrote: > Hi Team, > > Please help in this attached file format. > > > > > *Regards,* > > *Jitendra Yadav + 91 9650449202* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Count of blank cells conditions to non empty another cells

Hi Nikkipram Please share some dummy data. On Tue, Nov 22, 2016 at 12:34 AM, Nikkipram wrote: > Hi all, > I have a mis containing the payment details of the invoices > > Column a multiple lines with pro duct details > Column b with invoice value(same value against each

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

Yo man.hehe On Sat, Nov 26, 2016 at 11:27 AM, amar takale <amartak...@gmail.com> wrote: > Dear Sourav Sir > > Done! > > You are Rock Sir,Excellent Work. > > Many Many Thanks Again. > > Regards > Amar > > On Sat, Nov 26, 2016 at 11:08 AM, sourav devr

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

t; > but how can I create & save .xml file on desktop.I use excel 2003.Then > where I create & how it possible. > > Regards > Amar > > On Fri, Nov 25, 2016 at 4:03 PM, sourav devrani < > souravdevrani1...@gmail.com> wrote: > >> keep one Xml file [image: I

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

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

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

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 AM, sourav devrani < > souravdevrani1...@gmail.com> wrote: > >> i'll create one macro for you. >> >> On Thu, N

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

.@gmail.com> wrote: > >> 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 <

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

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 you also try why it show like that. > > On Thu, Nov 24, 2016 at 12:47 PM, sourav devrani < > souravdevrani1...@gmail.com>

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

ta. > > Regards > Amar > > On Wed, Nov 23, 2016 at 11:37 AM, sourav devrani < > souravdevrani1...@gmail.com> wrote: > >> in this case if you want to update data on every click you will have to >> use web scrapping and fetch data from web into excel and every Cl

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

in this case if you want to update data on every click you will have to use 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 wrote: > Use

Re: $$Excel-Macros$$ Query

Please have a look On Thu, Oct 27, 2016 at 4:41 AM, Kal xcel wrote: > Dear Experts, > > Please help me to solve the query. > > -- > *Kalyan Chattopadhyay* > > > *Executive Corporate MIS* > > *Joy Cosmetics* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ changes required in the attach macro

On Wed, Oct 26, 2016 at 9:57 AM, Izhar wrote: > in the attach macro i need the name in column A of CONSOLIDATION sheet, > when i run this macro it takes the figures and cosolidate it but the names > are not shown in front of the figures in the CONSOLIDATION sheet, can >

Re: $$Excel-Macros$$ need a urgent help

can you give one sample On Thu, Oct 13, 2016 at 5:28 AM, Brajesh Shrivastava wrote: > Hello Experts, > > I need a VBA coding for some data in my excel sheet column A i.e. hospital > names for which i have to search address and contact detail and to get > update in my

Re: $$Excel-Macros$$ Need Help in VBA

Use this Man Sub SplitTest() Dim VarArrayAs Variant Dim LngRAs Long Dim LngCAs Long Dim LngIndexAs Long Dim VaresultAs Variant LngIndex = 1 VarArray = Intersect(Sheet2.Range("A1").CurrentRegion, Sheet2.Range("A1").CurrentRegion.Offset(1))

Re: $$Excel-Macros$$ Re: Reporting Format

use this =SUM(VALUE(U18:U71)) On Thu, Sep 29, 2016 at 10:07 PM, N. Madhan wrote: > > HI > > can you see the sheet1 see the convert to number then =sum() > > > > > On Thursday, September 1, 2016 at 11:21:24 PM UTC+5:30, khagesh khera > wrote: >> >> Hi, >> >> Required

$$Excel-Macros$$ Excel formula Problem

Hi guys please help Regards Sourav Devrani -- 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$$ Formula Problem

Thanks for reply sir but if i'm not using any helping column then. On Fri, Aug 12, 2016 at 2:02 AM, Murali Nagarajan <muralin...@gmail.com> wrote: > Dear Sourav, > > I hope you are doing great. > > Regards > N.Murali > > On Thu, Aug 11, 2016 at 6:41 PM, sou

$$Excel-Macros$$ Formula Problem

Hey guys, I need your help. Please see the attached file. Regards Sourav Devrani -- 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$$ Re: Using Small Formula

; > > > On Monday, August 8, 2016 at 7:03:25 PM UTC+5:30, sourav devrani wrote: >> >> A >> >> B >> >> C >> >> D >> >> How to small these values using Small Formula. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Using Small Formula

trl+Shift+Enter > =OFFSET($A$1,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20)-1,""),ROW(A1)),0) > Press Ctrl+Shift+Enter > > See attachment for more clarity... > > > > > On Tue, Aug 9, 2016 at 5:48 PM, sourav devrani < > souravdevrani1...@gmail.com>

Re: $$Excel-Macros$$ Using Small Formula

Hi Abhishek, [image: Inline image 1] On Mon, Aug 8, 2016 at 12:50 PM, Abhishek Jain <abhishek@gmail.com> wrote: > =lower(a1) > > A1 is your first value, then you can drag. > > On Monday, August 8, 2016, sourav devrani <souravdevrani1...@gmail.com> > wrote:

Re: $$Excel-Macros$$ Re: Extract Text that begins with L

Please see the attached file. Regards Sourav Devrani On Tue, Jul 19, 2016 at 11:43 PM, सचिन शर्मा <sachin.bairagi@gmail.com> wrote: > Please check > > Cash paid to L986529 - RAMESH KUMAR K > EMP ID > L986529 > > >- =MID(B2,FIND("L",B2),

Re: $$Excel-Macros$$ Vlookup Sensitive Case

Hi Sachin you can also use this one. Regards Sourav Devrani On Mon, Aug 8, 2016 at 12:24 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Sachin, > > You can also try this one- =SUMPRODUCT(EXACT($F$4,$B$5:$B$11) * > ($C$5:$C$11)) > > Please change the ref.

$$Excel-Macros$$ Using Small Formula

A B C D How to small these values using Small 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.

Re: $$Excel-Macros$$ Please help me

please use this file. i have change some little formula here you can use this file. Regards Sourav Devrani On Wed, Aug 3, 2016 at 7:10 AM, sourav devrani <souravdevrani1...@gmail.com> wrote: > please see the attached file. > > On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barma

Re: $$Excel-Macros$$ Please help me

please see the attached file. On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman wrote: > Is there any one who can solve this, please ? > > On Aug 2, 2016 23:38, "Jayanta Barman" wrote: > >> Hello Excel experts, >> >> I have a small problem in

Re: $$Excel-Macros$$ Help for if condition....

Here you go. On Fri, Jul 22, 2016 at 12:47 AM, Mustapha LMIDMANI < lmidmani.musta...@gmail.com> wrote: > Hello, > > Please check this ? is what do you want? > > 2016-07-22 8:42 GMT+01:00 Neeraj Pal : > >> Hi All, >> >> Please solve my if condition >> >> --

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

[?][?][?][?][?][?][?][?] [?][?][?][?][?][?][?][?] Merry Christmas On Wed, Dec 24, 2014 at 7:41 PM, Vaibhav Joshi v...@vabs.in wrote: Merry X'Mas to All..Happy holidayz [image: Inline image 1] Cheers!! + *I did not do this for you. God is here working through me for you.* On