advance filter but only some columns to table

Hi All,

So i have my main data table at the end the idea is to create a report style sheet this should have 3 table displaying certain partial rows from te main datatable

so currentlt elsewhere i use an advanced filter and after it is complete i delete the coulumns i dont need what i would like to do is insert the filtered data directly into table 2 on another sheet this has only 5 columns rather than the full table which has 18

the current code i use is

Please Login or Register  to view this content.

its the range part that im struggling with as if i give the range of the table current starting point is c13:g13 that may change as the table above may have more rows so can i refernce the table but i also get and error if i directly reference that range i guess because there is a difference in the number of columns

Hope this makes sence

Kind regards tim

Hi Marvin,

Worked like a charm thankyou very much

Kind regards tim