I am trying to create a macro that will cut predefined cells and paste them into the next available line in a table. I tried recording, but i cant quite mimic select the last line available. I also tried looking at the many threads on it, but i cant synthesize it for my needs.

I would also like to copy the columns under this table and then paste them into a pivot table on the same worksheet as the other table. Any help would be appreciated...

I know how to assign the macro to the button, its just the macro itself that i cant create... Im surprised im having so much trouble with this after playing microcontrollers for the past few months. I thought id be able to figure this out... oh well. thanks for any help.

batch worksheet.xls