With Windmill data this equates to the number of rows of data (and headings).
The trick here is that a named range can be defined using a formula.
The problem comes that when I open the XLS file, worksheet Invoice never gets updated with the new values in Invoice Data.
I either have to 1) Save it as a new fileor 2) Hit CTLSHIFT F9 Writing a macro is not an option because the business requirements say the XLS file can not contain a macro.
We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.