Adding border lines to a changing report

Hello all

I have a macro that writes and edits a report and prints out a final sheet (attached). I want to add border lines in my document so the finished report looks like 'Sheet2'. I am resonably comfortable with recording a macro and setting the border lines that way, however the final report will return more/less values than my attached sheet. So I need to record this dynamically.

Can anyone help me with this?

Thanks
BBB