Dynamic named range for invoice data

[hhhelp]

HI,
Newbie to excel here.

I am trying to use code to take a named range on an invoice and add it to a database in a separate sheet.
The code I am using is below but need it to not pull any blank cells that contain functions in them.

Code I was previously told to use but has an error:
=OFFSET(Invoice!$M$19,,,MATCH(99999,Invoice!$M$19:$M$49,0),6)

Code that pulls data including blank cells with functions:
=Invoice!$M$19:$R$49

Any and all help will be greatly appreciated

 

[StephenCrump]

Welcome to the Forum!

If R19:R49 contains data, and you want to return only non-blanks (where blank means either no formula/value or a formula returning ""), then in Excel 365 you simply need:

=FILTER(R19:R49,R19:R49<>"")