Automatically copy formulas/functions to inserted rows.
 

In column A-P I have a list of guests (w/info) who will be coming to tour our
property in a given week. The list changes every week, and often changes
from day to day. Next to the list I have a series of conditional formulas
that automatically sum how many guests we will have on any given day and
time. The list changes throughout the week. When we have to insert a new
guest, is there a way for the formulas to automatically drop down/copy to the
inserted row? I have the formulas hidden, and would prefer to be the only
person with access to them, but am often too busy to be copying formulas
daily. On the other hand, the most updated info needs to be given to our
sales and marketing teams. Please help...

Thanks!

Automatically copy formulas/functions to inserted rows.
 

I'm pretty sure that MVP David McRitchie has some VBA code to do this.

Here's a link to his site (it's kind of hard to find things there):

http://www.mvps.org/dmcritchie/excel/excel.htm

Have a look around!

Biff

"Barbara" wrote in message
...
In column A-P I have a list of guests (w/info) who will be coming to tour
our
property in a given week. The list changes every week, and often changes
from day to day. Next to the list I have a series of conditional
formulas
that automatically sum how many guests we will have on any given day and
time. The list changes throughout the week. When we have to insert a new
guest, is there a way for the formulas to automatically drop down/copy to
the
inserted row? I have the formulas hidden, and would prefer to be the only
person with access to them, but am often too busy to be copying formulas
daily. On the other hand, the most updated info needs to be given to our
sales and marketing teams. Please help...

Thanks!

Automatically copy formulas/functions to inserted rows.
 

Thanks again. Will do... : )

"T. Valko" wrote:

I'm pretty sure that MVP David McRitchie has some VBA code to do this.

Here's a link to his site (it's kind of hard to find things there):

http://www.mvps.org/dmcritchie/excel/excel.htm

Have a look around!

Biff

"Barbara" wrote in message
...
In column A-P I have a list of guests (w/info) who will be coming to tour
our
property in a given week. The list changes every week, and often changes
from day to day. Next to the list I have a series of conditional
formulas
that automatically sum how many guests we will have on any given day and
time. The list changes throughout the week. When we have to insert a new
guest, is there a way for the formulas to automatically drop down/copy to
the
inserted row? I have the formulas hidden, and would prefer to be the only
person with access to them, but am often too busy to be copying formulas
daily. On the other hand, the most updated info needs to be given to our
sales and marketing teams. Please help...

Thanks!

Automatically copy formulas/functions to inserted rows.
 

Hi Barbara -

I'm dying to be able to do the same thing. I frequently add several rows at
a time, say twenty, to a worksheet that has formulas in just about each cell
going across the row. It would be nice to be able to "insert with formula
from above".

I looked at the David McRitchie site, and couldn't find a lead on it.

I did however, do a search through commands, and found the fill down command
that can be added to your tool bar. Select a row with formulas, and also
select the row(s) directly below it and hit the down button and whatever is
in the first row gets copied down. The key command on mac is control + D.
This does make it much easier than dragging the fill handle.

If anyone has a solution to 'insert and copy down', it would be valuable.

Best to you,
Stuart

"Barbara" wrote:

In column A-P I have a list of guests (w/info) who will be coming to tour our
property in a given week. The list changes every week, and often changes
from day to day. Next to the list I have a series of conditional formulas
that automatically sum how many guests we will have on any given day and
time. The list changes throughout the week. When we have to insert a new
guest, is there a way for the formulas to automatically drop down/copy to the
inserted row? I have the formulas hidden, and would prefer to be the only
person with access to them, but am often too busy to be copying formulas
daily. On the other hand, the most updated info needs to be given to our
sales and marketing teams. Please help...

Thanks!

Automatically copy formulas/functions to inserted rows.
 

David's InsertRow code can be found here.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Gord Dibben MS Excel MVP

On Thu, 1 Feb 2007 16:18:00 -0800, rat89
wrote:

Hi Barbara -

I'm dying to be able to do the same thing. I frequently add several rows at
a time, say twenty, to a worksheet that has formulas in just about each cell
going across the row. It would be nice to be able to "insert with formula
from above".

I looked at the David McRitchie site, and couldn't find a lead on it.

I did however, do a search through commands, and found the fill down command
that can be added to your tool bar. Select a row with formulas, and also
select the row(s) directly below it and hit the down button and whatever is
in the first row gets copied down. The key command on mac is control + D.
This does make it much easier than dragging the fill handle.

If anyone has a solution to 'insert and copy down', it would be valuable.

Best to you,
Stuart

"Barbara" wrote:

In column A-P I have a list of guests (w/info) who will be coming to tour our
property in a given week. The list changes every week, and often changes
from day to day. Next to the list I have a series of conditional formulas
that automatically sum how many guests we will have on any given day and
time. The list changes throughout the week. When we have to insert a new
guest, is there a way for the formulas to automatically drop down/copy to the
inserted row? I have the formulas hidden, and would prefer to be the only
person with access to them, but am often too busy to be copying formulas
daily. On the other hand, the most updated info needs to be given to our
sales and marketing teams. Please help...

Thanks!

Automatically copy formulas/functions to inserted rows.
 

thanks for the direct link, Gord - I will check it out.

"Gord Dibben" wrote:

David's InsertRow code can be found here.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Gord Dibben MS Excel MVP

Automatically copy formulas/functions to inserted rows.
 

Thank you both for your input. : ) I did find the code on David's website.
I've never worked with code before, but it seems pretty straight forward, and
I've always liked to learn how to do new things.

Barbara

"rat89" wrote:

thanks for the direct link, Gord - I will check it out.

"Gord Dibben" wrote:

David's InsertRow code can be found here.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Gord Dibben MS Excel MVP

Automatically copy formulas/functions to inserted rows.
 

Thanks for the feedback.

Good luck.

Gord

On Fri, 2 Feb 2007 15:01:01 -0800, Barbara
wrote:

Thank you both for your input. : ) I did find the code on David's website.
I've never worked with code before, but it seems pretty straight forward, and
I've always liked to learn how to do new things.

Barbara

"rat89" wrote:

thanks for the direct link, Gord - I will check it out.

"Gord Dibben" wrote:

David's InsertRow code can be found here.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Gord Dibben MS Excel MVP