How to copy people names on A column on about 100 tabs to summary tab?

N

Nuutti

New Member
Joined
May 25, 2016
Messages
7
Hi!

I have a bit more than 100 tabs in my Excel workbook. All have peoples names in A column. Can I copy with some formula or script names of all those tabs to new Summary tab? Some names may appear on several tabs. I do not care if those names come to Summary-tabs several times. I can later on remove all duplicates.

Thanks in advance for your help!
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

C
  • Question
Comparing 3 tables to a list of numbers, if match, return 4 columns worth of data on another tab
Replies
4
Views
177
alansidman
A
D
  • Question
Generate worksheet name based on cell lookup across multiple worksheets
Replies
1
Views
160
Darren_workforce
D
K
  • Question
Formula needed to look up specific name and enter data from specific column within same row
Replies
1
Views
283
awoohaw
awoohaw
E
  • Question
Copy data from a Data Entry form's table to the correct date in another tab
Replies
0
Views
155
Exceleration65
E
VBAAccountant
  • Solved
VBA Code to copy data based on criteria to tab with the same name
Replies
3
Views
253
vcoolio
V

Forum statistics

Threads
1,216,372
Messages
6,130,223
Members
449,567
Latest member
ashsweety

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top