MDCrj
New member
- Joined
- Nov 3, 2020
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365 64 bit
posted on Skillwave training as part of my lesson questions
i have a workbook with about 40+ worksheets
most are because inorder to add additional/personal columns into queries i needed to follow Marcel Beug method of creating a query and then queriying the query and then merging the 2
it works but leaves me with 2-3 worksheets for eeach output final worksheet
i just compoleted a lesson on skillwave of adding personal comments
his method was creating a connection only query then combining the 2 and then 1 output sheet
i tried to take my staging queries and tuen them into connection only
my workjbook failed because each query said "table not found"
short of recreating each and every multistep query, is there a way to turn the queries into connection only and refernce that?
i tried and failed
i have a workbook with about 40+ worksheets
most are because inorder to add additional/personal columns into queries i needed to follow Marcel Beug method of creating a query and then queriying the query and then merging the 2
it works but leaves me with 2-3 worksheets for eeach output final worksheet
i just compoleted a lesson on skillwave of adding personal comments
his method was creating a connection only query then combining the 2 and then 1 output sheet
i tried to take my staging queries and tuen them into connection only
my workjbook failed because each query said "table not found"
short of recreating each and every multistep query, is there a way to turn the queries into connection only and refernce that?
i tried and failed
