I have a workbook with a SQL sheet referencing Sheet1 ( codes refer to columns in Sheet1 as Sheet1.var1, Sheet1.var2,.,). I had make certain changes in the workbook by joining Sheet1 and another sheet (by default creating the Joined Sheet). The SQL sheet should now reference the joined sheet. currently I am taking the copy of the codes into a notepad and replace all Sheet1 reference to Joined and then re-execute the same. IS there a way to automatically link the sql sheet to the joined sheet.
Thanks for taking time out to view this post and appreciate your response on this.
Please sign in to leave a comment.