merge data from different tabs to one tab

G

Guest

Hi, I need to merge all data to one tab from other tabs in one work file, I
have 20 tabs with all same format columns, I want to copy paste from each tab
to cosolidated tab, how can I do it faster rather than copy and paste from
each tabs??

Thanks a lots.

hank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy the data from Different tabs on to one tab 1
Move data from mulitple tabs to one sheet 2
Different font sizes in different worksheet tabs 3
Macro 3
Move data on multiple tab to one 2
Paste Link then Data Sort 1
Copy & Paste Across Sheet Tabs in a Range of Cells 4
Multi tab setup 2

Top