Priya,

Most likely, this is very easy to solve. But you need to
be more specific, as Tom has mentioned. Could you use a
multipage control on one form, rather than using two
individual forms? Would that simplify things?

When you want the "row moved down", do you mean that you
want the next line of data to be entered one line down?

With a "row moved down" are your headings/titles on row 1,
from column A to column O (which is on top)? Or are your
headings/titles on column A, from row 1 to row 15 (which
is on the left)? That's the kind of specific information
that is required.

Where exactly would this new data be placed on the
spreadsheet each time, by row and column? It seems that
you are describing your data going to the same place as
the headings/titles (A1 to A15 and A1-A8 & A9-A15)?

Thanks, Rick

-----Original Message-----
Hello There,

yes, my problem...

i hav a userform whos data goes onto a spreadsheet.
i hav headings/titles from A1 to A15.
from the 1st userform data goes to cells A1-8 and from
userform2 the data goes to cells A9-15.

after userform2 the user has the option of having
userform 2 appearing again to add extra data, in this
case i want the data from that userform1 to be entered in
A1-8 and the row moved down.

sori this is a lil confusing, can ne1 help?

.