Forms and formulas

[AlexL2]

I was wondering if I could get a hand with some problems.

-Is there a formula to delete rows from a worksheet without deleting them by hand.

-I am attempting to build a form that automatically fills in a specific worksheet depending on the first choice in the form. Is there a way to make a function/formula that will know which worksheet to place the information in other than an IF statement.

-Is there a way to create a button (like a submit button) that will move to the next row of the selected worksheet and clear the form.

If you need any additional information please let me know.

 

[Amnesiac]

-Is there a formula to delete rows from a worksheet without deleting them by hand.

No there is not a formula but you can write a macro to accomplish this.

 

[kpark91]

For a macro, if you want to delete the entire row of a row 1

Try

     Rows(1).EntireRow.Delete

If you want to delete rows which have blank cells in column A

Try

     Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Delete