Hi Venkat,
Sounds like a job for SUMPRODUCT.
We could probably do the needful if you attached a sample worksheet.
Regards - Dave.
Date: Wed, 27 May 2009 09:19:07 +0530
Subject: $$Excel-Macros$$ Formula needed
From: sudhakar...@gmail.com
To: excel-macros@googlegroups.com
Dear Friends,
I
Venkat, can you post us a sample file..so that it would be easier to us to
help out...?
On Wed, May 27, 2009 at 9:19 AM, venkat sudhakar sudhakar...@gmail.comwrote:
Dear Friends,
I need a formula for my work.
There will be 2 Excel sheets.
In First Sheet there will be 2 Columns
In First
this runs fine for me and does not require any extra reference library. can
u tell me your excel version n browser u have.. make sure u have some data
in column A... i don't have any error handling in the code.. debug and see
where u have the problem
On Tue, May 26, 2009 at 3:51 AM, Upendra Singh
Hello Venkat,
Can you provide me with the excel sheet? Or against correponding code in
second sheet. Apply formula =SUMIF('Sheet1'!(range of your data)'(code name
cell number)
Thanks and Regards
Atul Kesaria
On Wed, May 27, 2009 at 9:19 AM, venkat sudhakar sudhakar...@gmail.comwrote:
Dear
I want some assistance for the following:
I want to be able to click on some points on a chart and have those
values for those points stored in a column of the spreadsheet.
Thanks for any assistance.
Nila
--~--~-~--~~~---~--~~
I have done some experiments on this. Yes, you can do it by way of
sub-classing the MsgBox but that is really very cumbersome, instead try
creating a user form with the features whatever you want and use it as
MsgBox that is more easier than sub-classing.. (Link provided by bhaskar was
very
Hello Dave,
One small issue in the macro, the cell number b2 in the formula remain
the same across all the row when we run the macro, however it should changes
as the row changes.
Please help.
Thanks and Regards
Atul Kesaria
On Wed, May 27, 2009 at 11:11 AM, Atul Kesaria
I'm trying to import into a sheet an HTML table.
The problem is that parsing html string is not so easy .. can you
advice me a function or a way to spread HTML cells in Sheet cells ?
Any help appreciated.
Best regards.
--~--~-~--~~~---~--~~
hello
i want currency to be shown in terms of lacs crores instead of millions.
can anyone provide help on comma presentation ?
any add in for that ?
-harsh.
--~--~-~--~~~---~--~~
Hi venkat...
if i have understood your problem, following shud serve the purpose
Can try SUMIF function.
1. In second Sheet if the code is in A1 then type in cell say C1, =sumif(
2. Go to sheet one and select the range from A1 to end of Column A (if
column A contains Code) press F4 to
Hi Frnds,
Try using following code:-
Sub datee()
Range(b1).Select
Selection.End(xlDown).Select
'Selection.End(xlUp).Select
'ActiveCell.Offset(1, 0).Select
If ActiveCell.Value = Date Then
Range(A1).Select
Else
ActiveCell.Value = Date
End If
End Sub
The workbook is also attached having the same
hi bala
can u suggest me for saving the file
i want to save as file name with current date.
can u give me a VBA Code please
On Wed, May 27, 2009 at 2:13 PM, bala bal...@gmail.com wrote:
Hi,
Try this code
Range(A1).select
while Activecell.value
if len(Activecell.value) 3
You're leaving WAY too much information out.
For instance, what version of Excel are you using?
What format do you want to save it in?
WHERE do you want to save it?
What do you want to call it?
and... How much experience do you have with VBA?
=
The
Hi Friends,
I think this would be the solution to this problem.
Sub datee()
Dim rid As Integer
Sheets(Sheet1).Activate
Range(a1).Select
rid = ActiveCell.End(xlDown).Row
MsgBox rid
Range(A rid).Select
MsgBox ActiveCell.Value
If ActiveCell.Value = Date Then
Range(A rid).Select
Else
try below code:
ActiveWorkbook.SaveAs c:\dhartikumar - Format(Date, dd-mmm-)
.xls
On Wed, May 27, 2009 at 5:52 PM, Dhartikumar Sahu dhartiku...@gmail.comwrote:
hi all
can anybody help me for saving the file with current date. (e.g.
dhartikumar - 27 May 2009)
in macro code.
Thanks
You're welcome.
Date: Wed, 27 May 2009 11:11:24 +0530
Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$
From: atul.kesa...@gmail.com
To: excel-macros@googlegroups.com
Hello Dave,
You are a rock Star...thanks a ton!!!
The macro is awesome.this is what i wanted.
Hi Atul,
Sorry about that.
Try the modified attached.
Regards - Dave.
Date: Wed, 27 May 2009 14:08:38 +0530
Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$
From: atul.kesa...@gmail.com
To: excel-macros@googlegroups.com
Hello Dave,
One small issue in the macro, the cell number b2 in the
this runs for me as well..my version is 2007
On Wed, May 27, 2009 at 7:22 AM, ddadmin2009 ddadmin2...@gmail.com wrote:
this runs fine for me and does not require any extra reference library.
can u tell me your excel version n browser u have.. make sure u have some
data in column A... i don't
Thanks again Andy... I shall visit the blog
regards
Subu
On May 25, 11:06 am, Aindril De aind...@gmail.com wrote:
Hi subu, there are hundreds of links available.
To start you can search in this group .. also you can check the following
Hi!
Thank you for your answer. But I get the following error :
Erreur 9 : l'indice n'appartient pas à la sélection. I can't figure
out how to translate it but here is the MS page :
http://support.microsoft.com/kb/468889/fr
Any idea what to do...?
Souriane
On 1 mai, 13:34, Roger Govier
Hi Friends,
I have a master data file which contain customer info along with unique
customer number. I want to see the customer details form after entering the
customer number in form designed in macro.
Is it possible to design such macro ? I am pretty novice in macro coding.
Guys please help
Hi,
I have a spreadsheet that contains a company code in cell A3 to A150.
This company code uniquely identifies a company. These codes ones
assigned are not transferred to another company. What I want to do is
when a user clicks in a cell with the company code I want to reference
its company
Hi Pooja,
The attatched solution may help you.
Regards,
Jayell
On May 26, 4:01 pm, Pooja Sharma vatspoojav...@gmail.com wrote:
Hi All,
I need a help, with a condition in which I have to match a column with other
two columns and if out of those two columns any of them match with the first
Hi All,
I was not able to attach this file in message just sent.
Please enter it in the Thread.
Regards,
Jayell
On May 26, 4:01 pm, Pooja Sharma vatspoojav...@gmail.com
wrote:
Hi All,
I need a help, with a condition in which I have to match a
column with other
two
I have a set of worksheets where the data provider always puts a sheet
with No Sales.
I am trying to write a macro that will remove this sheet (and others
if they fit the above criteria).
Sub test()
For i = 1 To Sheets.Count
Sheets(i).Select
Cells.Select
Dim r As Range
Set r =
Hi Dave,
I guess this will help you.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_21610927.html
Please scroll down to the bottom to get the accepted solution.
Regards,
Andy
On Thu, May 28, 2009 at 5:28 AM, Dave davidstev...@gmail.com wrote:
26 matches
Mail list logo