My goal is to start a query with the source being the worksheet named ISS in the current workbook.
This page will be regularly updated and it's not formatted as a table. The purpose of the query is to cleanse and reshape this worksheet.
I've been successful in developing queries that refer back to the workbook and worksheet and have a long filepath name in the source. But if the workbook is saved to a new place, the queries breaks--even though the ISS worksheet is in the workbook.
Is there a way to point a query directly to the worksheet?
This page will be regularly updated and it's not formatted as a table. The purpose of the query is to cleanse and reshape this worksheet.
I've been successful in developing queries that refer back to the workbook and worksheet and have a long filepath name in the source. But if the workbook is saved to a new place, the queries breaks--even though the ISS worksheet is in the workbook.
Is there a way to point a query directly to the worksheet?