Copying filtered data to another sheet

Hi All

Long story short im throwing together a mini payroll system for my mates startup. Working on a macro to copy some data into a template ive set up on a sheet, it then saves a pdf to a folder and attaches it as an email to his employee

Ive set up a page ("SessionInfo") that has a tabel with information on all the "Sessions" my friend sends his employees on (employees consist of himself and a few of his friends, all therapists who go out and meet at their clients homes). Things like empID, date, client, cost, comission, etc. Macro filters this table according to which empID and date range specified in another table ("ControlPanel"). It then copies all the data it needs to into my template sheet ("Invoices") and creates the pdf

ive got it all working, however my problem is in my copy function. Ive set it up to copy data from columns B to I (in sheet "SessionInfo", row 1 is the column headings). It copies from row2 of those columns to the last row that has data in it. I thought that once i applied the filter, the copy paste function would automatically adjust and only copied the filtered data... it did not and just copies the whole table

is there a way just to copy the filtered data of those rows (without column headings)? Would appreciate any help

Below is the code im using to copy and paste my data, this si what ill need to replace

Please Login or Register  to view this content.

and here is the whole macro for context

Please Login or Register  to view this content.

and here are the trhee other macros used to filter and sort the table, as well as clear the invoice template so its ready for a new one.... i dont think theyll be required but figured id add them as they are referened in the main invSummary macro. just in case

Please Login or Register  to view this content.

You can try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.