descending order could have been done by using small function,
=SMALL($B$2:$B$38,COUNTA($B$2:B2))
Ritesh
On 6/12/09, Ramesh Katta wrote:
>
>
> Hi Amitabh
>
> Thank you very much.
>
> Regards
> Ramesh
>
> On Fri, Jun 12, 2009 at 1:59 AM, Amitabh Bose
> wrote:
> >
> > Hi Ramesh,
> >
> > I have at
pls send a sample data sheet, will write the code there.
Paul
On Tue, May 19, 2009 at 11:02 PM, Vandana Vallam wrote:
> Dear Friends, Can someone help me to run a macro to calculate the sum of a
> cell across sheets...for Example
>
> Sheet 1 B2, Sheet 2 B2 and Sheet 3 B3 have some numbers...now
you have to write the below code 75 times in VBA
Workbooks.Open ("C:\Documents and Settings\Ritesh\Desktop\temp\A.xls")
Sheets("A").Copy After:=Workbooks("report.xls").Sheets(1)
workbooks("a.xls").close
where A is source file, Report is the fle where dat will be save,
Regards,
paul
On Mon, May
Please use ActiveSheet.UsedRange.Select, if you are changing data daily. It
will select only the range you have used.
Paul
On Sat, May 16, 2009 at 7:27 AM, Joyce Garza wrote:
> Attached is an example of the excel file I am working with.
> This data is imported from another database application
I think, u need to format the cell in Number Format. Pls make decimal place
as 0. U should
get the result.
Paul
On Wed, May 13, 2009 at 7:26 PM, larry wrote:
>
> I am talking about the format cells command. If you select a cell or
> cells and right click you will see a format cell option. Selec
do u want to average where coresponding cell is " marked as "yes"?
Paul
On Wed, May 13, 2009 at 5:05 PM, Damian wrote:
>
> Hi Andy
>
> thank you for reply & sorry for small delay...
>
> I have range of data C1:E10 and A1:A10 each cell got drop down list
> with values: "Yes" and "No". for exampl
