generating named data based on values

[abz2786]

Hi Guys

I am creating a master spreadsheet and need some formula help.

I am trying to pull through names of employees based on if they have a value against a project

For example

A,B,C are three projects on three seperate tabs. Person D,E,F are employees. Person D and F have logged time against Project A.

On the master sheet i have a created a column of projects (A,B,C) and want to pull through the names (D,E,F) if they have any values against the project below the relevant project. How do i do this?

Thanks

 

[abz2786]

Only the name of Sheet1 changes

Set sh1 = Sheets("[COLOR=#ff0000]Sheet1[/COLOR]")

If everything else is like the sheet you sent me, the macro should not have problems.
Take a test

I have tried to apply the macro to my spreadsheet and the macro is working but it does not pull through any data to the front sheet when i click on it. Also, how do i limit the macros so it picks up data only up until row 35 on each tab. Spreadsheet is shared below

https://www.dropbox.com/s/t9q5n0ezvzghmaq/Capacity Plans.xls?dl=0

 

[DanteAmor]

I have tried to apply the macro to my spreadsheet and the macro is working but it does not pull through any data to the front sheet when i click on it. Also, how do i limit the macros so it picks up data only up until row 35 on each tab. Spreadsheet is shared below

https://www.dropbox.com/s/t9q5n0ezvzghmaq/Capacity Plans.xls?dl=0

I'm not understanding.
I sent you a file to show that the macro works.


What is the problem?


If your files are the same as the example you sent me, you should not have problems.


If you sent a different file and now you want to work with another file completely different from the initial one, then you are going to need another macro


The macro I sent you is designed for the first file you sent me.