Macro to create an "expanding table"

[pmk11]

So I have recorded a macro that filters for certain criteria in a master list of projects, then copies the projects that meets this criteria and pastes it into a timeline in another worksheet. However, because the list of projects gets bigger and smaller when the filter criteria changes, right now I have to create twenty extra rows so that the pasted list doesnt ourgrow my timeline. I was wondering if anyone knows how I could input a few lines in my macro so that the table for the timeline expands as the number of prjects grows or shrinks.

One method I have tried is to copy the filtered data and "Insert Copied Cells" into the table, however I don't even get the option to insert copied cells after I have copied the data...

Thanks alot for the help everyone!

 

[wigi]

Try to use the currentregion of a cell:

range("A1").CurrentRegion.AutoFilter ...

or

ActiveSheet.UsedRange.AutoFilter ...

 

[pmk11]

Could you elaborate please? I don't quite get what you mean.

 

[wigi]

If you need code for "Insert copied rows", here's example code:

Sub Macro3()
    Rows(8).Copy
    Rows(10).Insert
    Application.CutCopyMode = False
End Sub