Fwd: $$Excel-Macros$$ Copying Value by Column Header Name into new Sheet

*“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - On Wednesday, October 26, 2016 2:58 AM, C.G.Kumar < kum

Re: $$Excel-Macros$$ Copying Value by Column Header Name into new Sheet

at is yours doing? > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever

$$Excel-Macros$$ Copying Value by Column Header Name into new Sheet

Does anyone help me to fix the VB code (I'm not a VB guru either)for an Open spreadsheet - Purpose : when looking in a spreadsheet, I to look for a couple of column header names, and then copy those columns only (in a predefined order) into a clean separate worksheet. For example, On Sheet 1 - O

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

. On Wed, Dec 24, 2014 at 12:59 PM, Vaibhav Joshi wrote: > I did not got the logic of putting 8 in cell C5, can u pl explain.. > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Dec 23, 2014 at 9:18 PM, C.G.Kumar > wrote: >

Fwd: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

May someone please look and advise macro to solve the puzzle. Thanks and Regards, C.G.Kumar -- Forwarded message - From: C.G.Kumar Date: Mon Dec 22 2014 at 7:09:55 PM Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory To: excel-macros@googlegroups.com Macro is not

Re: $$Excel-Macros$$ Cash Flow Dashboard

n, Dec 22, 2014 at 10:23 AM, C.G.Kumar > wrote: > >> Hi, >> >> I would appreciate if anyone can help me with Cash Flow Dashboard. >> >> Many Thanks, >> >> C.G.Kumar >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? An

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

Macro is not providing desired result. Attached worksheet looks at total Purchase of Specific qty and provides ageing. But the need is to have ageing (& Value) of balance stock only. This mean in Solved worksheet of yours, total qty left in Cell "B5" is to be keyed in Manually and macro is expec

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

number 357000 row 3* *Please see attached excel sample file.* *Let me know if further details are required.* *Many Thanks,* *C.G.kumar* On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja wrote: > Please explain your Query Again I an unable to understand it . Aeging can > be

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

Please see attached file. Let me know if any additional info is required. On Mon, Dec 22, 2014 at 3:18 PM, Anil Gawli wrote: > Dear Rockernayal, > > Pls share a workbook with us. > > Regards, > Gawli Anil > > On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja > wrote: > > Please explain your Qu

Re: $$Excel-Macros$$ Macro for Ageing of Inventory

your support . Regards, C.G.Kumar On Mon, Dec 22, 2014 at 10:15 AM, Ashish Bhalara wrote: > Mr.C.G.Kumar > See attached file as your require function. > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. &

$$Excel-Macros$$ Cash Flow Dashboard

Hi, I would appreciate if anyone can help me with Cash Flow Dashboard. Many Thanks, C.G.Kumar -- 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

$$Excel-Macros$$ Macro for Ageing of Inventory

Hi, I have purchase data in a spreadsheet and List of Inventory Items on another worksheet of excel. May someone help me with a macro or advance formula which computes Ageing of Inventory. Age of Inventory is calculated in Purchase Sheet but do not know how to compute for available qty only. Sa

Re: $$Excel-Macros$$X Copy sand paste dynamic data range

above scenario, solution never br advised. Will appreciate if you can suggest. On Sunday, August 17, 2014, Vaibhav Joshi wrote: > Hi > > Browse thru forum, solution to mass mailer is available, you can use that > template. > > Cheers!! > > > On Fri, Aug 15, 2014 at

Fwd: $$Excel-Macros$$X Copy sand paste dynamic data range

imageto be part of email. Many thanks in advance; C.G. Kumar -- Forwarded message -- From: *C.G.Kumar* Date: Saturday, August 9, 2014 Subject: $$Excel-Macros$$ Include dynamic data range To: "excel-macros@googlegroups.com" Attached is sample excel file used

$$Excel-Macros$$ Include dynamic data range

Attached is sample excel file used to remind customer in India to pay. Excel expert help and support is expected on the below concern to modify attached macro: 1. Once "Send EMail" button in cell N1 is clicked, it capture details well. But, before, mail is sent to customer , I need to go to she

Re: $$Excel-Macros$$ Re: Filter Data based on Criteria

Missed to attach sample file in trail mail. On Thu, Apr 11, 2013 at 12:48 PM, C.G.Kumar wrote: > Thanks for trying but still the solution is not useful to me. > > Let me explain correctly; Auto filter based on condition. > > Data is available in range (say A6:I6) and i need

$$Excel-Macros$$ Re: Filter Data based on Criteria

alues). I >> can do it manually by selecting filter and then selecting manually each >> criteria like Name = Adag, Amount > 5000 and so on . >> >> >> Is there any way where the list get auto filtered based on criteria >> mentioned at the top of the list o

Re: $$Excel-Macros$$ Filter Data based on Criteria

Wed, Apr 10, 2013 at 6:03 PM, xlstime wrote: > Hi CG, > > Please try to use Advance filter and macro recording.PFA > > > > > . > > Enjoy > Team XLS > > > > On Wed, Apr 10, 2013 at 1:58 PM, C.G.Kumar wrote: > >> Hi, &

$$Excel-Macros$$ Filter Data based on Criteria

of the list or something alike. Attached sample workbook with Sample Data, output expected. Thanks for understanding. C.G.Kumar -- 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 @ ht

Re: $$Excel-Macros$$ Macro for filter data & send it to respective user through mail

Can we do the same thing using Lotus Notes On Fri, Mar 15, 2013 at 10:58 AM, अनिल नारायण गवली wrote: > Dear Sagar, > > Enclosed herewith the required data. Is it Ok ? Tell me . > > Files are save in C:\Anil. > note:- When file are saved in the required dir. then automatically one > message box

Re: $$Excel-Macros$$ Extracting Text from Cell

Thanks Anoop for helping & supporting me. Regards, C.G.Kumar On Fri, Dec 7, 2012 at 9:40 AM, Anoop K Sharma wrote: > Use the Ashish's formula for second case. > > Regards, > Anoop > > > > On Thu, Dec 6, 2012 at 8:01 PM, ashish koul wrote: > >

Re: $$Excel-Macros$$ Extracting Text from Cell

It worked. Thanks a lot. On Thu, Dec 6, 2012 at 8:01 PM, ashish koul wrote: > try this > > =RIGHT(G4,LEN(G4)-FIND("~",SUBSTITUTE(G4," > ","~",LEN(G4)-LEN(SUBSTITUTE(G4," ","") > > > > > On Thu, Dec 6, 2012 at 4

Re: $$Excel-Macros$$ Extracting Text from Cell

; > > On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar wrote: > >> >> Hi , >> >> >> I need to extract a relevant portion from Excel cell. >> >> Attached example file. >> >> >> Many Regards, >> >> C.G.Kumar >> >&g

$$Excel-Macros$$ Extracting Text from Cell

Hi , I need to extract a relevant portion from Excel cell. Attached example file. Many Regards, C.G.Kumar -- 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

$$Excel-Macros$$ Macro to mail using Excel worsheet

May i ask to help me in the following scenario; 1. I have excel work sheet which enlist customer having outstanding dues . I need to send e mail to these customer on this list twice a day daily . Attached excel have sample of records. Is it possible to do it through macro . That is to Send ma

Re: $$Excel-Macros$$ Basic Macro *: Mail fromExcel Sheet data

Thanks Noorain. It is very informative and useful. I am trying to learn macro from this. May i as k to help me in the following scenarion; 1. I have excel work sheet which enlist customer having outstanding dues . I need to send e mail to these customer on this list twice a day daily . Attac

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Sir, Could you plz explain how did you got the pic in worksheet 3 from worksheet 4 as the function yields to 0 when pasted in other area. Regards, C.G.Kumar On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Sheet to use 10 Simple w

Re: $$Excel-Macros$$ Conditional Lookup or data validation

Thanks Daniel. It really works. Regards, C.G.Kumar On Sat, Aug 27, 2011 at 3:26 PM, Daniel wrote: > Hello, > > ** ** > > See attached workbook. > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-ma

$$Excel-Macros$$ Conditional Lookup or data validation

Dear All, PFA sample file for your kind consideration. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$Excel-Macros$$ Conditional data validation

Dear All, PFA sample file for your kind consideration. Regards, AMW-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Re: delete workbook if password is not entered

Hi Sam, The reader has sought for code to delete file if Password doesn't matches in three attempts. You have provided code to delete file without prompting for password match by oversight. Hope you will be amend the same. Regards, C.G.Kumar On Thu, May 5, 2011 at 1:58 AM, Golden

Re: $$Excel-Macros$$ Outlook 2007 Calendar Meeting Setup to Excel 2007

roup. Regards, C.G.Kumar Is there a way out. On Tue, May 3, 2011 at 2:24 AM, ChilExcel wrote: > see this link , that's what you need > > > http://office.microsoft.com/en-us/outlook-help/export-calendar-data-to-excel-HP001087241.aspx > > > Chilexcel > > > >

Re: $$Excel-Macros$$ SEARCH FUNCTION

No file found. On Mon, Apr 18, 2011 at 7:31 PM, Daniel wrote: > Hi, > > Please, attach file ;-) > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* C.G.Kumar > *Envoyé :* lundi 18 avri

Re: $$Excel-Macros$$ Re: Search Formula

Thnaks Ashish. It is very useful but i am not getting desired output when i copy VBA code to my actual workbook.Please suggest Where i have to make change. Regards, C.G.Kumar On Mon, Apr 18, 2011 at 6:18 PM, ashish koul wrote: > try this see if it helps > > On Mon, Apr 18, 2011 a

Re: $$Excel-Macros$$ Fwd: SEARCH FUNCTION

Thanks . I have modified the formula to suit my requirement as follows; SMALL(IF(ISNUMBER(SEARCH((Report!B1),C2:C28,1)),ROW(1:28),ROW(1:28)) Thanks buddy for giving me the direction. Regards, C.G.Kumar On Mon, Apr 18, 2011 at 3:33 PM, STDEV(i) wrote: > plese check the attached workb

Re: $$Excel-Macros$$ Search Formula

*formula only & not macro.* Regards, C.G.Kumar On Mon, Apr 18, 2011 at 2:43 PM, rajan verma wrote: > you should apply contain Filter.. i think > > > On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar wrote: > >> Hello, >> I have a very tricky problem. I have got an excel sheet

$$Excel-Macros$$ Search Formula

, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel

$$Excel-Macros$$ SEARCH FUNCTION

Dear All, I intend to generate list based on search of Text String.Sample file attached. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

$$Excel-Macros$$ Fwd: SEARCH FUNCTION

PFA sample File. -- Forwarded message -- From: C.G.Kumar Date: Mon, Apr 18, 2011 at 1:45 PM Subject: SEARCH FUNCTION To: excel-macros@googlegroups.com Dear All, I intend to generate list based on search of Text String.Sample file attached. Regards, C.G.Kumar

$$Excel-Macros$$ Hyperlink embedded object in excel

Sir, I have 12 picture embedded in Sheet 1 and i intend to create a hyper link in Sheet 2 for each picture. Is it possible to do without Macro run. Referencing to nearby cell is not worthy. Regards, C.G.Kumar

Re: $$Excel-Macros$$ MACRO :PASTE SPECIAL

Hi All, Yes. Thank you all for the generosity displayed for me . This is working now. But, the macro causes loss of formating i.e. Column & row width . Is it possible to avoid this. Thanks in Advance. Regards, C.G.Kumar AMW-2 On Wed, Apr 13, 2011 at 1:39 AM, hanumant shinde wrote:

$$Excel-Macros$$ MACRO :PASTE SPECIAL

Dear all, Following code i am using to select each worksheet (except ) to copy and paste special values in each worksheet in same workbook. But, i am not getting desired output . Could you one help to rectify the following code; Sub ConvertToValues() Dim ws As Worksheet For Each ws In Worksheet

Re: $$Excel-Macros$$ Copy Each Worksheet in a workbook and save it to Specific Location with time.

cify which worksheet he intend to copy. Thanks & Regards, C.G.Kumar On Mon, Apr 11, 2011 at 6:22 AM, ashish koul wrote: > see if it helps > > change > > pathbk = "C:\Documents and Settings\achamanlalko\Desktop\eforms\eform > reports\test workbook\" t

$$Excel-Macros$$ Copy Each Worksheet in a workbook and save it to Specific Location with time.

o 0 Application.DisplayAlerts = True CurWkbook.Worksheets(wkSheet.Name).Copy Before:=newWkbook.Sheets(1) 'no duplicate sheet1 because they begin with "a" ActiveWorkbook.Save ActiveWorkbook.Close Next wkSheet Application.StatusBar = Fal

$$Excel-Macros$$ Fwd: Data Chart

one suggest me any alternative manner. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

$$Excel-Macros$$ Data Chart

one suggest me any alternative manner. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

Re: $$Excel-Macros$$ Re: Can We creat Auto Mailer In Excel.

Its awesome.Hats off to Ashish. Regards, C.G.Kumar On Thu, Apr 7, 2011 at 10:35 AM, ashish koul wrote: > try this > > On Thu, Apr 7, 2011 at 9:10 AM, Harkesh Kumar > wrote: > >> Hi Experts, >> >> >> We required your help for creat auto mailer in excel.

Re: $$Excel-Macros$$ Countif Problem

Hi, Pls find attached file & let me know if it serve the purpose. Regards, C.G.KUMAR On Sun, Apr 3, 2011 at 1:39 PM, Suryaprasad wrote: > Hi Team / Ayush, > > Need a formula about a countif criteria > > See the attachment and please do the need full &

Re: $$Excel-Macros$$ Select numbers date wise using a formula

Sir, Is it possible to select two criteria. In the given case Date and Room number and then sort by date. Regards, C.G.Kumar On Fri, Mar 25, 2011 at 8:55 PM, STDEV(i) wrote: > 1. > formula HELPER > ( creating list of RowIndex ) > array formula in multi cells > =IF(ISNUMBER($

Re: $$Excel-Macros$$ Re: Identify the room status by color code

PFA file. Hope it serve the purpose. Regards, C.G.Kumar On Sun, Mar 27, 2011 at 8:06 AM, STDEV(i) wrote: > oops, the attachment > > > > On Sun, Mar 27, 2011 at 9:35 AM, STDEV(i) wrote: > >> please find attached >> and see if it helps >> >> be

Re: $$Excel-Macros$$ Unique records

Thanks Divakar. Fantastic application of logic to get the output. Regards, C.G.Kumar On Tue, Feb 8, 2011 at 8:14 PM, Divaker Pandey wrote: > hi, > > Please find this one > > > > On Tue, Feb 8, 2011 at 10:10 AM, C.G.Kumar wrote: > >> Thanks sir, >> >&g

Re: $$Excel-Macros$$ Unique records

Thanks sir, It works.Could you please elaborate the steps in the formula, if possible. Regards, C.G.Kumar On Mon, Feb 7, 2011 at 3:56 PM, Manoj kumar wrote: > Hi C.G, > > A little complex but hope this might help your needs... > > > Regards, > Manoj Kumar > > >

Re: $$Excel-Macros$$ Unique records

innovative and i would apply the same. I once again thanks for the courteous support. Regards, C.G.Kumar On Mon, Feb 7, 2011 at 10:27 PM, rajan verma wrote: > Hi > Find attachment > > Rajan > > > On Mon, Feb 7, 2011 at 2:26 AM, Manoj kumar < > manoj.vishwakarma..

Re: $$Excel-Macros$$ Unique records

have same basic and therefore, filter criteria by unique records destroys the objective. Objective is to generate file having records as to when basic has changed for the concerned over the period of time. Thanks & Regards, C.G.Kumar On Mon, Feb 7, 2011 at 1:12 PM, ashish koul wrote: &

Re: $$Excel-Macros$$ Official launch of Knowledge Portal - discussexcel.com

I TOO INTEND TO CONTRIBUTE. On Wed, Feb 2, 2011 at 9:09 PM, Ayush wrote: > Hello everyone, > > I am glad to share that I have decided to launch an excel knowledge website > for this group.The website will be launched on 4th anniversary of this group > i.e. 17th March 2011. > > The designing of t

Re: $$Excel-Macros$$ Array If

USE THIS =IF(A$8$:$A$14="a",1,"") If u want to use as an array use cntr+shift+enter. It will give u proper result. Thanks & Regards, C.G.Kumar On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde wrote: > Hi Friends, > > I want to use IF condition like i used b

Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened

Task completed, in process,yet to start etc, ) i thought a macro would be handy to accomplish my task. Regards, C.G.Kumar On Mon, Dec 20, 2010 at 7:58 PM, Paul Schreiner wrote: > For this to work, it must be in EACH Excel file that you wish to open! > > It will not work for "

Re: $$Excel-Macros$$ Facing calculation issue using Time type in excel

Paul, I must admit that you are genius as the way of you explained the thing in such a lucid manner that a naive person like me understood at first sight... Unbelievable ..Many Many Thanks again to you Paul as you devoted your precious time for us... Thanks & Regards, C.G.Kumar On

Re: $$Excel-Macros$$ Facing calculation issue using Time type in excel

. Thanks & Regards, C.G.Kumar On Sat, Dec 18, 2010 at 10:29 PM, Bharghav Ramdas wrote: > > Thanx Paul. > > > > On Thu, Dec 16, 2010 at 1:31 AM, Paul Schreiner wrote: > >> Keep in mind that Excel doesn't know "time". >> It knows "numbers&q

Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened

o low & i require this macro to run whenever i open any excel file. but this is not working.Any suggestion. Thanks & Regards, C.G.Kumar On Sat, Dec 18, 2010 at 6:53 PM, Richard wrote: > Create a sub called "sub workbook_open" in "this workbook" and call > your ma

Re: $$Excel-Macros$$ Run a macro every time excel is opened

ty to low & i require this macro o run whenever i open excel file. but this is not working.Any suggestion. Thanks & Regards, C.G.Kumar On Sat, Dec 18, 2010 at 7:30 PM, ashish koul wrote: > write the code in workbook open module > > > On Sat, Dec 18, 2010 at 5:04 PM, C.G.K

$$Excel-Macros$$ Run a macro every time excel is opened

I want a macro to run every time when an excel file is opened. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN gro

Re: $$Excel-Macros$$ Require specific entry in a cell or nothing

Use data validation and specify the exact requirement. On Sat, Dec 18, 2010 at 4:07 AM, Richard wrote: > Is is possible to require a specific entry in a cell, or nothing? > > If someone makes an entry in a cell, I want it to be ABC (all upper > case) and nothing else. It's OK for the cell to be

Re: $$Excel-Macros$$ New Rupee Symbol

THANKS. . BUT IT PREVENTS THE ARITHMETIC CALCULATION .. On Sat, Dec 18, 2010 at 11:03 AM, manhar prajapati < prajapati.man...@gmail.com> wrote: > 1 select font of Ruppee furdine in Excel > > 2 Use ` symbol for Ruppee symbol > > manhar > > On Sat, Dec 18, 2010 a

$$Excel-Macros$$ New Rupee Symbol

he fallacy. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/

Re: $$Excel-Macros$$ Need help to get the collection date with the help of formula

No attachment found. On Fri, Dec 10, 2010 at 3:16 PM, lucky singh wrote: > > Hi All, > > kindly help me to get the collaction date with the help of an formula... > > please refer the attachment... > > > Regards, > Lucky > > -- > > -

Re: $$Excel-Macros$$ if formula help

Solved & file Attached. Hope it serves the purpose. Regards, C.G.Kumar On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit wrote: > Dear All, > > please help me with the formula where in I should get the result > > 1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400

$$Excel-Macros$$ Fwd: Macro to select particular record based on criteria.

. Regards, C.G.Kumar AMW-2 Code: Sub Macro3() ' ' Macro3 Macro ' ' Range("A2").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.AutoFilter Range("J2").Select ActiveSheet.Ra

$$Excel-Macros$$ Macro to select particular record based on criteria.

for ready reference. I am an optimist and feel there is way. Hope much experienced people could show me some light. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Zooming of Excel Sheet.

Yes. Cool stuff. Thanks for the help. Regards, C.G.Kumar On Tue, Nov 23, 2010 at 4:03 PM, kiran Kancharla wrote: > U need to change the options. > > Tool ---> Options --> General "Zoom on roll with Intellimouse" > > This has to Uncheck. > > > plea

Re: $$Excel-Macros$$ Zooming of Excel Sheet.

"Ms-Exl-Learner ." > wrote: > > Check whether your cntrl button is working. > > > > > > Ms-Exl-Learner > > ---- > > > > On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar >wrote: > > > > > >

Re: $$Excel-Macros$$ Zooming of Excel Sheet.

Yes cntrl button is working. On Mon, Nov 22, 2010 at 11:44 PM, Ms-Exl-Learner . wrote: > Check whether your cntrl button is working. > > > Ms-Exl-Learner > > > > On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar wrote: > &

$$Excel-Macros$$ Zooming of Excel Sheet.

Can any body tell me how to rectify. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

Re: $$Excel-Macros$$ VBA Help

You can use EDATE if using Excel 2007. Rest you can define in Macro. Regards, C.G.Kumar On Sat, Oct 23, 2010 at 12:07 AM, halpie97 wrote: > I'm a beginner with VBA and looking for some guidance in how to > establish what I'm trying to do. > > Column A Column B Colu

Re: $$Excel-Macros$$ Stander O/s Format

I could not identify whether it is a solution or your query.If this is solution pls ignore my mail, otherwise you may please explain the objective and problem. Thanks & Regards, C.G.Kumar On Sat, Oct 9, 2010 at 2:20 PM, SUMIT VYAS wrote: > Thanks For all member of Excel-macro

Re: $$Excel-Macros$$ Quick help needed to Find duplicate by formula

Use the following formulae ; IF(COUNTIF(A$1:A1,A1)=1,"Unique","Dupl") Hope it serve the purpose. Thanks & Regards, C.G.Kumar On Wed, Oct 13, 2010 at 8:43 PM, vinod rao wrote: > HI > > I have multipal duplicate numbers and excluding one for others it

Re: $$Excel-Macros$$ Macro to run on specific day.

You explained the logic in a precise and logical manner.I really appreciate your way of explaining. So nice of you Mr.Paul. Thanks & Regards, C.G.Kumar On Wed, Oct 13, 2010 at 7:48 PM, Paul Schreiner wrote: > Let's examine what you're asking: > > (Now) returns th

Re: $$Excel-Macros$$ Macro to run on specific day.

; if day(date) >= 5 and day(date) <=10 then > > * *your full macro* > * > end if > > end sub > > > > > > On Wed, Oct 13, 2010 at 12:26 PM, C.G.Kumar > wrote: > > Dear All, > > I want my macro to be executed only for specific day in a month bas

$$Excel-Macros$$ Macro to run on specific day.

Dear All, I want my macro to be executed only for specific day in a month based on system date and it should not run thereafter. Kindly let me know the code for it.It's urgent. Regards, C.G.Kumar -- --

Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

THANKS. BUT IT SERVE THE PURPOSE PARTIALLY...IN ADDITION I HAVE TO CONSIDER ONLY FY 2009-10 WHEREAS FORMULA TAKES BEYOND 31/03/2010.3 IS IT POSSIBLE TO REVISE THE FORMULA. REGARDS, C.G.KUMAR On Fri, Oct 8, 2010 at 2:19 PM, ashish koul wrote: > check the atatchment see if it he

$$Excel-Macros$$ Conditional Sum or Sumproduct.

I am looking for conditional sum i.e. sum based on criteria. But neither Sumproduct nor SUMIFS and Pivot serve the purpose. Attached sample file . Hope you will be able to solve the crux. Regards, C.G.Kumar

$$Excel-Macros$$ Conditional Sum or Sumproduct.

Attached sample file for the problem. Hope somebody among you will be able to solve the crux. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

$$Excel-Macros$$ Conditional Sum or Sumproduct.

Attached sample file for the problem. Hope somebody among you will be able to solve the crux. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Numer To Text

> > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > htt

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

<><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Re

Re: $$Excel-Macros$$ What is budget mis

glegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discus

Re: $$Excel-Macros$$ Excel 97 - Windows 7

. Regards, C.G.Kumar On Mon, Sep 13, 2010 at 12:13 AM, stuartR wrote: > Currently running Excel 97 on XP, everything works just fine. > > I am about to buy a new computer that will arrive loaded with Windows > 7 > > I understand the Office97 / Excel 97 will not work on Windows 7,

$$Excel-Macros$$ Re: Lookup from date series

Hi Kalyan, Please find enclosed file as modified to suit your requirement. Hope it serve the purpose. Regards, C.G.Kumar On Thu, Sep 9, 2010 at 3:21 PM, Kal xcel wrote: > Hi Kumar, > > Please find the attached file. > > Thanks in adv

Re: $$Excel-Macros$$ Lookup from date series

File attached. Check whether it serve the purpose. Regards, C.G.Kumar On Wed, Sep 8, 2010 at 10:59 AM, Kal xcel wrote: > Dear Experts, > > I need a help, I want to lookup value from selected dates. > > File is attached > > Thanks

Re: $$Excel-Macros$$ Capture DATA>From Web - Portfolio Tracker

Kamal, Thanks for the suggestion but i did not found any shortcut/query for extracting data directly in Excel. Regards, C.G.Kumar On Tue, Sep 7, 2010 at 7:07 PM, kamal shah wrote: > C.G Kumar, > > I assume you need realtime Stock prices coming to Excel sheet, is that > rig

$$Excel-Macros$$ Capture DATA>From Web

Dear All, I need to capture Current Market Price of given scrip in Excel.I have used DATA>From Web. But, it difficulty is that it captures entire data and not only scrip CMP. Thanks & Regards, C.

Re: $$Excel-Macros$$ Conditional Formating

Follow the link; 1.http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html 2. http://www.free-training-tutorial.com/conditional-formatting.html On Mon, Sep 6, 2010 at 8:36 AM, Pankaj Kumar wrote: > Hi all, > > i am new in msexce

Re: $$Excel-Macros$$ extract only product name

ANDY, Could you please explain the use of "^^" in the formula. Thanks & Regards, C.G.Kumar On Wed, Sep 1, 2010 at 5:53 PM, Aindril De wrote: > Hi Kalyan, > > You can use the following formula in the cell B2 and then copy it down > > =LEFT(A2,LEN(A2)-(LE

Re: $$Excel-Macros$$ Top Poster of the month :- Dave Bonallack

Congrats Dave. I wish you will continue to do this in coming months too and enrich our group forum. Regards, C.G.Kumar On Fri, Sep 3, 2010 at 10:31 AM, Ayush wrote: > Hi Group, > > I am glad to announce that Dave Bonallack has topped in posting for > the month of Aug'10 wit

Re: $$Excel-Macros$$ IF(OR(ISERROR challenge

Kindly attach sample file. On Wed, Sep 1, 2010 at 12:12 AM, Kurt wrote: > Can't seem to get this working. > > If A1 is a calculated error (e.g., #NULL) OR If A1 = "--- ", make > B1 = "NA" > > Otherwise: If A1 < Y1, make B1 = "!", otherwise make B1 = "" (i.e., > blank). > > This is what I hav

Re: $$Excel-Macros$$ Debit Note Format in Excel

On Tue, Aug 31, 2010 at 11:41 AM, C.G.Kumar wrote: > Dear All, > > > Debit note format in excel is required. If any one has kindly forward. > > Thanks & Regards, > > C.G.Kumar > > -- > > -

$$Excel-Macros$$ Debit Note Format in Excel

Dear All, Debit note format in excel is required. If any one has kindly forward. Thanks & Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Need help deleted column in excell sheet

In my opinion, data lost. On Fri, Aug 27, 2010 at 6:54 AM, Idhrees Mohamed wrote: > Dear guys, > > > > I have a excel sheet with big data. Its contain one date column > unfortunately I delete and save it. It’s possible to recover that > column. > > > > Thanks in Advance. > > > > Regards, > >

Re: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell into another two cells

Could you please attach sample file. Thanks & Regards, C.G.Kumar On Fri, Aug 27, 2010 at 10:21 AM, Ankit Agrawal wrote: > Hello Sir, > > I have a data in which a column having the both numeric and alphabetically > value but i want to separate these value into two column or

Re: $$Excel-Macros$$ hi

Press F1 Key and see the examples. On Fri, Aug 27, 2010 at 10:54 AM, Pankaj Kumar wrote: > Hi, > > Can anyone help me to understand what is Vlookup & Hlookup,for a short > example how to use it ,, > > -- > *Warm Regards > Pankaj kumar > M: 9899816107 > e-mail: rajputpanka...@gmail.com >

  1   2   >