Tom,

You are good. It works very well. When filling down the G14 should be G13.
Otherwise, perfect! Thanks a lot!

Daniel

"Tom Ogilvy" wrote in message
...
Sub UpdateFormulas()
Range("G14:G65536").ClearContents
Range("H265:H65536").ClearContents
Range("AC768:AC65536").ClearContents
Range("G14:G" & Range("B1").Value).Formula = Range("G14").Formula
Range("H264:H" & Range("B1").Value).Formula = Range("H264").Formula
Range("AC767:AC" & Range("B1").Value).Formula = Range("AC767").Formula
End Sub

--
Regards,
Tom Ogilvy


"Daniel Rascoe" wrote in message
...
Tom,

Thanks for your reply. I haven't written macros in Excel before but I
think
a macro is what is needed here. I think the macro should first clear all
cells below G13, H264 and AC767 within each column. Then the macro should
fill down from those cells to the row number which is in B1. Ideally, I'd
like for as the value in B1 changes that the number of cells filled down
to
change. But I don't think I can do that. So I think the steps will have
to
be: 1) import the data which will determine a value for B1. 2) run the
macro
to clear any filled cells below G13, H264 and AC767 and then re-fill from
G13, H264 and AC767 down to the row value in B1. The value in B1 can
decrease as well as increase. The data imported into the spreadsheet is
daily stock prices. Prices for a different stock can loaded and different
time frames examined. Right now the data is manually added but later may
come from a data feed.

Sincerely,

Daniel
--------------------------------------------------------------------------
--------------------------------
"Tom Ogilvy" wrote in message
...
You could write a macro to do it. By automatically, do you mean when
the
value in B1 changes, then the cells would be filled down? How about if
B1
decreases - would formulas be cleared.

How does the data in the last row get added (so that B1 would change)?
Manually?

--
Regards,
Tom Ogilvy