Create a master list of names from multiple tabs

**rob.callaghan** · 10-31-2017, 08:59 AM

wondering if somebody could help me out.

I'm after a VBA that will copy all the names from columns D, E & F in each worksheet and then create one master list in another tab.

Thanks in advanced...

**Mumps1** · 10-31-2017, 09:53 AM

DO you want the names from each column underneath each other in one column or do you want to keep them in 3 columns? What is the name of the destination sheet and where on that sheet do you want to copy the names?

**rob.callaghan** · 10-31-2017, 10:05 AM

Hi Mumps1,

Thanks for your prompt response, id like to keep the 3 columns please and the destination sheet is called 'Full List'
all the names in each sheet will start from row D4, E4 & F4 and the 'Full List' is in the same format.

thanks

**Mumps1** · 10-31-2017, 10:17 AM

Try:

Please Login or Register  to view this content.

**rob.callaghan** · 10-31-2017, 10:28 AM

Hi Mumps1,

thanks for that, it works but it has also copied a lot of blank cells between the multiple sheet data. is there anyway it can copy only the cells with names in?

**Mumps1** · 10-31-2017, 10:41 AM

Could you attach a copy of your file so I can see how your data is organized?

**rob.callaghan** · 10-31-2017, 10:48 AM

I've managed to sort it, it was picking up empty cells that had boarders around them.
I have removed the boarders and it has solved the problem.

thanks for your help!

**Mumps1** · 10-31-2017, 10:51 AM

My pleasure.

Create a master list of names from multiple tabs

LinkBack

Thread Tools

Rate This Thread

Display

Create a master list of names from multiple tabs

Re: Create a master list of names from multiple tabs

Re: Create a master list of names from multiple tabs

Re: Create a master list of names from multiple tabs

Re: Create a master list of names from multiple tabs

Re: Create a master list of names from multiple tabs

Re: Create a master list of names from multiple tabs

Re: Create a master list of names from multiple tabs

Thread Information

Users Browsing this Thread

Similar Threads

How to generate a master list of all names and other data from multiple tabs

[SOLVED] How to create Multiple sheets base on a list and a MASTER sheet

collating multiple tabs within same workbook to create a master/summary tab

[SOLVED] How to create a master list worksheet from lists of names on several worksheets

Use and auto-sort names from a master list, with multiple columns under every name

[SOLVED] Create master list from multiple sheets in the same format

Can you auto create multiple tabs from enterting data in a master sheet's column?

Bookmarks

Bookmarks

Posting Permissions