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 at

$$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 wrote: > Dear Team, > > Any update on my request ? > > Thanks & Regards, > Ganesh N > > On Sat, Mar 26, 2016 at 7:52 PM, Ganesh N wrote: > >> D

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 wrote: > Dear Team, > > Kindly request to help me with some formula to find the cell contains any > item from the list. I have used search formula but it is not working

$$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 wrote: > Dear Ganesh, > > I hope it should be ok. > > > Sub lookup_list

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

"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 wrote: > check it ! > > > > *Pankaj Sharma

$$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 wrote: > PFA > > -- > Thanks & Regards > *Sunil Kumar Yadav* > Skype ID: sunil.yadav7186 > > On Thu, Jul 9, 2015 at 12:15 PM, Ganesh N wrote: > >> Dear team, >> >> Need

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

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

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

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 wrote: > So you want to see ONLY the alphabetic characters? > You want to filter OUT the numbers? > > If so, I think your terminology

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

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 wrote: > Simply turn on filters and select values > 0. > > (see attached) > > *Paul* > - > > > > >

$$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 @ https://www.facebook.com/di

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 wrote: > Dear All. Hope u r all well. > > I have two column with numbers. My requirement is if one column value

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 wrote: > Check this Out. > > Regards, > Mandeep Baluja > Email :-mandeep.bal...@snapdea

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 wr

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

Dear neeraj, PFA, Regards, Ganesh N On Tue, Feb 24, 2015 at 10:40 AM, Neeraj 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

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) wrote: > Dear Friends, > > > > Please help me

Fwd: $$Excel-Macros$$ Colour the Group Rows

mat, press erase me button & sleect range from which you want to delete formatting/colr.. And to apply color formatting, press color me & slect top most cell e.g.A2 in your case & press enter..Macro will color cell as per ur requirement.. Cheers!! ᐧ On Fri, Jan 30, 2015 at 5:33 PM,

Re: $$Excel-Macros$$ Colour the Group Rows

Hello yes after every group there is one space On Fri, Jan 30, 2015 at 5:28 PM, Vaibhav Joshi wrote: > Hi > > For macro need some input, is there gonna be space between two groups? > ᐧ > > On Fri, Jan 30, 2015 at 5:19 PM, Ganesh Acharya < > acharyaganesh...@gmail.com&g

Re: $$Excel-Macros$$ Colour the Group Rows

for this On Fri, Jan 30, 2015 at 5:09 PM, Ashish Kumar wrote: > Dear Ganesh, > > Go in Conditional Format tab and click on Manage Rules option and try to > understand how the formula works. > > I think, you no need a macro for it. > > > Regards > Ashish > > -- &

Fwd: $$Excel-Macros$$ Colour the Group Rows

Hello, Attachment doesn't have any formula Is there any way to make a Macro for that Thanks Ganesh Acharya -- Forwarded message -- From: Vaibhav Joshi Date: Fri, Jan 30, 2015 at 2:29 PM Subject: Re: $$Excel-Macros$$ Colour the Group Rows To: "excel-macros@google

$$Excel-Macros$$ Colour the Group Rows

nks Ganesh Acharya FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Do

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

Happy New Year to all Regards, Ganesh N On Thu, Jan 1, 2015 at 8:58 AM, Ashish Bhalara wrote: > A very very Happy New Year to all Group members. > > > On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi wrote: > >> Joyous January –Fabulous February >> >&

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

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

ther format, > result wont 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 We

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 wrote: > Dear son nguyen, > > Try this formula... Let me know if you have any concern. > > Thanks & Regards, > Ganesh N > > On

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 wrote: > Can you send me a sample file? > > Otherwise, I'll probably spend far too much time trying to recreate > somethi

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(20&RIGHT(D2,2),3,31)*1 Thanks a lot! Regards, Ganesh N On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi wrote: > hi > > check this... > > In blue i have given formula using helper columns & in

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 wrote: > Sorry to say I was not

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:

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

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 wrote: > USE DATEDIF FUNCTION > > On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N wrote: > >> Dear team, >> >

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

Re: $$Excel-Macros$$ mass change of URLs

rt&series=8&state=3&sex=M&countyid=1073&hitcount=1&p=1&urn=urn%3Aproquest%3AUS%3Bcensus%3B8563629%3B50480442%3B8%3B3&searchtype=1&offset=0>, else share the worksheet to make the macro. Regards, Ganesh On Wed, Nov 12, 2014 at 8:09 AM, Thomas Mack

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

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 wrote: > Dear friend > Actially I want all result Show in one sheet.which you do this is like > hyperlink > Regards > Amar > > On Thu, O

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

Hi amar, PFA. Regards, Ganesh N On Thu, Oct 9, 2014 at 11:52 AM, amar takale 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. > > Li

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 wrote: > Dear Sir, > > Thank you for your kind co-operation and feedback and response. > > But i don't know Basics. > > Kin

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 wrote: > Dear Experts, > > Kindly resolve my problem. > > Explanation in attached workbook. > > Thanking You > > Regards > Sudhir > > -- > Are you

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 wrote: > Dear Gan

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 wrote: > Good morning all, > > I am attaching an excel workbook which is meant for office file tracking. > On

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

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 wrote: > ok, COGS is named range, press Ctr + G you will see all defined cells. > Select CO

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 wrote: > Hi > > There is no Macro in this file, it

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

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

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 wrote: > That's a bit more involved. > Have you ever used the filesystem object similar to: > > > Const ForReading = 1, ForWriting = 2, ForAppending = 8 >

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 wrote: > Thanks Paul. Let me check on this.

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 wrote: > Have you tried recording a macro? > > When I recorded macros, I came up with: > > Sub Open_Macro() > Workbooks.OpenText Filename:="C:\temp\mfg_app

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 a

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 wrote: > Ganesh, > > Thanks for the reply. When I do that the other products beneath are left > without values in

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 wrote: > Hi Everyone! > > I am working on a sheet where I have the Product lis

$$Excel-Macros$$ Text file to excel

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 th

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

Hi, Thank. But there is any way to get the details without changing the structural ? Because the initial one is the format which use to have. Thanks Ganesh N On Sat, Jun 28, 2014 at 6:17 PM, Bé Trần Văn wrote: > Structural change, then use the AutoFilter to select PivotTable OFF. >

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

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,

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

>0,TDS amount * 1.5% * defaults months,0) Thanks & Regards, Ganesh N On Mon, Apr 28, 2014 at 7:15 PM, L.K. Modi 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

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

ll.PasteSpecial >> Application.CutCopyMode = False >> ActiveSheet.Range("A:D").RemoveDuplicates Columns:=Array(1, 2, 3, 4), _ >> Header:=xlYes >> Worksheets("To be update").Select >> >> End Sub >> >> Cheers!! >> >>

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 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$$ 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 wrote: > Hi, > > You can try this excellent codes share by Ashish earlier th

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

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

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 offi

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

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 wrote: > Pfa,…first click on button and then select where u want to save file. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegro

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

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 wrote: > =SUMPRODUCT(($B$2:$DC$2=B9)*($B$4:$DC$4)) > > > On Fri, Apr 11, 2014 at 4

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

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 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("She

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

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

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 wrote: > Dear Ravinder > Thanks for reply but this is not as per my solution,I want arrow like > H column in excel. > Regards > Amar > > -- &g

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

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 wrote: > 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 the data to

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 wrote: > Dear Team, > > Forget to attached excel sheet. Please help on this > > > Regards, > Rameshwari :) > > On Wednesday, April 2, 2014 10:26:11

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 wrote: > Can someone please help me to guide to filter excl

$$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&#x

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

Thanks Ravinder Thanks for your explanation :) On Mon, Feb 10, 2014 at 12:46 PM, Ravinder wrote: > NAME > > AMT > > FORMULA > > RESULT (TRUE/FALSE) > > Ganesh > > 20 > > =$F7=MAX($F$7:$F$11) > > FALSE > > Guna > > 90 > > =$F8=MA

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 wrote: > =$F7=MAX($F$7:$F$11) try this formula in condition formatting option or > pfa > > &

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

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

Thanks Ashish On Sun, Oct 27, 2013 at 9:42 AM, Ganesh N 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”

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

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 wrote: > Dear Ganesh, > > Pl see the attached sheet.

$$Excel-Macros$$ Macro for Vlookup

odify 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) Us

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

Re: $$Excel-Macros$$

Hi Raj, Please find the attachment. Regards, GN On Sat, Sep 7, 2013 at 11:28 AM, Raj Kumar 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 > =TIME(2

Re: $$Excel-Macros$$ Different Excel file in one Excel file

; > > > > > > > > > > > > > > > > > Thanks and Regards Ganesh Acharya > > > > > > > > > > > > > FORUM RULES > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need

Fwd: $$Excel-Macros$$ Different Excel file in one Excel file

-- Forwarded message -- From: Ganesh Acharya Date: Thu, Mar 28, 2013 at 12:35 PM Subject: $$Excel-Macros$$ Different Excel file in one Excel file To: excel-macros@googlegroups.com Hi, Can someone please help me out with the macro for below thing If I saved the different

Re: $$Excel-Macros$$ Re: Need to convert the fax copy in Excel sheet.

Hi, Thanks for your reply I don not know the source of Scan copy, but if I want to convert any scan copy what would be the code. Thanks and regards On Sun, Dec 23, 2012 at 12:19 PM, Prince wrote: > Hi Ganesh, > > Plz tell us the source of Fax Data. > > Regards > Pr

$$Excel-Macros$$ Latest file copy using excelvba

PFA workbook for sample design to copy files from one directory to another. Please help me to get the same. -- Thanks & Regards, Ganesh -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor th

Fwd: $$Excel-Macros$$ Re: Request Macro for Merge Text file

Hi Ashish, Please find attached text files and excel sheet for your reference. Please let me know if you have any clarifications. Regards, Ganesh -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Re: Request Macro for Merge Text file

Hi Pascal, I am not get correct solution from this coding Please help !!! On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 wrote: > Another shorter programming solution would have been to autofilter column > B and copy visible cells into a table and do the same thing and > let CopyDataToTxtFil

Re: $$Excel-Macros$$ Re: Request Macro for Merge Text file

Hi Pascal, Your understanding is exactly correct, Kindly help to us. Thanks & Regards, Ganesh > > On Sat, Nov 24, 2012 at 4:24 AM, bpascal123 wrote: > >> Merge1.txt = consist of 1.txt, 2.txt and 3.txt also the same order (1, 2 >> & 3) to copy paste in Merge1.t

$$Excel-Macros$$ Request Macro for Merge Text file

& Regards Ganesh -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Great Job Mr Noorain !!! Keep on your helps in this and we will expect you as world familiar in this expert ices. Thanks & Regards, Ganesh On Tue, Aug 14, 2012 at 2:21 PM, amar takale wrote: > This is Great Noorain Sir > > Thanks Noorain for your effort. > Also, thanks to a

$$Excel-Macros$$ My Self - Introduction

Hi All, My Name is Ganesh from India - Chennai, I am working with Inscribe - BPO for last 7 years as a Project Leader. In our office most the works processed by ms excel, so it is most important to our daily work. Mr Ashish referred to join this forum and it was more useful and reduced our

  1   2   >