Tables in excel
 

I am trying to automate a table in excel to populate. This is working fine
however each month it will be a different length (no of rows) therefore can
you automate it to only import into Word the length of entries in there
rather than the entries plus blank rows?