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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi Sachin, use below excel function. =LOOKUP("ZZZ",$M$3:M3) 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 > > **

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

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

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

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

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

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

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,

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

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

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

m: Mandeep Baluja <rockerna...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> 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 ev

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

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

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

- From: Mandeep Baluja <rockerna...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> 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 O

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

gt; To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> 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 r

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, 10 started

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

- From: gargee singh garge...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Tuesday, July 28, 2015 1:05 AM Subject: RE: $$Excel-Macros$$ Query for Code !--#yiv8905106271 .yiv8905106271hmmessage P{margin:0px;padding:0px;}#yiv8905106271

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

you can.” - John Wesley - From: gargee singh garge...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Tuesday, July 28, 2015 1:05 AM Subject: RE: $$Excel-Macros$$ Query for Code !--#yiv8905106271

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

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

as ever you can.” - John Wesley - From: gargee singh garge...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, July 27, 2015 8:01 AM Subject: $$Excel-Macros$$ Query for Code !--#yiv5268623891

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

To: 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 column matches

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

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

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

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

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

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

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

Thanks for help On Jun 3, 2015 4:43 PM, Soumyendu Paul soumyendu...@gmail.com wrote: -- Forwarded message -- From: Soumyendu Paul soumyendu...@gmail.com Date: Jun 3, 2015 4:21 PM Subject: $$Excel-Macros$$ Query (Outlook VBA) To: excel-macros@googlegroups.com Cc: Hi, I

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

:* Wednesday, May 20, 2015 10:38 AM *To:* excel-macros@googlegroups.com *Subject:* $$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

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

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

: Wednesday, May 20, 2015 10:38 AM To: excel-macros@googlegroups.com Subject: $$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

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

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 file

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

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

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 sk.yadav7...@gmail.com wrote: Dear ​ ​Team, PFA file and check my query. ​ -- Thanks Regards

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 sk.yadav7...@gmail.com 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,

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 v...@vabs.in

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 v...@vabs.in 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

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 ashishbhalar...@gmail.com wrote: When value of path is null, function by default set 0 in cell F2, so I tried below

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

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 ashishbhalar...@gmail.com wrote: Dear experts, See the attached file of email sending from excel. Normally mail send successfully to all

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,

$$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 mandeepbal...@gmail.com 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 @

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

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 mandeepbal...@gmail.com wrote: Quuery for autofit -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

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

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

Okay. .I got it. On Thu, Mar 12, 2015 at 2:41 PM, Mandeep baluja mandeepbal...@gmail.com 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

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

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 kalx...@gmail.com wrote: Dear Experts, Please help me to solve my query. Thanks in advance -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- Are you

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

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

@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.. in sheet1 dates will be in vertical, but in sheet2 i want to fill in vertical(except

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:03 AM,

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

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 prabhupin...@gmail.com wrote: Hi experts, please find the attached file. my query is. i want to fill dates in sheet2 from sheer1.

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 atul.kesa...@gmail.com 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

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

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

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

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 http://mrexcel4u.blogspot.com/ On Wed, Feb

Re: $$Excel-Macros$$- Query

Hi Atul, PFA... Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Feb 17, 2014 at 1:15 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, Can some one help. Regards Atul On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi

Re: $$Excel-Macros$$- Query

Hi Team, Can some one help. Regards Atul On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria atul.kesa...@gmail.comwrote: 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

$$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. 2) If

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

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 attached

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

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

@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of De Premor Sent: Saturday, 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

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

, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of De Premor Sent: Saturday, 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

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

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 shrinivas...@gmail.comwrote: 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?

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

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

@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 -- Shrini -- Are you =EXP(E:RT

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

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

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

$$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 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 waseemsa...@gmail.comwrote: Dear Experts, Is it possible to make a pivot table basis

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

Thanx [?] On Sat, Aug 24, 2013 at 2:09 PM, xlstime xlst...@gmail.com 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

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

-- *From:* Waseem Saifi waseemsa...@gmail.com *To:* excel-macros excel-macros@googlegroups.com *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

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

mailto:waseemsa...@gmail.com *To:* excel-macros excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com *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

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

Saifi waseemsa...@gmail.com *To:* excel-macros excel-macros@googlegroups.com *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

$$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 properly. please help. Regards, Waseem Saifi -- 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$$ Query Regarding Sum

, 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 properly. please help. Regards, Waseem Saifi -- Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Expert , Can you expline the bold line as i want to know deeply. Function Reverse(Text As String) As String Dim i As Integer Dim StrNew As String Dim strOld As String strOld = Trim(Text) For i = 1 To Len(strOld) * StrNew = Mid(strOld, i, 1) StrNew* Next i

Re: $$Excel-Macros$$ Query - How to make reversal string.

Hi, It is working fine. In Cell A3 data is 958321.1 which is reversed as 1.123859. Pl check confirm. Thanks!! On Mon, Jul 22, 2013 at 10:55 AM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear VbA, thanks for your help. but this formula is not working properly.

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear VBA, Thanks for your help and valuable support. this is woking fine. Thanks, Ashish On 22 July 2013 11:44, vba v...@vabs.in wrote: Hi, It is working fine. In Cell A3 data is 958321.1 which is reversed as 1.123859. Pl check confirm. Thanks!! On Mon, Jul 22,

  1   2   3   >