Hi Nadine,
I've sent you an email with a file that hopefully does what you want.
Please don't answer by email, since I have a quite selective spam-
filter. Please post to this newsgroup instead. Thanks.
Stuart Redmann wrote:
I guess that what you wanted to say is that you want to
get the sum
Dear All
Earlier i had got an excel file in which bse prices are automatically
updated like that way i need to track lme prices. can any one help on this .
Regards
LKModi
--
--
Some important links for excel
you used to pivot table..
--
--
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 @
Try this,
But check it may have adverse effects,
Private Sub CommandButton2_Click()
UserForm1.Show 0
End Sub
Also check for help on SHOW method ( modal/nonmodal forms).
Share with me if you have any problems
Bye,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Aug 5, 6:38 am,
Agreed with your point, but i want that if i required so i can only
see any other Excel file while opening a Form. I dont want to do any
thing on that file just want to see for refrence.
Kindly suggest
Regards
Pankaj k Pandey
On 8/5/10, Intelligent But Crazy secrets...@gmail.com wrote:
Hi Dav,
As per my policy, replacing/deleting any rows/values is not a good
idea.
I will simply use pivot table or subtotals command on the data and get
the results in another sheet.
Regards,
Kishan Reddy, K
On Aug 4, 4:11 pm, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Angelo,
Have a look at
First of all,
Let me know why you want you use such type of objects, in excel, when
the same can be done through simple formulas and simple macros.
Let me understand the purpose.
Regardds,
Kishan Reddy, K
On Aug 2, 12:26 pm, Stuart Redmann dertop...@web.de wrote:
Santiago Afonso wrote:
Sudhir,
Why can't you use Track changes from Tools menu?
Regards,
Kishan Reddy, K
On Aug 4, 7:51 pm, sudhir kumar sudhir.p...@gmail.com wrote:
Thanks stuart for ur reply, but, macro record is work for when u r using
same type of command again and again, but this time issue is different
Hi Dave,
Thanks for responding. No, I haven't gotten an answer so thank you, thank you,
thank you for helping me.
Sheet 1 contains the details and Sheet 2 is the summary. So, Sheet 1 B, C, D
has information that may show the same on multiple lines due to different
information in the others
Unfortunately I didn't receive an email from the email address I see below for
you. I did receive one from someone who signed the email as Stuart but with a
different name in the email address. Was that you? If so, it will work. I
need to add in all the 20+ payment columns which will make
This seems to be missing your text, Kumar. :(
From: Kumar Punnam mr.ravikumar@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, August 5, 2010 6:29:35 AM
Subject: Re: $$Excel-Macros$$ Sumproduct with 3 criteria +
On Tue, Aug 3, 2010 at 5:54 PM,
hi all, can anybody help me out in the below problem., its urgent,
thanks..., saber
-- Forwarded message --
From: mohd ateeq atee...@gmail.com
Date: Mon, Aug 2, 2010 at 10:30 PM
Subject: Fwd: $$Excel-Macros$$ Re: automation error
To: excel-macros@googlegroups.com
hi all,
can
For track changes u have to share the workbook... thats why i m not using
that.
On Thu, Aug 5, 2010 at 2:15 PM, Kishan Reddy, K
kishanreddy.kethire...@gmail.com wrote:
Sudhir,
Why can't you use Track changes from Tools menu?
Regards,
Kishan Reddy, K
On Aug 4, 7:51 pm, sudhir kumar
hi friend,
i have a problem , i made two graph in excel sheet intersecting with each
other. now i want to highlight the value of the intersection point. plze
help
--
Regards-
Sudhir Kumar
Design Engineer,
Conceptia Software Technologies Pvt. Ltd.
Email id-sudhir.p...@gmail.com,
--
Sudhir,
I am assuming by the subject matter of your posting you need to find
the X and Y coordinates of any place on the graph where series 1 and
series 2 intersect. So if I understand your request correctly, this
should help
Lets put your X axis coordinates in cells B4 through E4. So in cell B4
Thanks for the advice. :)
2010/8/5 Kishan Reddy, K kishanreddy.kethire...@gmail.com
As per my policy, replacing/deleting any rows/values is not a good
idea.
I will simply use pivot table or subtotals command on the data and get
the results in another sheet.
Regards,
Kishan Reddy, K
On
Sheet 1 contains
# Date
1001 03/01/10
5252 02/15/10
1001 02/15/10
1001 02/15/10
1001 08/02/10
5252 03/15/10
5252 01/06/10
2355 04/12/10
1001 06/10/10
1001 03/14/10
2355 01/06/10
Sheet 2 contains
# Last Date
1001 8/2/2010
5252 3/15/2010
2355 4/12/2010
The dates in sheet 2 in
Thanks a lot Krisnan
It is working.
I really appricieat your knowladge, I m glade to get help from you.
Regards
Pankaj k PAndey
On 8/5/10, Kishan Reddy, K kishanreddy.kethire...@gmail.com wrote:
Try this,
But check it may have adverse effects,
Private Sub CommandButton2_Click()
Use pivot table, use# column in ROW area Date in DATA area, change Count
of Date to Max of Date, format the data area to date format. Then Hide
the grand total.
Srinivasan Ethirajalu
On 8/5/10, Nadine S n8dine4ma...@yahoo.com wrote:
Sheet 1 contains
# Date 1001 03/01/10 5252 02/15/10
# Date Max of Date 1001 8/2/2010 # Total 1001 6/10/2010 1001
8/2/2010 1001 3/14/2010 2355 4/12/2010 1001 3/1/2010 5252 3/15/2010 1001
2/15/2010 1001 2/15/2010 2355 4/12/2010 2355 1/6/2010
5252 3/15/2010 5252 2/15/2010 5252 1/6/2010
On 8/6/10, Srinivasan Ethirajalu
20 matches
Mail list logo