Hello. If I want to consolidate worksheets and load to connection on 30 sheets let's say. Is there a way to get ALL tables in each sheet to load to connection (1 for each table) without having to do manually do it. In this case, a macro is almost easier than the power query function.
Hi,
Why do you want a separate connection for each table if you are trying to consolidate the worksheets?
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks