Insert a table on the next available row after a macro has run

[Wayne Rogers]

Hello,

I have a spreadsheet that imports data from a HTMl file and tidys up the data via a macro, this data then needs manual inputs (reason codes) into a column. I have a command button than sorts the data by the manually inputted reason codes.

I would like to know if there is a code that could enter a simple table on the next available so i could summarise the data. I tried to do it by adding an extra tab with the table on it (tab could be hidden) and use a simple copy and paste macro (which works) but it pastes it to a specified cell and this wouldn't work as everytime i use the sheet there are a varying amount of rows.


Ideally it would be good to have the code connected to the original command button but i can add another button. I'm sure it can be done but my limited knowledge is showing on this one.

Many thanks in advance.

Wayne

 

[Wayne Rogers]

I hope I've explained it clearly enough

 

[Wayne Rogers]

Just in case anyone looks at this, I've kind of solved it after several hours of head banging. My code is as below if its any use to anyone

ActiveSheet.Range("b5").End(xlDown).Offset(1, 0).Select
Sheets("Sheet1").Select
Range("A1:E9").Select
Selection.Copy
Sheets("BWO").Select
ActiveSheet.Paste