Automatically replicating a row as I enter data?

  • Thread starter Thread starter Noozer
  • Start date Start date
N

Noozer

Is it possible to create a single row in an Excel spreadsheet that will
automatically insert a new row, duplicating the formatting and formulas from
the current row once data has been added?

i.e.

Row 1 and 2 have titles
Row 3 has a Qty, Description and Price and final cost formula (Qty * Price)
Row 4 shows the sum of column 4 (the final cost)

If I enter data into row 3, I want row 4 to automatically move to row 5 and
then row 4 to contain the same formatting and formulas as row 3 (with no
data).

Thanks!
 
Noozer,

First, please post only to one group.

With Excel 2002, you can use Tools - Options - Edit - Extend list formats
and formulas. There are some conditions that there must be at least 5 rows
already there, and the formulas and formats must appear in at least three of
them. Or something like that. I can't find it again in Help, so I think
I'll go outside and enjoy the nice weather.
 
Earl Kiosterud said:
Noozer,

First, please post only to one group.
Click to expand...

Multiposting is bad form and both groups were relevant. Trim the groups to
the one you're replying to (as you did) and I'll still see the reply.
With Excel 2002, you can use Tools - Options - Edit - Extend list formats
and formulas. There are some conditions that there must be at least 5 rows
already there, and the formulas and formats must appear in at least three of
them. Or something like that. I can't find it again in Help, so I think
I'll go outside and enjoy the nice weather.
Click to expand...

Thanks for the info... Definately gives me a place to start.
 
Noozer,

The reason that multiposting is discouraged is that it can lead to multiple
responses in the groups where responders aren't aware that it might have
been answered elsewhere. Thus their time is wasted.

Good luck with the Extend List Format option. Another, and more robust,
solution is to have a macro build a new row each time one is needed. It can
be an event macro, to make it automatic.
 
Yeah but Noozer actually crossposted to both groups at the same time.

Although, I don't believe that even that was necessary (either group would be
fine), crossposting is less of an egregious sin than multiposting <vbg>.
 
Back
Top