RE: $$Excel-Macros$$ How to sum on the basis of color

Hi, The attached uses a macro to do your bidding. But I think XL2007 can do this without macros, but I only have XL2003. Regards - Dave Date: Thu, 19 Nov 2009 12:45:00 +0530 Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color From: manojsnegi.uttranc...@gmail.com To: excel-macro

RE: $$Excel-Macros$$ Plz Urguntly Help needfull

Hi Anil, Do you want the value in the same cell as the one you write the name in? If so, do you want the value to replace the name? (ie, "Anil" automatically changes to "100") Or do you want the value added to the name? (ie, "Anil" automatically becomes "Anil 100") Regards - Dave. Date:

Fwd: $$Excel-Macros$$ How to sum on the basis of color

Hi All, please help on this Unfeigned Regards Manoj S Negi Skype - manojsnegi -- Forwarded message -- From: Manoj S Negi Date: Wed, Nov 18, 2009 at 12:56 PM Subject: $$Excel-Macros$$ How to sum on the basis of color To: excel-macros@goog

$$Excel-Macros$$ Plz Urguntly Help needfull

Hi All Plz suggest me how to use formula like these e. g. when i written any names automatically put value. Anil 100 Saxena 70 Guni 150 Sonu 50 Yash 65 Thakur 57 Mathur 49 -- -- Some important links for excel u

$$Excel-Macros$$ Re: Macro to add row in two sheets

Hi All, Please help me in the second query that i have asked before, Lets suppose i am adding some rows after row 20th, it should take the 1st inserted row i.e. row 4, and paste in all newly created rows. Please help as this is very urgent Regargs, Kunal Rout On Nov 17, 7:45 am, kunal wrote:

Re: $$Excel-Macros$$ Urgent help on simple macro

I got it, I changed Integer as long and worked fine. Thanks all the memeber in this group, On Wed, Nov 18, 2009 at 10:24 PM, vinod rao wrote: > No Sir, > > It did not go below 6500 lines.It stoped in that cell. > > I have data till end of the sheet. > > Plz help > On Wed, Nov 18, 2009 at 8:25

Re: $$Excel-Macros$$ Urgent help on simple macro

No Sir, It did not go below 6500 lines.It stoped in that cell. I have data till end of the sheet. Plz help On Wed, Nov 18, 2009 at 8:25 PM, PMann wrote: > Try this: > > Sub Tisp2Core() > Dim lngLastRow As Long, i As Long > Application.Goto Reference:="R6500C2" > lngLastRow = Selection.

$$Excel-Macros$$ Fwd: Urgent Help required

Hello Everyone, Can you help me with my query. I have updated everything i require in the attached excel. Regards, Hemant Shah Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intende

Re: $$Excel-Macros$$ Urgent help on simple macro

Hi Andy, I have too many rows in In the Column B. that is 6 cells, and I am getting error "Run Time error 6" Overflow. Plz help me to tackel this issue. Regards, VR On Tue, Nov 17, 2009 at 8:46 PM, Aindril De wrote: > Hi VR, > > Please use the following code: > > Sub TispPAT() > 'Macro cr

Re: $$Excel-Macros$$ heyerlinking many cells

Thanks On Oct 12, 8:39 am, RolfJ wrote: > If I correctly understandNader'srequirement he would like to > hyperlink each cell in one sheet to the corresponding cell in a second > sheet (not all cells to cell A1 of the second sheet). I am not aware > of a simple copy and paste route that would acco

Re: $$Excel-Macros$$ Urgent help on simple macro

Try this: Sub Tisp2Core() Dim lngLastRow As Long, i As Long Application.Goto Reference:="R6500C2" lngLastRow = Selection.End(xlUp).Row Do If UCase(Range("B4").Offset(i, 0).Value) = "TISP" And _ UCase(Range("B4").Offset(i, 3).Value) = "CORE" Then Range("

Re: $$Excel-Macros$$ Plz needful request

PLZ USE V LOOKUP... On Wed, Nov 18, 2009 at 12:48 PM, Anil Saxena wrote: > > Hi All > > Plz suggest me how to use formula like these e. g. when i written any names > automatically put value. > > > >Anil 100 Saxena 90 Guni 80 Sonu 70 Yash 60 Thakur 50 Mathur 40 > > -- > > -

Re: $$Excel-Macros$$ Plz needful request

YOu need a Dlookup or a Custom List. On Wed, Nov 18, 2009 at 2:18 AM, Anil Saxena wrote: > > Hi All > > Plz suggest me how to use formula like these e. g. when i written any names > automatically put value. > > > >Anil 100 Saxena 90 Guni 80 Sonu 70 Yash 60 Thakur 50 Mathur 40 > > -- > > -

$$Excel-Macros$$ Escalation

Hi, I have a spreadsheet with a "Date Entered" column and a "Days Open" column. Every time a new record is added, the date is put in the "Date Entered" column and a formula in the "Days Open" column calculates the number of days between the date entered and when the Status is marked closed. Is it

Re: $$Excel-Macros$$ Plz needful request

Hi Anil, Use below logic:- *Names Formula* a 100 b =IF(A2="","",B1-10) c =IF(A3="","",B2-10) Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Nov 18, 2009 at 12:48 P

Re: $$Excel-Macros$$ Urgent help on simple macro

Hello Andy and Deepak, I want to find a specific headder and delete entire row. For example i have a headder called Name in A10 row and below name headder there are many names entered, what macro should do is, it should find headder "Name" and delete entire Column A:A or A10 to A65000. In other

$$Excel-Macros$$ How to some on the basis of color

Hi All, Kindly help me out as I want to sum the no. as per the color. Is there any command by which we can sum the data as per color. Sheet is also attached for further reference. Hoping for a favorable response soon. *Unfeigned Regards Manoj S Negi Skype - manojsnegi* -- -

$$Excel-Macros$$ Plz needful request

Hi All Plz suggest me how to use formula like these e. g. when i written any names automatically put value. Anil 100 Saxena 90 Guni 80 Sonu 70 Yash 60 Thakur 50 Mathur 40 -- -- Some important links for exce

Re: $$Excel-Macros$$ Urgent help on simple macro

Please how can i put a file attached? i have a solution to this probleme ! Thank's -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelite