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

Sub action_report_stores()
Sheets("Tre_800").Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
    CriteriaRange:=Sheets("hide").Range("N1:N2"), _
    CopyToRange:=Sheets("Action_report_stores").Range("a26:r26"), Unique:=False
    
End Sub
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