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
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

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
4,721
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
 

Watch MrExcel Video

Forum statistics

Threads
1,090,142
Messages
5,412,696
Members
403,442
Latest member
keowinvip1

This Week's Hot Topics

Top