I need to expand a file I am working on by creating a
macro to insert the number of rows equal to the total sum
on the worksheet..

I then need to auto-fill down on those inserted rows with
the autofill automtically stopping when it reaches a
number that is a reference in anotehr cell.

Please let me know if this is at all possible

thanks

First, manually record what you want to do.

The macro recorder will assume you want to do this to the
same cells every time. Problem, this will vary.

Second, determine what will drive the number of rows to
insert and vary the recorded code to take this into
account.

Third, determine the values/formulae to autofill, either
use copy paste with xlenddown or do.... until loop to do
the fill.

Steve