Insert Row Above Help

[Endurs]

Good afternoon. I just started tinkering with VBA last week so I could develop a reporting tool that generates an email. I have all of this working in the most basic of ways. When the submit report button is pressed it fetches the data from row 3 and puts them in the email. However, when submitting a 2nd report it fetches the same data as the old report because the new report is posted below the old report - so it's not working. What I need to figure out is - once they have clicked the submit report button a new row should be inserted above the previous report, the "new report" posted in this row, and then it will always fetch the newest report at the top of the sheet. Does this make sense? I'm struggling to explain it properly. Below is the current code.

Please Login or Register  to view this content.

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

[Endurs]

I keep typing Upload, it shows a current attachment, but then it disappears when I close the window.

[Endurs]

I'm dumb sometimes. Here it is.