I have had some trouble on a project I have been working on for
some time. I have tried numerous approaches, each with undesired
results. (VAB Code)

The project I am working on has become quite complex, so rather
than bother you with my spaghetti code, I have made a simple example
of what I am trying to do.

http://www.geocities.com/rockytophubby\sample.html

The sheet tracks People and how many fruits they had each day.
Day1 is where the information is Inputted, Day2 will double the DAY1
numbers, and Day three will triple the DAY2 Numbers.

The challenge I am faced with: On DAY1 every time ANY information
is inputted (even if there is no name) have a new Row AUTO inserted
for the next person on ALL three days. (Keeping in mind each day has
different formulas, so the Formatting and Formulas must be copied from
the line above it on each sheet.)

ANY help I can get here would be greatly appreciated, as I know
this is no task for a beginner...

Hi Peter

check out my reply in microsoft.public.excel.programming - just for future
reference, it's generally not necessary to post to more than one newsgroup.

Cheers
JulieD

"Peter Long" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> I have had some trouble on a project I have been working on for
> some time. I have tried numerous approaches, each with undesired
> results. (VAB Code)
>
> The project I am working on has become quite complex, so rather
> than bother you with my spaghetti code, I have made a simple example
> of what I am trying to do.
>
> http://www.geocities.com/rockytophubby\sample.html
>
> The sheet tracks People and how many fruits they had each day.
> Day1 is where the information is Inputted, Day2 will double the DAY1
> numbers, and Day three will triple the DAY2 Numbers.
>
> The challenge I am faced with: On DAY1 every time ANY information
> is inputted (even if there is no name) have a new Row AUTO inserted
> for the next person on ALL three days. (Keeping in mind each day has
> different formulas, so the Formatting and Formulas must be copied from
> the line above it on each sheet.)
>
> ANY help I can get here would be greatly appreciated, as I know
> this is no task for a beginner...
>
>
>
>