Copying data from 100 tabs to one summary page

R

Rob P

Hi there, I have over 100 tabs with numerical data - each tab is named

I want to create a summary on one tab

I am having problems writing a macro to copy the data from each tab
onto the summary page

I want to paste each tab name on the summary sheet in column A with
the data in rows starting in Column B

i have written the loop - but am struggling to include the each tab
name

any ideas? many thanks
 

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

Copying data from 100 tabs to one summary page 6
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Copying data from 100 tabs to one summary page 1
Copying data from 100 to one summary page 1
Consolidation Table from Different Excel Tabs with Different Format 1
Auto populate value from one task to another in MS PROJECT 0
How to paste the same cell one tab over 1
Auto Populate One Pages from spreadsheet 0

Top