:38 -0800
> Subject: Re: $$Excel-Macros$$ SUM ON BASIS OF FORAMAT
> From: yalt...@gmail.com
> To: excel-macros@googlegroups.com
>
> 1: What is determining if the cell gets a number format of "dr" or
> "cr"? (yes, it may be simple to others. I got no clue what th
rote:
> Hi yalters,
>
> I couldn't see any other way of doing it, considering the format of the
> original data. But I'm open to anything (simpler) that works.
>
> Regards - Dave.
>
>
>
>
>
> > Date: Tue, 24 Nov 2009 08:24:08 -0800
> > Subject:
Hi yalters,
I couldn't see any other way of doing it, considering the format of the
original data. But I'm open to anything (simpler) that works.
Regards - Dave.
> Date: Tue, 24 Nov 2009 08:24:08 -0800
> Subject: Re: $$Excel-Macros$$ SUM ON BASIS OF FORAMAT
> From: yal
I'm really wondering why are we using custom number formating and vba
for this task.
On Nov 24, 3:49 am, Dave Bonallack wrote:
> Hi Om,
> Have a look at the attached. It uses a macro to sum your column, based on the
> 2 different formats you've used.
> I don't know how to do this with worksheet
Hi Om,
Have a look at the attached. It uses a macro to sum your column, based on the 2
different formats you've used.
I don't know how to do this with worksheet functions, but we could add an event
macro that re-sums every time there is a change in the data, if you need. Or
you can just do it m
