$$Excel-Macros$$ Query on lookup with more than 1 lookup values

-- Hi All, I am trying to apply lookup in 2 dimensions wherein I have to get the value as per 2 lookup values (1 is there in the row and another in the column). I am attaching the workbook in which I am looking for the desired result. Please let me know if someone can help on this. [image: image.p

$$Excel-Macros$$ Query Question with Excel Stock File

I am working on creating an Excel file that will pull data from barcharts.com for stocks listed in this Excel file and what I'm trying to have it do is automatically show if it's a "sell", "strong sell", "buy", "strong buy", "weak buy", etc. and then either say that like it already does in colu

Re: $$Excel-Macros$$ Query 3

Hi Kalyan, PFA the file updated with formula . I use index and Match Function to get the results. thanks, Sarva Thanks & Regards, *Saravanan Raju* Mob: +91 8807708842 +91 9449716334 On Tue, Nov 15, 2016 at 4:24 PM, Kal xcel wrote: > Dear Experts, > > Please help me to solve this qu

$$Excel-Macros$$ Query 3

Dear Experts, Please help me to solve this query. Thanks in advance -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- 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$$ 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 wanna be? It’s > =TIM

$$Excel-Macros$$ Query

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 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/disc

Re: $$Excel-Macros$$ Query

Thank you Sanjeev for solving my query. On Mon, Sep 19, 2016 at 5:32 PM, Sanjeev Tyagi wrote: > Dear Kalyan, > > Pls see the formula below. I hope it helps. > > =ABS(TRIM(MID(A2,SEARCH("gX",A2,1)-3,3)))&"g" > > Regards > Sanjeev Tyagi > > On Mon, Sep 19, 2016 at 4:47 PM, Kal xcel wrote: > >> De

Re: $$Excel-Macros$$ Query

Dear Kalyan, Pls see the formula below. I hope it helps. =ABS(TRIM(MID(A2,SEARCH("gX",A2,1)-3,3)))&"g" Regards Sanjeev Tyagi On Mon, Sep 19, 2016 at 4:47 PM, Kal xcel wrote: > Dear Experts, > > Please help me to solve the query > > Thanks in advance > > -- > *Kalyan Chattopadhyay* > > > *Exec

$$Excel-Macros$$ Query

Dear Experts, Please help me to solve the query Thanks in advance -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- 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

Re: $$Excel-Macros$$ Query on formula

Wow.Ashish, After a long time You are still in this group.Helping peopleGr8 yaar How are you?? Where are you now?? Thanks a lot brother...Formula working perfectly On Fri, Sep 16, 2016 at 9:57 PM, Ashish Koul wrote: > =IF(COUNTIFS($A:$A,$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N

Re: $$Excel-Macros$$ Query on formula

Welcome back Ashish!.😉 -- On Fri, Sep 16, 2016 at 9:57 PM, Ashish Koul wrote: > =IF(COUNTIFS($A:$A,$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N") > > On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel wrote: > >> Dear Experts, >> >> Please help me to solve the attached query. >> >> -- >> *Kalyan Chattopadhyay* >>

Re: $$Excel-Macros$$ Query on formula

=IF(COUNTIFS($A:$A,$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N") On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel wrote: > Dear Experts, > > Please help me to solve the attached query. > > -- > *Kalyan Chattopadhyay* > > > *Executive Corporate MIS* > > *Joy Cosmetics* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT

$$Excel-Macros$$ Query on formula

Dear Experts, Please help me to solve the attached query. -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- 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

Re: $$Excel-Macros$$ Query !!!

Hi Sachin, use below excel function. =LOOKUP("ZZZ",$M$3:M3)&N3 thanks satendra On Tue, Aug 16, 2016 at 2:10 PM, सचिन शर्मा wrote: > Dear All, > > > Please help to resolve below query. > > > Share the function to get the same result which in yellow cells > > ** without any supporting columns.

$$Excel-Macros$$ Query !!!

Dear All, Please help to resolve below query. Share the function to get the same result which in yellow cells ** without any supporting columns. *Thanks and R

Re: $$Excel-Macros$$ Query

PFA & Confirm On Thu, May 5, 2016 at 2:54 PM, wrote: > Hello > > 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,

$$Excel-Macros$$ Query

Hello 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, Ne

Re: $$Excel-Macros$$ Query regarding auto hide rows in excell

http://www.techrepublic.com/blog/windows-and-office/excels-auto-outline-quickly-hides-data-details-to-simplify-viewing/ go to the above url or watch the following url on youtube https://www.youtube.com/watch?v=8j6KX6WDgEM -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Query regarding auto hide rows in excell

Did anybody knows the answer On Tue, Mar 22, 2016 at 3:32 PM, Muhammad Arslan wrote: > Hi > Hope you are doing well. I have query regarding auto hide of rows in > excell, sample file is attached in this mail. If anybody knows how it > works, kindly teach me. This file is a exported file from an

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

Thanks AshishI was making mistake while freezing the cells. Thanks for the support. Regards, Pooja On 21 Mar 2016 19:58, "Ashish Koul" wrote: > see attachment > > On Mon, Mar 21, 2016 at 7:54 PM, Pooja Sharma > wrote: > >> Hi Ashish, >> >> This is not working.It is giving 0 value. >> >> Re

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

see attachment On Mon, Mar 21, 2016 at 7:54 PM, Pooja Sharma wrote: > Hi Ashish, > > This is not working.It is giving 0 value. > > Regards, > Pooja Sharma > On 21 Mar 2016 19:30, "Ashish Koul" wrote: > >> =VLOOKUP($A16,$A$2:$H$10,MATCH(B$15,$A$2:$H$2,0),0) >> >> On Mon, Mar 21, 2016 at 7:27 PM,

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

Hi Ashish, This is not working.It is giving 0 value. Regards, Pooja Sharma On 21 Mar 2016 19:30, "Ashish Koul" wrote: > =VLOOKUP($A16,$A$2:$H$10,MATCH(B$15,$A$2:$H$2,0),0) > > On Mon, Mar 21, 2016 at 7:27 PM, Pooja Sharma > wrote: > >> Hi All, >> >> Hi All, >> >> I have a query, if there is an

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

=VLOOKUP($A16,$A$2:$H$10,MATCH(B$15,$A$2:$H$2,0),0) On Mon, Mar 21, 2016 at 7:27 PM, Pooja Sharma wrote: > Hi All, > > Hi All, > > I have a query, if there is any possibility to apply Vlookup and Hlookup > together to achieve results as required in the attached sheet. > > Regards, > Pooja Sharma

$$Excel-Macros$$ query on usage of Vlookup and Hlookup together

Hi All, Hi All, I have a query, if there is any possibility to apply Vlookup and Hlookup together to achieve results as required in the attached sheet. Regards, Pooja Sharma -- 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 Facebo

Re: $$Excel-Macros$$ Query for Excel

From: Mandeep Baluja To: MS EXCEL AND VBA MACROS Cc: schreiner_p...@att.net Sent: Monday, November 9, 2015 8:12 AM Subject: Re: $$Excel-Macros$$ Query for Excel Thanks Paul :)  The thing I am already aware about workbook_open event I was just  trying to know is there any property in

Re: $$Excel-Macros$$ Query for Paul

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* > - > > -- > *From:* Mandeep Baluja > > *To:* MS EXCEL AND

Re: $$Excel-Macros$$ Query for Excel

> > *“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$$ Query for Excel

BA MACROS Sent: Monday, November 9, 2015 4:49 AM Subject: $$Excel-Macros$$ Query for Excel I want to run a VBA macro AFTER the workbook has finished opening. I don't want to use application.ontime method to wait, I just want to run my macro only when workbook is completely loaded. Sa

Re: $$Excel-Macros$$ Query for Paul

-- From: Mandeep Baluja To: MS EXCEL AND VBA MACROS Sent: Monday, November 9, 2015 5:22 AM Subject: $$Excel-Macros$$ Query for Paul Hi Paul, I need your Suggestion Basically I have a master file having Approx 90,000 Orders no in this Sheet. From 5 Files I need to fetch the Data

$$Excel-Macros$$ Query for Paul

Hi Paul, I need your Suggestion Basically I have a master file having Approx 90,000 Orders no in this Sheet. From 5 Files I need to fetch the Data Corresponding to that Orders nos Ya Columns value, Each file has specific data related to master Orders nos, Manual Vlookup i can use I know that to

$$Excel-Macros$$ Query for Excel

I want to run a VBA macro AFTER the workbook has finished opening. I don't want to use application.ontime method to wait, I just want to run my macro only when workbook is completely loaded. Same as like Do Until IE.readyState = 4 DoEventsLoop Regards, Mandeep baluja -- Are you =EXP

RE: $$Excel-Macros$$ Query for Code

-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query for Code Also, based on your statement:"in the summary sheet we want to see total of all centres based on the month of selection which is a respective start date" implies that, if you have 30 centres:let's say 10 started in May

Re: $$Excel-Macros$$ Query for Code

can, As long as ever you can.” - John Wesley - From: gargee singh To: "excel-macros@googlegroups.com" Sent: Tuesday, July 28, 2015 1:05 AM Subject: RE: $$Excel-Macros$$ Query for Code Dear Paul, Good morning and Thank you for the repl

Re: $$Excel-Macros$$ Query for Code

ohn Wesley - From: gargee singh To: "excel-macros@googlegroups.com" Sent: Tuesday, July 28, 2015 1:05 AM Subject: RE: $$Excel-Macros$$ Query for Code Dear Paul, Good morning and Thank you for the reply. I will try and explain this in a better way. If a user se

RE: $$Excel-Macros$$ Query for Code

: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query for Code So, you're saying that if you select May 1, 2016 on the Summary Sheet,only the column for May 1, 2016 on the Summary sheet (column "G") will be populated?and it will be a sum of all sheets in which the first

Re: $$Excel-Macros$$ Query for Code

To all the people you can, As long as ever you can.” - John Wesley - From: gargee singh To: "excel-macros@googlegroups.com" Sent: Monday, July 27, 2015 8:01 AM Subject: $$Excel-Macros$$ Query for Code   Notes :- The workboo

$$Excel-Macros$$ Query for Code

Notes :- The workbook will contain close to 200 individual sheets and one summary sheet. The data in the summary sheet will be given to me by individual teams and I will need to look at the summary sheet. Requirements :- ns-serif" size="2" style="font-size:10pt;" color="#00">

Re: $$Excel-Macros$$ Query in VBA

Hi Soumyendu, PDF -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sat, Jul 11, 2015 at 8:48 AM, Soumyendu Paul wrote: > Dear All, > > My query for attached file When we select data from drop down A cursor to > move A6;when we select B from drop down cursor move down B13 >

$$Excel-Macros$$ Query in VBA

Dear All, My query for attached file When we select data from drop down A cursor to move A6;when we select B from drop down cursor move down B13 -- 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

$$Excel-Macros$$ Query

In attachment; sheet1 we are sending a mail on clicking a shape. My query is to give an alert(like popup message box) when shape is not cliked -- 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://w

$$Excel-Macros$$ Query,

Hi All, Is it possible that our formula will be remain invisible only value populate on the cell , as i want to apply formula in excel via VBA Coding method . Is there any coding like " application.displayformula = False " please suggest . Regards, Atul -- Are you =EXP(E:RT) or =NOT(EXP(E

Re: Fwd: $$Excel-Macros$$ Query (Outlook VBA)

Thanks for help On Jun 3, 2015 4:43 PM, "Soumyendu Paul" wrote: > -- Forwarded message -- > From: "Soumyendu Paul" > Date: Jun 3, 2015 4:21 PM > Subject: $$Excel-Macros$$ Query (Outlook VBA) > To: > Cc: > > Hi, > > I have an ou

Re: $$Excel-Macros$$ Query (Outlook VBA)

http://www.excelvbamacros.in/2014/02/loop-through-all-outlook-emails-saved.html On Wed, Jun 3, 2015 at 4:20 PM, Soumyendu Paul wrote: > Hi, > > I have an outlook message stored in hard drive folder. Want to read this > file for extracting data into excel. Please help!! > > Regrds, > Soumyendu >

$$Excel-Macros$$ Query (Outlook VBA)

Hi, I have an outlook message stored in hard drive folder. Want to read this file for extracting data into excel. Please help!! Regrds, Soumyendu -- 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 @ http

Re: $$Excel-Macros$$ Query on Extract word

(CONCATENATE("MOC ",MID(SUBSTITUTE(SUBSTITUTE(A1351,"-","")," > ",""),(FIND("MOC",UPPER(SUBSTITUTE(SUBSTITUTE(A1351,"-","")," > ","")))+3),2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A

RE: $$Excel-Macros$$ Query on Extract word

"")," ",""),(FIND("MOC",UPPER(SUBSTITUTE(SUBSTITUTE(A1351,"-","")," ","")))+3),2),1))<58)),"0","-1"),"No MOC") PFA Regards Pankaj Sharma (PJ) From: excel-macros@goog

Re: $$Excel-Macros$$ Query on Extract word

This will work =IFERROR(IFERROR(MID(A2,FIND("MOC",A2,8),7),UPPER(MID(A2,FIND("moc",A2,7),8))),UPPER(MID(A2,FIND("Moc",A2,7),8))) However may of the cases it is written like MOC 9 or MOC - 08 hence some garbage is appearing. you can remove by text to coloumn command. Prashant On Wed, May 20,

$$Excel-Macros$$ Query on Extract word

Dear Experts, Please help. Query is in the attached sheet. -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- 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.faceboo

Re: $$Excel-Macros$$ Query to retreive data

Excel 2010 and file is on the same machine. Vabz I know the procedure to get the data from excel file but here my file is always large and opening will take a lot of time . On Tuesday, April 28, 2015 at 11:59:45 AM UTC+5:30, Vabz wrote: > > Which version of excel you are using? > > Are both fil

Re: $$Excel-Macros$$ Query to retreive data

Which version of excel you are using? Are both file on same machine or they are on Network? On Tue, Apr 28, 2015 at 11:34 AM, Mandeep Baluja wrote: > My mmaster file is large and i just want to do lookup on my sheet from > master file without opening my master file as it is of huge mb around 25

$$Excel-Macros$$ Query to retreive data

My mmaster file is large and i just want to do lookup on my sheet from master file without opening my master file as it is of huge mb around 250 mb or more than that. any ideas -- 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 Face

Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

Replace .addattachment rngAttach1.Value with If Dir(rngAttach1.Value) <> "" Then .addattachment rngAttach1.Value End If Cheers!! On Tue, Mar 24, 2015 at 9:05 AM, Ashish Bhalara wrote: > When value of path is null, function by default set 0 in cell F2, so I > tried below code to avoid error on

Re: $$Excel-Macros$$ Query for If condition or VBA

Awesome Sir :-) and thanks -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Wed, Mar 25, 2015 at 2:13 PM, Vaibhav Joshi wrote: > check formula in col E, If there are more than 2 case of overlap then 1st > will be shown as ok & second will be as error. > > In case it is more

Re: $$Excel-Macros$$ Query for If condition or VBA

check formula in col E, If there are more than 2 case of overlap then 1st will be shown as ok & second will be as error. In case it is more than 2 case of overlap then 1st will be shown as ok & rest all will be shown as error.. Cheers!! On Wed, Mar 25, 2015 at 2:01 PM, Vaibhav Joshi wrote: > c

Re: $$Excel-Macros$$ Query for If condition or VBA

can you explain one example.. On Wed, Mar 25, 2015 at 1:45 PM, Sunil Kumar Yadav wrote: > Hello, > > Please solve this query!!! > > -- > Thanks & Regards > *Sunil Kumar Yadav* > * Sr. Executive - *MIS (Billing Deptt.) > Skype ID: sunil.yadav7186 > > On Tue, Mar 24, 2015 at 5:27 PM, Sunil Kumar Y

Re: $$Excel-Macros$$ Query for If condition or VBA

Hello, Please solve this query!!! -- Thanks & Regards *Sunil Kumar Yadav* * Sr. Executive - *MIS (Billing Deptt.) Skype ID: sunil.yadav7186 On Tue, Mar 24, 2015 at 5:27 PM, Sunil Kumar Yadav wrote: > Dear > ​ ​Team, > > PFA file and check my query. > > ​ > -- > Thanks & Regards > *Sunil Kumar

$$Excel-Macros$$ Query for If condition or VBA

Dear ​ ​Team, PFA file and check my query. ​ -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 -- 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$$ Query in code of email send with attachment from excel

When value of path is null, function by default set 0 in cell F2, so I tried below code to avoid error on path not written in cell. but though same error is occur, pls do something in coding. If ws.Range("F2") <> Chr(48) Then .addattachment rngAttach1.Value End If On Mon,

Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

Before adding att check if attachment exists or not, if its null then you will get error... Cheers!! On Mon, Mar 23, 2015 at 5:00 PM, Ashish Bhalara wrote: > Dear experts, > > See the attached file of email sending from excel. Normally mail send > successfully to all together from database. I n

$$Excel-Macros$$ Query Regarding Duplicate and Update Status

Hello Team, I have an Query regarding Duplicate check for certain Criteria in filter. I need this to be in VBA Code . Please see the details below and find the sample attached file with expected result mentioned. I have to filter for FK (Column "B"), Then find duplicate DOC.no for this colleague

Re: $$Excel-Macros$$ Query for autofit columns.

Check this.. Cheers!! On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja wrote: > Quuery for autofit > > -- > 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 > > F

Re: $$Excel-Macros$$ Query for autofit columns.

Okay. .I got it. On Thu, Mar 12, 2015 at 2:41 PM, Mandeep baluja wrote: > Not working Range("C8").CurrentRegion.Columns.AutoFit this line will > unhide the hide columns in between the range. i have tried visible columns > property but its not working. > > On Thursday, 12 March 2015 14:37:51 U

Re: $$Excel-Macros$$ Query for autofit columns.

Not working Range("C8").CurrentRegion.Columns.AutoFit this line will unhide the hide columns in between the range. i have tried visible columns property but its not working. On Thursday, 12 March 2015 14:37:51 UTC+5:30, Gaurav Devrani wrote: > > Hi Mandeep, > > Please check the attached file.

Re: $$Excel-Macros$$ Query for autofit columns.

Hi Mandeep, Please check the attached file. let me know if I am missing something. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja wrote: > Quuery for autofit > > -- > 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) ! Jo

$$Excel-Macros$$ Query for autofit columns.

Quuery for autofit -- 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, Ur

$$Excel-Macros$$ Query in IF formula on sheet deactivation event

Dear expert, I need help in attached file in which if cheque amount is greater than zero and date & cheque number field Blank then msgbox should display, and when cheque amount is blank, no any msgbox should display. In my case and as per my formula the msgbox display even cheque amt. field is ze

Re: $$Excel-Macros$$ Query on count

Hi Kal Excel, PFA resolved query of yours. Regards, Waseem Saifi On Thu, Nov 13, 2014 at 5:11 PM, Kal xcel wrote: > Dear Experts, > > Please help me to solve my query. > > Thanks in advance > > -- > *Kalyan Chattopadhyay* > > > *Executive Corporate MIS* > > *Joy Cosmetics* > > -- > Are you =EX

$$Excel-Macros$$ Query on count

Dear Experts, Please help me to solve my query. Thanks in advance -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- 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

Re: $$Excel-Macros$$ query need help

xcel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ query need help > > > > Hi experts, > > > > please find the attached file. my query is. > > > > i want to fill dates in sheet2 from sheer1. only weekdays, except sat and > sun.. > > > &g

RE: $$Excel-Macros$$ query need help

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Sunday, March 16, 2014 8:02 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query need help Hi experts, please find the attached file. my query is. i want

Re: $$Excel-Macros$$ query need help

Sub TES() Dim i As Long Dim cl As Range For Each cl In Sheets("Sheet1").Range("c1:c31") If Weekday(cl.Value, vbMonday) < 6 Then With Sheets("Sheet2").Range("XFD2").End(xlToLeft).Offset(0, 1) .Value = cl .NumberFormat = "DD-MMM-" End With End If Next End Sub On Sun, Mar 16, 2014 at 8

Re: $$Excel-Macros$$ query need help

sorry, in sheet 1 dates will be in vertical, but in sheet 2 i want to fill in horizontal. Thanks & Regards, Prabhu R On 16 March 2014 08:02, Prabhu Pinky wrote: > Hi experts, > > please find the attached file. my query is. > > i want to fill dates in sheet2 from sheer1. only weekdays, excep

$$Excel-Macros$$ query need help

Hi experts, please find the attached file. my query is. i want to fill dates in sheet2 from sheer1. only weekdays, except sat and sun.. in sheet1 dates will be in vertical, but in sheet2 i want to fill in vertical(except sat and sunday) no alteration should be done in sheet1. please help. T

Re: $$Excel-Macros$$- Query

Hi Team, Can you help me to fix this small thing. Regards Atul On Sun, Mar 9, 2014 at 7:04 PM, Atul Kesaria wrote: > Hi Team, > > Thanks for the help. However just found one bug in macro. If the status is > N in the AE column then the macro stops at that row and does not processed > over to

Re: $$Excel-Macros$$- Query

Hi Team, Thanks for the help. However just found one bug in macro. If the status is N in the AE column then the macro stops at that row and does not processed over to the next row even if the status is Y. Please help in solving that. Regards Atul On Mon, Feb 17, 2014 at 3:53 PM, mrExcel4u wr

Re: $$Excel-Macros$$ Query for Macro

Hi Prafull, Try this if you want to use In Cell formulas, paste bellow code in module Function IsOK(CRef As Range) As String Dim Str As String Str = UCase(CRef.Value) If InStr(1, Str, "YES") Or InStr(1, Str, "NO") Or InStr(1, Str, "CORRECT") Then IsOK = "OK" End Function Then just

Re: $$Excel-Macros$$ Query for Macro

Try this Sub query() Dim rng As Range Dim cel As Range Set rng = Range("A1:a10") For Each cel In rng If cel = "Yes" Or cel = "No" Or cel = "Correct" Then cel.Offset(0, 1) = "Ok" End If Next cel End Sub Thanks & regards, www.MrExcel4U.com O

$$Excel-Macros$$ Query for Macro

Dear All, I have made one macro for search word in column like "NO" "YES" "Correct" if this words are in cell then write the "OK" in next cell . I have query that I have used elseif many time. Is there any other way in which i can write macro in one line for example if A1 contain words like "NO",Y

Re: $$Excel-Macros$$- Query

Hi Atul, PFA... Thanks & regards, www.MrExcel4U.com On Mon, Feb 17, 2014 at 1:15 PM, Atul Kesaria wrote: > Hi Team, > > Can some one help. > > Regards > Atul > > > On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria wrote: > >> Hi Team, >> >> I need a help in cre

Re: $$Excel-Macros$$- Query

Hi Team, Can some one help. Regards Atul On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria wrote: > Hi Team, > > I need a help in creating a macro for attached sheet > > Process Brief:- > 1) Need to send email to people based of status as per column AE. If > status is "Y: then mail should be send

$$Excel-Macros$$- Query

Hi Team, I need a help in creating a macro for attached sheet Process Brief:- 1) Need to send email to people based of status as per column AE. If status is "Y: then mail should be send to people as per email ID "To" & "CC" and attachement should be done based on file name in column AB, AC & AD.

Re: $$Excel-Macros$$ Query on Dashboard(urgent)

:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri > *Sent:* Wednesday, October 02, 2013 7:20 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Query on Dashboard(urgent) > > ** ** > > Hi Al

RE: $$Excel-Macros$$ Query on Dashboard(urgent)

PFA, I think u r looking for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashwani agnihotri Sent: Wednesday, October 02, 2013 7:20 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query on Dashboard(urgent) Hi All, I have

Re: $$Excel-Macros$$ Query on Dashboard(urgent)

Hi All, Any update on this? Regards, Ashwani On Wed, Oct 2, 2013 at 7:20 PM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > Hi All, > > I have attached an excel for reference I want to know if I can create a > dashboard werein if I select a team , the rest of the data about the team

$$Excel-Macros$$ Query on Dashboard(urgent)

Hi All, I have attached an excel for reference I want to know if I can create a dashboard werein if I select a team , the rest of the data about the team comes automatically. Like I apply data validation on team and select powerteam I want all the employees along with their productivity and qualit

Re: $$Excel-Macros$$ Query on vlookup

t;> G3 is lookup_value > >> > >> > >> > >> =OFFSET(A2,MATCH(G3,A2:A13,0)-1,MATCH("total",A2:F2,0)-1) > >> > >> > >> > >> > >> > >> > >> > >> Warm Regards, > >> > >>

Re: $$Excel-Macros$$ Query on vlookup

gt;> >> =OFFSET(A2,MATCH(G3,A2:A13,0)-1,MATCH("total",A2:F2,0)-1) >> >> >> >> >> >> >> >> Warm Regards, >> >> Ravi Kumar. >> >> >> >> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegro

Re: $$Excel-Macros$$ Query on vlookup

ay, September 14, 2013 10:03 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Query on vlookup > > ** ** > > Try this formula > > *=VLOOKUP(H3,A3:G13,MATCH("TOTAL",$A$2:$G$2,0),0)* > > On 14-09-2013 11:28, Shrinivas Shevde wr

RE: $$Excel-Macros$$ Query on vlookup

cel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query on vlookup Try this formula =VLOOKUP(H3,A3:G13,MATCH("TOTAL",$A$2:$G$2,0),0) On 14-09-2013 11:28, Shrinivas Shevde wrote: Dear All Query on vlookup Please look at the attached sheet. Thanks in advance -- Shrin

Re: $$Excel-Macros$$ Query on vlookup

Try this formula *=VLOOKUP(H3,A3:G13,MATCH("TOTAL",$A$2:$G$2,0),0)* On 14-09-2013 11:28, Shrinivas Shevde wrote: Dear All Query on vlookup Please look at the attached sheet. Thanks in advance -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

Re: $$Excel-Macros$$ Query on vlookup

=VLOOKUP(F3,A:E,MATCH("Total",$2:$2,0),0) On Sat, Sep 14, 2013 at 9:58 AM, Shrinivas Shevde wrote: > Dear All > Query on vlookup > Please look at the attached sheet. > > Thanks in advance > > -- > Shrini > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME

$$Excel-Macros$$ Query on vlookup

Dear All Query on vlookup Please look at the attached sheet. Thanks in advance -- Shrini -- 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 c

$$Excel-Macros$$ Query Regarding Range.Dirty

Hi Experts. I have found numerous examples of *Range("E3").Dirty* like standard VBA code in websites. As per their explanation; it forces "E3" cell to recalculate when Excel is manual calculation mode. Could anyone in this group give me an example of practical application of this property?

Re: $$Excel-Macros$$ Query Regarding Pivot Table

Thanx [?] On Sat, Aug 24, 2013 at 2:09 PM, xlstime wrote: > Yes, it is possible via "Multipal consolidate ranges" > > Just press Alt+D+P then select "Multipal consolidate ranges" > > . > > Enjoy > Team XLS > > > > On Sat, Aug 24, 2013 at 12:36 PM, Waseem Saifi wrote: >

Re: $$Excel-Macros$$ Query Regarding Pivot Table

Yes, it is possible via "Multipal consolidate ranges" Just press Alt+D+P then select "Multipal consolidate ranges" . Enjoy Team XLS On Sat, Aug 24, 2013 at 12:36 PM, Waseem Saifi wrote: > Dear Experts, > >Is it possible to make a pivot table basis on two workbooks

$$Excel-Macros$$ Query Regarding Pivot Table

Dear Experts, Is it possible to make a pivot table basis on two workbooks, while heading are same of both workbooks? partial data or complete data may be differ. or complete data may be same. Regards, Waseem Saifi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Query Regarding Sum

ot;address",INDIRECT("r"&MATCH(B3,E7:E10,0)+6&"c"&MATCH(B2,F6:M6,0)+5,FALSE)))) >> >> -- >> *From:* Waseem Saifi >> *To:* excel-macros >> *Sent:* Thursday, August 1, 2013 10:53 AM >> *Subject:*

Re: $$Excel-Macros$$ Query Regarding Sum

-- *From:* Waseem Saifi mailto:waseemsa...@gmail.com>> *To:* excel-macros mailto:excel-macros@googlegroups.com>> *Sent:* Thursday, August 1, 2013 10:53 AM *Subject:* $$Excel-Macros$$ Query Regarding Sum Dear Experts,

Re: $$Excel-Macros$$ Query Regarding Sum

ot;address",INDIRECT("r"&MATCH(B3,E7:E10,0)+6&"c"&MATCH(B2,F6:M6,0)+5,FALSE > > ------ > *From:* Waseem Saifi > *To:* excel-macros > *Sent:* Thursday, August 1, 2013 10:53 AM > *Subject:* $$Excel-Macros$$ Query Regardi

Re: $$Excel-Macros$$ Query Regarding Sum

__ From: Waseem Saifi To: excel-macros Sent: Thursday, August 1, 2013 10:53 AM Subject: $$Excel-Macros$$ Query Regarding Sum Dear Experts, I want to sum of values basis on two conditions. it is explained in attachment. I also tried offset function, but it didn't work proper

  1   2   3   4   >