in PQ can we merge multi sheets in Multi Workbook at same time

LearnMeExcel

Well-known Member
Joined
Aug 11, 2009
Messages
728
Hi all
i have 5 files for 5 regions
each files contains From 4 to 10 sheets ( each sheet for Product sales Anaysis )
i merged it by my PQ File file then i use PQ also to Merge it all in one file

that is mean i use PQ 5 times for 5 files
then i use it again to merge it all in one file

can i make all this steps one time in One PQ file

i hope it is clear for all
 

LearnMeExcel

Well-known Member
Joined
Aug 11, 2009
Messages
728
@sand666
i use it it in next step
i want by one step all data from multi sheets and workbooks
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,202
you mean "one click and go?"

in post#2 I said From Folder then merge tables - this is one query

or explain what one step means to you
 

LearnMeExcel

Well-known Member
Joined
Aug 11, 2009
Messages
728
Sandy i merge sheets in each file
then i use from folder

i asked if it is possible to merge sheets and file by one step
 

LearnMeExcel

Well-known Member
Joined
Aug 11, 2009
Messages
728
yes i use around 6 steps
cuz from folder take only one sheet from all files
i want to take many sheets ( appended) in many files at one step
 

Forum statistics

Threads
1,077,650
Messages
5,335,501
Members
399,020
Latest member
julianjjh1

Some videos you may like

This Week's Hot Topics

Top