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
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:
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
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
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:
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
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.
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
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
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
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("
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
>
> --
>
> -
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
>
> --
>
> -
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
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
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
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*
--
-
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
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
19 matches
Mail list logo