How to copy data one multiple sheet in one workbook to another

first workbook for 6 sheets and I would like to copy each sheet data (selected range) from this 6 sheets and paste on another workbook … Try to use excel application scope by it not allow to open 2 workbook together … Please help!

Hi @tyeyin,
A lot of usefull stuff you may find here:

Additonally there are tons of topics related to excel. Just try use search function. Here you have example:


Thanks Pablito