VBA - ActiveX

[mabernathy]

I want the output on the excel spreadsheet to appear in row 2 under the header. Currently in the row that corresponds with the imputed Customer ID #. For example, if I input 10 in the InputBox, the output appears on row 11 on the excel spreadsheet. If I input customer ID 7, the output appears on row 8. I want it to appear on row 2 no matter what customer ID is inputted.

 

[Snakehips]

In the If statement within the Do While, you have five instances of topcell.Offset( rowCount, ........
Try changing RowCount to 2. topcell.Offset( 2, .....