I have a spreadsheet and a named Range called "menu" which is defined as
Which starts at B10 and then next 5 columns and is dynamic in length. this works and properly selects the desired information. My trouble is that when I open access to try and import this data it doesn't find it as a named range. If you know how this can work please help. My other idea was to just copy only this data into a second sheet. I'm not sure how to do this either. Thanks in advance.
Code:
=OFFSET(Sheet1!$B$10,0,0,COUNTA(Sheet1!$B:$B),6)