Empty Row VBA

[jamesmev]

I currently have a form where sheet 2 is being filled by a cell reference and the following formula:

**=IFERROR(IF(E1="volume",INDEX(Sheet1!$B$14:$B$9999,SMALL(IF(Sheet1!$B$14:$B$9999<>"",ROW(Sheet1!$B$14:$B$9999)-ROW(Sheet1!$B$14)+1),COUNTIF($E$1:E1,"item code"))),INDEX(Sheet1!$A$14:$A$9999,SMALL(IF(Sheet1!$B$14:$B$9999<>"",ROW(Sheet1!$B$14:$B$9999)-ROW(Sheet1!$B$14)+1),COUNTIF($E$1:E1,"item code")))),"")**

I want the user to be able to have a macro that goes to the next empty row on sheet two referencing the same information.
I am stuck on this.

Any Help?