userform data to spreadsheet
 

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?

userform data to spreadsheet
 

If you have headings and titles in column A, why do you want to overwrite
them with data?

What do you mean I want the row to move down. Do you want to insert 7 rows
so the old A9 to A15 is now A16 to A22 and enter the additional data in A9
to A15.

I strongly suspect you either are misoriented and will be entering across
the columns with all entries on a single row (the standard way to organize a
table) or you will be advancing each record to a new column. In either
case, you need to be specific.

--
Regards,
Tom Ogilvy

"Priya" wrote in 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?

userform data to spreadsheet
 

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?

.