Auto creating rows

[Orf Bartrop]

I am trying to construct a worksheet that needs to copy the formulae in
the current row. If I do this manually by pulling down the right bottom
handle my worksheet shows the cell color and prints to the end of the
column created when the original cell is pulled down. I do not want either.

To explain it more fully - I have 7 columns 3 of which contain a
formula. 4 of the columns are colored for ease of defining their
purpose. Data is entered by the row and it is only when the ENTER key is
pressed that the row colors and formulae show be created on the next
empty row.

Can someone help?

Orf Bartrop

 

[Don Guillett]

Have a look at using the worksheet_change event in the sheet module

 

[Orf Bartrop]

I am afraid you have lost me, Don. I could not find the worksheet_change
event.

What I have is 4 cells B6, C6, D6 and E6 each capable of accepting data.
There are no formulae attached to these cells, however they are each
separately formatted. What I want is to do is if the Enter key is
pressed when the focus is in any of these cells then reproduce the
format and formulae in cells A7-G7, where A7, F7 and G7 each contain a
formula and formatting. However if G5 is not blank I do not want the
next row changed, instead change the focus to the B cell in the last
empty row.

By the way, thanks for your answer to the Exit button problem. Works fine.

Orf