Re: $$Excel-Macros$$ Highlight cell values in other areas based on two colimns

Hi Lee, Here you go. Please find the attachment. If you have any questions please let me know. Regards, Ganesh N +91 8056176946 On Sat, Aug 8, 2020 at 10:35 PM Lee wrote: > Hello all! > > You guys have worked miracles before, so I am asking for another. I want > to look

$$Excel-Macros$$ Need to highlight more than 6 days working list

Dear Team, Kindly help me to highlight or show more than 6 continues "W" by formula or macro. Thanks & Regards, Ganesh N -- 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://ww

Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

Dear Team, Any one can help me out ? Thanks & Regards, Ganesh N On Sun, Mar 27, 2016 at 9:15 PM, Ganesh N <ganeshg...@gmail.com> wrote: > Dear Team, > > Any update on my request ? > > Thanks & Regards, > Ganesh N > > On Sat, Mar 26, 2016 at 7:52 PM,

Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

Dear Team, Any update on my request ? Thanks & Regards, Ganesh N On Sat, Mar 26, 2016 at 7:52 PM, Ganesh N <ganeshg...@gmail.com> wrote: > Dear Team, > > Kindly request to help me with some formula to find the cell contains any > item from the list. I ha

$$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

. Thanks & Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

Thanks Pankaj and others. It works fine. Thanks a lot pankaj. Im going to apply in my base data if any concern kindly help... Thanks Regards, Ganesh N On Tue, Dec 22, 2015 at 9:37 PM, Pankaj Sharma <pankaj123...@gmail.com> wrote: > Dear Ganesh, > > I hope it should b

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

as "Yes" else "No". But all the solution which i got from the team are not giving the required result. Kindly help. Thanks & Regards, Ganesh N On Tue, Dec 22, 2015 at 5:58 PM, Pankaj Sharma <pankaj123...@gmail.com> wrote: >

$$Excel-Macros$$ help on find the list matches to the cell part value

Dear team, I want to find the any of the given list of value matches (part) in the particular cell using formula or macro. Please find the attached excel. If the solution in formula that would be great!! If you have any concern let me know. Thanks Team, Regards, Ganesh N -- Are you =EXP

Re: $$Excel-Macros$$ Change the date in required format in macro and store in variable

Thanks bro Regards, GN On Thu, Jul 9, 2015 at 1:45 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: PFA -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Thu, Jul 9, 2015 at 12:15 PM, Ganesh N ganeshg...@gmail.com wrote: Dear team, Need a help on storing

$$Excel-Macros$$ Change the date in required format in macro and store in variable

Dear team, Need a help on storing the date in the required format in macro. I can able to do but i showing the current date not the actual date. Please find the attached file for your reference. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ VBA parse an algebraic expression

Hi, Please find the attached file. If you have any concern let me know. Regards, Ganesh N On Thu, Jun 18, 2015 at 8:41 PM, Naftali Herscovici tuli.herscov...@gmail.com wrote: Hello, I need to evaluate an algebraic expression. Example - start dim a,b,c as string dim x as string

Re: $$Excel-Macros$$ XL formulas not auto updated

Can you pls share the file ? Regards, Ganesh N On Thu, Jun 18, 2015 at 2:10 PM, Ali Abbas tigarman...@gmail.com wrote: Dear All Hope you're all well...my problem is my one excel work book's formulas not updated automatically. Again and again I do press F2+Enter on any single cell. I have

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

Hi Ayush sir, Thanks for creating the forum. Our group helps me alot and also I help some time. Im working as a PMO in chennai in one of the MNC. http://www.excel-easy.com/; is great website which helps with sample file. I request excel beginner to try on that. Thanks again. Regards, Ganesh N

Re: $$Excel-Macros$$ How to filter only numbers in the list

Great Mr. Paul. This is want I am looking for. Thanks again also thanks mandeep. Regards, Ganesh N On Wed, Jun 17, 2015 at 6:12 PM, Paul Schreiner schreiner_p...@att.net wrote: So you want to see ONLY the alphabetic characters? You want to filter OUT the numbers? If so, I think your

Re: $$Excel-Macros$$ How to filter only numbers in the list

Thanks Mr. Paul but how i filter none numeric value ? Regards, Ganesh N On Wed, Jun 17, 2015 at 5:36 PM, Paul Schreiner schreiner_p...@att.net wrote: Simply turn on filters and select values 0. (see attached) *Paul* - *“Do all the good you

$$Excel-Macros$$ How to filter only numbers in the list

Dear Team, Please help me to know how to filter only number in the list. Please find the attachment. Thanks Regards, GN -- 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$$ How to filter only numbers in the list

Thanks Mr. Mandeep But no other option uh ? Regards, Ganesh N On Wed, Jun 17, 2015 at 6:07 PM, Mandeep Baluja rockerna...@gmail.com wrote: Create a helper column right next to your data and use isText function with respect to left cell apply filter where it is true you can get the text value

Re: $$Excel-Macros$$ Conditional Formating Problem

HI abbas, Use the conditional formatting with Use a formula to determine which cells to format' Regards, Ganesh N On Thu, May 14, 2015 at 3:24 PM, Ali Abbas tigarman...@gmail.com wrote: Dear All. Hope u r all well. I have two column with numbers. My requirement is if one column values

Re: $$Excel-Macros$$ Re: Exact Search excluding fractions

Dear Mandeep, Can you please explain how you did this ? or can you give the password for the respective code. Thanks Regards, Ganesh N On Mon, May 4, 2015 at 12:08 AM, Mandeep Baluja rockerna...@gmail.com wrote: Check this Out. Regards, Mandeep Baluja Email :-mandeep.bal...@snapdeal.com

Re: $$Excel-Macros$$ Copy Dynamically From Column and Pate

Hi Hilary, Please find the attachment. Macro1: will copy the data from E1 to the end date which you have. Macro2: will ask you the start column name. just enter e or which column you want. Thanks Regards, Ganesh N On Thu, Apr 30, 2015 at 4:44 PM, Paul Schreiner schreiner_p...@att.net wrote

Re: $$Excel-Macros$$ FW: Help required

Dear neeraj, PFA, Regards, Ganesh N On Tue, Feb 24, 2015 at 10:40 AM, Neeraj neerajchauhan...@gmail.com wrote: Dear experts, I want to SUM of time as given below format *2/1/2015* *2/21/2015* *sum in Hours* *Like* 11:39:49 9:42:15 9 hrs 30 Minute *From:* Neeraj

Re: $$Excel-Macros$$ Text to columns

Dear amit, Please find the attachment. Note: Few thing u have do it. 1. don't change the header. 2. change the second comment to = Comnt: has I mentioned. Regards, Ganesh N On Wed, Feb 18, 2015 at 2:47 PM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear Friends, Please help me

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

Thanks Vaibhav ji, Got it. But can you pls explain how this works =DATE(20RIGHT(D2,2),3,31)*1 Thanks a lot! Regards, Ganesh N On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi v...@vabs.in wrote: hi check this... In blue i have given formula using helper columns in yellow its direct one

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

Dear son nguyen, Try this formula... Let me know if you have any concern. Thanks Regards, Ganesh N On Tue, Nov 25, 2014 at 7:07 PM, Paul Schreiner schreiner_p...@att.net wrote: Can you send me a sample file? Otherwise, I'll probably spend far too much time trying to recreate something

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

Dear son nguyen, Before putting the my formula just have sort in start time. Regards, Ganesh N On Wed, Nov 26, 2014 at 10:01 AM, Ganesh N ganeshg...@gmail.com wrote: Dear son nguyen, Try this formula... Let me know if you have any concern. Thanks Regards, Ganesh N On Tue, Nov 25, 2014

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

change. Now in next celll put formula =E2*1 now goto format cell change date format to dd/mmm/yy or any other format. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 26, 2014 at 9:11 AM, Ganesh N ganeshg...@gmail.com wrote: Thanks

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

Dear son nguyen, PFA Regards, Ganesh N On Wed, Nov 26, 2014 at 10:03 AM, Ganesh N ganeshg...@gmail.com wrote: Dear son nguyen, Before putting the my formula just have sort in start time. Regards, Ganesh N On Wed, Nov 26, 2014 at 10:01 AM, Ganesh N ganeshg...@gmail.com wrote: Dear son

Re: $$Excel-Macros$$ Re: How to select a range in vba ?

Dear Mandeep, Pls try this... Sub SelRows() Dim R Rows(1).EntireRow.Select For R = 2 To 100 Step 3 Range(Selection, Selection.Rows(R)).Select Next R End Sub Thanks Regards, Ganesh N On Tue, Nov 25, 2014 at 9:41 AM, Mandeep Baluja rockerna...@gmail.com wrote: Sorry to say

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey resp...@gmail.com wrote: USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganeshg...@gmail.com wrote: Dear team

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

Dear team, Any update on the request ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N ganeshg...@gmail.com wrote: I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

Dear Mandeep, Please see the header I mean the financial year if it is FY 15-16 that means I what to find the month in apr 15- Mar 16 in the given time period 1 april and 30 june 19. Im I clear or need more clarification ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 3:30 PM, Mandeep

$$Excel-Macros$$ Formula to find the month btwn the financial year

Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ pls help -Required out[ut in a cell

Dear chandan, PFA. If you have any concern let me know. Regards, Ganesh N On Tue, Nov 4, 2014 at 3:41 PM, Chandan Bisht csb.bi...@gmail.com wrote: Hi Group i m creating a macro by vba but getting some error ... pls help i want to output in a cell.using below code .. example

Re: $$Excel-Macros$$ Sort VBA required

Dear Amar, PFA. Just try now. If you have any concern let me know. Regards, Ganesh N On Fri, Oct 10, 2014 at 4:38 PM, amar takale amartak...@gmail.com wrote: Dear friend Actially I want all result Show in one sheet.which you do this is like hyperlink Regards Amar On Thu, Oct 9, 2014

Re: $$Excel-Macros$$ Sort VBA required

Hi amar, PFA. Regards, Ganesh N On Thu, Oct 9, 2014 at 11:52 AM, amar takale amartak...@gmail.com wrote: Dear Sir Pls find attached another sheet for detailed clarification.Here I show how to look output will show.Bos there are same one stock are under different category. Like BHEL

Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS

Dear Kumar, There are lot of tutorial / training documents. Just google it. Regards, Ganesh N On Wed, Oct 8, 2014 at 3:21 PM, Kumar Kishore kishore...@gmail.com wrote: Dear Sir, Thank you for your kind co-operation and feedback and response. But i don't know Basics. Kindly advice us

Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

Hi sudhir, PFA. Just given if condition. Regards, Ganesh N On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA newinex...@gmail.com wrote: Dear Experts, Kindly resolve my problem. Explanation in attached workbook. Thanking You Regards Sudhir -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ for updating the worksheet through the user form

Hi Shankar, PFA, I have just added one more button (Modify) use that before update button. Thanks Regards, Ganesh N On Wed, Sep 24, 2014 at 11:00 AM, Shankar Bheema shankar.n...@gmail.com wrote: Good morning all, I am attaching an excel workbook which is meant for office file tracking

Re: $$Excel-Macros$$ for updating the worksheet through the user form

Dear Shankar, The modify will choose the particular row (enter the sn. no) and then wht ever change u want make (e.g out time) and then click the update button. Just try if you have doubt let me know. Regards, Ganesh N On Wed, Sep 24, 2014 at 1:07 PM, Shankar Bheema shankar.n...@gmail.com

Re: $$Excel-Macros$$ Amazing Excel formulas...

Hi Vaibhav Ji, Can you please explain how the attachment works because I cant even see any macro in that file. Note: Its in the amazing excel formulas file. Thanks Regards, Ganesh N On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Thanks Vaibhav On Wed

Re: $$Excel-Macros$$ Amazing Excel formulas...

Yes sir no macro but can you tell me how the formula works ? e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount in addition row/col it not working Regards, Ganesh N On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote: Hi There is no Macro in this file

Re: $$Excel-Macros$$ Amazing Excel formulas...

Got it sir!! Thanks One more help sir. Like formulas do you have sample files for macros ? just to learn. im a beginner to macro. Regards, Ganesh N On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi v...@vabs.in wrote: ok, COGS is named range, press Ctr + G you will see all defined cells. Select

$$Excel-Macros$$ Track the system Lock

i need VBA code for below task I want to do disable and the (windows lock) *window+L* or (lock workstation) or *Crtl+alt+Del*. can every one give the code for that...? -- 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

$$Excel-Macros$$ Documents for web scraping

Dear team, I am learning web scraping where I can find the advanced documents/pdf books or file. Thanks Regards, Ganesh N -- 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$$ Text file to excel

Hi Paul, Im fine with every thing but after saving the excel file to .txt it contain some additional () quotes (unwanted). can you please help me to avoid that one ? Thanks Regards, Ganesh N On Fri, Sep 5, 2014 at 8:58 AM, Ganesh N ganeshg...@gmail.com wrote: Thanks Paul. Let me check

Re: $$Excel-Macros$$ Text file to excel

Thanks Paul. let me try on that. thanks again Regards, Ganesh N On Fri, Sep 5, 2014 at 7:38 PM, Paul Schreiner schreiner_p...@att.net wrote: That's a bit more involved. Have you ever used the filesystem object similar to: Const ForReading = 1, ForWriting = 2, ForAppending = 8 Dim

$$Excel-Macros$$ Text file to excel

to text file. Required your help one that. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Blank Cell Issue

Hi LJ, Just select the data - ctrl + G - special - blanks - ok - right click - delete - Shift cells up. Thanks Regards Ganesh N On Thu, Sep 4, 2014 at 10:27 PM, LJ ljasonmil...@gmail.com wrote: Hi Everyone! I am working on a sheet where I have the Product listed in Column A, app

Re: $$Excel-Macros$$ Blank Cell Issue

Dear LJ, Can you please share the little detail about your requirement ? with some other sample ? Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:40 PM, LJ ljasonmil...@gmail.com wrote: Ganesh, Thanks for the reply. When I do that the other products beneath are left without values

Re: $$Excel-Macros$$ Text file to excel

Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45

Re: $$Excel-Macros$$ Text file to excel

Thanks Paul. Let me check on this. Regards, Ganesh N On Thu, Sep 4, 2014 at 11:29 PM, Paul Schreiner schreiner_p...@att.net wrote: Have you tried recording a macro? When I recorded macros, I came up with: Sub Open_Macro() Workbooks.OpenText Filename:=C:\temp\mfg_appl_log.txt, Origin

$$Excel-Macros$$ Need a help in Pivot

Hi Team, I have the shift details. I want only the shift count excluding OFF days but when i try pivot i have dayend count including OFF's. Can any one help me out with the Pivot how to do it ? PFA Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Doubt in Duplicates

HI Kannan, There is In-build option in excel to show the duplicates. Please find the below steps. Home-conditional formatting-highlight cells rules-Duplicate value (you can create whatever format u want to show the duplicate values) Thanks Regards, Ganesh N On Wed, Apr 30, 2014 at 11:27 AM

Re: $$Excel-Macros$$ formula issue with sample sheet

,TDS amount * 1.5% * defaults months,0) Thanks Regards, Ganesh N On Mon, Apr 28, 2014 at 7:15 PM, L.K. Modi ca.mod...@gmail.com wrote: Dear Sir I have downloaded a file from the net but unable to understand the logic in column Q AND R as the file is read only only so can anyone say me

Re: $$Excel-Macros$$ please help for consolidate in excel

Hi Yadav, you can also use this. Just put the data files in separate folder and put the path in cell J2. Thanks Regards, Ganesh N On Sun, Apr 27, 2014 at 11:16 AM, Vaibhav Joshi v...@vabs.in wrote: Hi, You can try this excellent codes share by Ashish earlier this month: Sub merge

Re: $$Excel-Macros$$ Need a code to update the non existing data

on that ? Thanks Regards, Ganesh N On Sun, Apr 27, 2014 at 11:20 AM, ravinder negi ravindervbacli...@gmail.com wrote: hi, please visit below link for your solution, please advise if anything else required. http://excelvbasupport.com/forum/showthread.php?tid=15 Note I have checked only

Re: $$Excel-Macros$$ Need a code to update the non existing data

:=xlYes Worksheets(To be update).Select End Sub Cheers!! On Sun, Apr 27, 2014 at 12:00 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Ravinder sir, The Prj code mostly will repeat (week on week the Prj code will be same only date and value will change) . So I need to check the date

$$Excel-Macros$$ Need a code to update the non existing data

a duplicate ). I wrote coding for update the data. I need a code to check the condition. Kindly help me on that. Please find the attachment for your reference. Thanks Regards, Ganesh N -- 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$$ Need a code to update the non existing data

Hi Team, Any update on my request ? Thanks Regards, Ganesh N On Sun, Apr 27, 2014 at 7:50 AM, Ganesh N ganeshg...@gmail.com wrote: Hi Team, I need to update the data in second sheet. before that i want to check the data is already updated or not if already updated i need a msg else

Re: $$Excel-Macros$$ Need new Workbook create using Macros

Hi Gupta, Please find the attachment. Thanks Regards, Ganesh N On Tue, Apr 22, 2014 at 11:43 AM, Ravinder ravinderexcelgr...@gmail.comwrote: Pfa,…first click on button and then select where u want to save file. *From:* excel-macros@googlegroups.com [mailto: excel-macros

Re: $$Excel-Macros$$ Need new Workbook create using Macros

Hi Ravinder sir, Can you please explain about the collections and below line of code how it works ? Becoz im not familiar with collections For i = 2 To ws.Range(g1).End(xlDown).Row col.Add ws.Range(g i), CStr(ws.Range(g i)) Thanks Regards, Ganesh N On Tue, Apr 22, 2014 at 11:52 AM, Ganesh

Re: $$Excel-Macros$$ Need a help on sumproduct for MTD data

Hi team, any update on this ? Thanks Regards, Ganesh N On Sat, Apr 12, 2014 at 9:26 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Ashish/Team, I need to do sumproduct for both forecast and AHT (2 type of data). Can you please help me on that ? Thanks Regards, Ganesh N On Fri, Apr

Re: $$Excel-Macros$$ Need a help on sumproduct for MTD data

Hi Ashish/Team, I need to do sumproduct for both forecast and AHT (2 type of data). Can you please help me on that ? Thanks Regards, Ganesh N On Fri, Apr 11, 2014 at 11:58 PM, ashish koul koul.ash...@gmail.com wrote: =SUMPRODUCT(($B$2:$DC$2=B9)*($B$4:$DC$4)) On Fri, Apr 11, 2014 at 4:50

$$Excel-Macros$$ Need a help on sumproduct for MTD data

Hi Team, Kindly help me out to do sumproduct the data for MTD. (monthwise). Please find the attachment for your reference. Thanks Regards, Ganesh N -- 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$$ Need help to find the missing emp id on particular date

Hi Team, Need a help in find the missed emp id list. Sheet1 have the actual employee ids and date. In sheet2 have overall employee ids in that i need to find the employee missed on particular date. Please find the attachment for your reference. Thanks Regards, Ganesh N -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

Hi Team, Any updates on the request ?? Thanks Regards, Ganesh On Tue, Apr 8, 2014 at 1:15 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Team, Need a help in find the missed emp id list. Sheet1 have the actual employee ids and date. In sheet2 have overall employee ids in that i need

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

Thanks Paul Ashish Regards, Ganesh N On Wed, Apr 9, 2014 at 12:14 AM, ashish koul koul.ash...@gmail.com wrote: Sub sample() Dim i As Long Dim rng As Range Dim strng As Long Dim endrng As Long Sheets(Sheet1).Range(a1:b Sheets(Sheet1).Range(a1).End(xlDown).Row).Sort key1:=Sheets

Re: $$Excel-Macros$$ Re: All text box need to be enter

Hi, Please find the attachment. Regards, Ganesh N On Wed, Apr 2, 2014 at 4:55 PM, rameshwari shyam rameshwarish...@gmail.comwrote: Dear Ganesh, Here active cell will be different, data need to fill as per textbox3 value in colostrum A first empty row textbox4 value in column B first

Re: $$Excel-Macros$$ Arrow solution

Hi Amar, Please find the attachment. Let me know it helps you. Regards, Ganesh N On Thu, Apr 3, 2014 at 12:28 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Thanks for reply but this is not as per my solution,I want arrow like H column in excel. Regards Amar -- Are you =EXP

Re: $$Excel-Macros$$ Re: All text box need to be enter

Hi Rameshwari, Please find the attached file. Regards, Ganesh N On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari rameshwarish...@gmail.comwrote: Dear Team, Forget to attached excel sheet. Please help on this Regards, Rameshwari :) On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari

Re: $$Excel-Macros$$ Re: All text box need to be enter

Hi rameshwari, Please find the updated one. Regards, Ganesh N On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam rameshwarish...@gmail.comwrote: Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer

Re: $$Excel-Macros$$ Record Macro to Filter out blanks

Hi Elaine, Replace with Criteria1:= Note: For Blanks use the above. If you want to exclude some thing just use ** before the things. Regards, Ganesh N On Wed, Mar 5, 2014 at 5:11 AM, elaine chong christ...@gmail.com wrote: Can someone please help me to guide to filter excluding particular

$$Excel-Macros$$ Need help in filter

Hi Team, Can you please help me to guide to filter excluding particular name. Please find the attachment. e.g I want to filter excluding South region. but its not working. Thanks Regards, Ganesh N -- 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$$ Request help on conditional formatting

@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ganesh N *Sent:* Monday, February 10, 2014 12:41 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Request help on conditional formatting Thanks Ravinder!!! Ravinder may i know why we are using

$$Excel-Macros$$ Request help on conditional formatting

Hi team, Any one can help me to know how to highlight the name based on other column value (need to highlight name based on the highest or lowest value of other column). Please find sample example has been attached. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ Request help on conditional formatting

Thanks Ravinder!!! Ravinder may i know why we are using $F7 ? before =Max. Else can you explain how it works ? Thanks Regards Ganesh N On Mon, Feb 10, 2014 at 10:16 AM, Ravinder ravindervbacli...@gmail.comwrote: =$F7=MAX($F$7:$F$11) try this formula in condition formatting option or pfa

$$Excel-Macros$$ Simple Sum Macro not working

”) Range(“B5”).Select ActiveCell.Value = InputBox(“Enter value”) Range(“B6”).Select ActiveCell.Value = InputBox(“Enter value”) Range(“B7”).Select ActiveCell.Formula = “=Sum(B2..B6)” ActiveWorkbook.SaveAs Filename:=”MyFirstProgram.xls” End Sub Thanks Regards, Ganesh N -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ Simple Sum Macro not working

Thanks Ashish On Sun, Oct 27, 2013 at 9:42 AM, Ganesh N ganeshg...@gmail.com wrote: Hi Team, Im new to macro may i know why this macro not working. Please help me on that. Sub MyFirstProgram() Range(“B2”).Select ActiveCell.Value = InputBox(“Enter value”) Range(“B3”).Select

$$Excel-Macros$$ Macro for Vlookup

in the coding to run this ? Please find the attactment. Thanks Regards, Ganesh N -- 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$$ Macro for Vlookup

Hi Anil, Thanks for that. But I dont need macro to put only formula. I need the macro to do the comparison of 2 list. Can you please help me on that ? Thanks Regards, Ganesh N On Fri, Oct 25, 2013 at 12:48 PM, Anil Gawli gawlianil8...@gmail.comwrote: Dear Ganesh, Pl see the attached

Re: $$Excel-Macros$$ Counting Nos formula

Hi prabhakar, Please find the attachment. Regards, Ganesh N On Mon, Oct 21, 2013 at 2:31 PM, Prabhakar S H prabakar.k...@gmail.comwrote: Hi Team, need your help to get nos by using formula. I know how to get details through pivot table but wanted to know formula also. Pls help. Rgds

Re: $$Excel-Macros$$

Hi Raj, Please find the attachment. Regards, GN On Sat, Sep 7, 2013 at 11:28 AM, Raj Kumar rajlu...@gmail.com wrote: Hi Group, I need Pen Drives Count of the attached file. kindly help it. Regards Raj Bharti -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s