Macro to extend a table range

[qaliq]

Hi everyone,

I have a table in excel which i need to add extra lines on the bottom as and when they arise from another lot of source data.

I've written a macro that does this but the problem is that because i'm copying and pasting the data in my excel table range doesn't extend to the new rows and I don't know how to extend it.

This is what i've got so far...

Please Login or Register  to view this content.

Is there anything I can add in at the end which will extend my table range?

Hopefully that is clear, I can try and upload a sample workbook but i'll have to take out all the confidential stuff.

Thanks,

Alice

[venkat1926]

understood onlypartially

suppose you want to paste the copied data only from A2 of sheet tracker or after the existing data in the sheet tracker
then this code will suffice
worksheets("tracker").cells(rows.count,"A").end(xlup).offset(1,0).pastespecial

try this code (instead of your secod part of the macro) in an EXPERIMENTAL FILE and get convinced it is ok and then use in your oriogial file..

no need to "select" so many times. without selection you can copy

[extremis]

can you upload the file?