How to source id's from one worksheet to another?

**Nordin1981** · 02-17-2018, 02:51 PM

Hi All,

I am facing a challenge in excel, I have 2 separate worksheets. In one worksheet I have authors and there unique ID's. In the other worksheet I have papers and the related authors of those papers.
I am trying to add the ID's in the worksheet with the papers and there related authors, the challenge is that a paper can have multiple authors and I am stuck on how to do this.
Can anyone please help me out here?

I have attached a example of the 2 worksheets and the solution I am looking for.

Thanks in advance.

Kind regards,
Nordin

**xladept** · 02-17-2018, 05:04 PM

Hi Nordin,

Here's a macro:

Please Login or Register  to view this content.

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name
*Be sure to save the book with the code as Macro-Enabled

**sandy666** · 02-17-2018, 05:20 PM

Duplicate

https://www.excelforum.com/excel-for...y-a-comma.html

**6StringJazzer** · 02-17-2018, 06:13 PM

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

**Nordin1981** · 02-18-2018, 05:48 AM

Thanks xladept,

I have never worked with Macro's before therefore this all looks like Chinees to me, I have tried to follow your steps but it seems that I am doing something wrong. Can you maybe put the marco in my excel sheet this way I can trace back the steps that you have taken?

Kind regards,
Nordin