I'm using Excell XP 2002, Spread sheet is set up as followed

Past Due Date Total # Past Due, Past Due Date, Total # Past Due Grand
Total
12/12/2001 1 12/12/2002 3
4

I have a maco that auto insets a Past Due Date and Total, but I am so stuck
on how to add the new column of total # past due, the date columns are
colored in a yellow. Each Time I add two new columns I need to have the
grand total formula updated with the new total#past due column #,

Help, please

On Jul 30, 8:54 am, Jul in Ohio <Jul in
O...@discussions.microsoft.com> wrote:
> I'm using Excell XP 2002, Spread sheet is set up as followed
>
> Past Due Date Total # Past Due, Past Due Date, Total # Past Due Grand
> Total
> 12/12/2001 1 12/12/2002 3
> 4
>
> I have a maco that auto insets a Past Due Date and Total, but I am so stuck
> on how to add the new column of total # past due, the date columns are
> colored in a yellow. Each Time I add two new columns I need to have the
> grand total formula updated with the new total#past due column #,
>
> Help, please

Jul,

Sorry I'm a little unclear as to what exactly your problem is. Could
you post the code?

Can you post the macro. the problem look like you need specific code based
on the locations of your cells. I suspectt you need to use an offset and it
will be esier to generate code if I saw the macro you are presently using.

"Jul in Ohio" wrote:

> I'm using Excell XP 2002, Spread sheet is set up as followed
>
> Past Due Date Total # Past Due, Past Due Date, Total # Past Due Grand
> Total
> 12/12/2001 1 12/12/2002 3
> 4
>
> I have a maco that auto insets a Past Due Date and Total, but I am so stuck
> on how to add the new column of total # past due, the date columns are
> colored in a yellow. Each Time I add two new columns I need to have the
> grand total formula updated with the new total#past due column #,
>
> Help, please
>
>