Automatically copy formulas/functions to inserted rows.

B

Barbara

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!
 
R

rat89

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
 
B

Barbara

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
 
G

Gord Dibben

Thanks for the feedback.

Good luck.

Gord

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
Click to expand...
 
Top