Automated populating project names on sheet 2.xlsx

[Mysore]

Hi All,

Can someone please help with the below request:

Sheet 1: I have project name and resources against it
Sheet 2: Where I have list of resources and in teh second column I want their list of project names to be appeared. (single/multiple projects)

Attached is the Excel for refrence.

Please help.

Thanks,

 

[vletm]

Mysore
Based Your title
... without any code.

 

[Mysore]

Thanks for your reply.

However, the requirement is not to have pivot but automatically fill the column B in Sheet2 with reference to Sheet1.

May be I was not clear in my previous description.

Can you help me?

Thanks,

 

[rahulshewale1]

hi @Mysore,

Office 365 Solution using Dynamic Arrays

=TEXTJOIN(",",TRUE,FILTER(Sheet1!$A$1:$A$18,(Sheet1!$B$1:$B$18=Sheet2!$A2)))

or else
i have attached power query Solution.

 

[vletm]

Mysore
Was Your the requirement to have only VBA Macros-solution?
... because Your thread is in it.

 

[Mysore]

Could you please help me in explain me the step by step. If I copy the formula and do the same thing. It's not working

 

[Mysore]

Mysore
Was Your the requirement to have only VBA Macros-solution?
... because Your thread is in it.

I was just thinking if we could solve it by Macro

 

[vletm]

Mysore
Did You test my file?
... it's a sample of VBA Macros-solution.

 

[Mysore]

Mysore
Did You test my file?
... it's a sample of VBA Macros-solution.

Not getting. Can someone give me a solution and explaination plz

 

[vletm]

Mysore
Did You open that file?
Did You select 'Sheet2'?
Did You something happen?
... if not ... then is Your Excel's marcos enabled?

 

[Mysore]

Thanks for the reply, Howvever, if you could paste the code you used for Macro here. was not able to find it out

 

[vletm]

Mysore
I tried to ask four questions
... and You could skip all of those.
I should guess that it works
... that means - the code is there ...
1> Move Your mouse cursor over Sheet2-tab

2> Select View Code
3> Scroll code lower