Need to copy & paste range into next available row in TABLE

[jonrack]

I have a macro that will copy data from Sheet 'Bill Reminder Range A3:C3 to the next available row in Sheet 'Checking Column "B". The data in 'Checking is a table. The macro functions but it post the data in the first empty row BELOW the table. Is there a way to paste into the first empty row WITHIN the table?

Here's what I've got so far..........

Please Login or Register  to view this content.

[rscsmith]

Hi jonrack

This is difficult to answer without seeing your spreadsheet.

The End(xlUp) should take you to the last entry in Col B. If you have cells below the table that are used then this is what you will 'bump in to' on the way up from the bottom.

Another option would be to use a column that doesn't have any notes, etc in then offset from there. Col C/D? Alternatively, if every row of the table has data, go to the first row and do an End(xlDown).

Sorry I can't be more help. If this isn't sufficient, please post an example so we can understand what is going on.

Cheers, Rob.

[jonrack]

Thank you, rscsmith. It was an easy fix. The problem was with the table. I had included 1000's of empty cells in the table for future expansion. What I didn't realize, is that I could make the table range without extra cells, then when new data was entered in the next empty row it would be automatically included in my table. I reduced the size of my table to only the existing data, and now it works perfectly. I have much to learn about Excel, but that's 1/2 the fun