Easy Macro to copy data based on value Macro or Vlookup or other formula?

[GSBR88]

Hi everyone,
Can anyone help me out with this tricky situation, I have a Excel form to be filled based on the name of a person , but if the score is 0 I should not pick it. whats the easy way to do this? Macro or Vlookup?
[TABLE="width: 761"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Smith 73 Data[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ISO 13485 & Policy Manual[/TD]
[TD]PPM - 01[/TD]
[TD]F[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Document Control[/TD]
[TD]pSP 4.2-1[/TD]
[TD]B[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Control of Records[/TD]
[TD]pSP 4.2-2[/TD]
[TD]F[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Change Order[/TD]
[TD]pSP 4.2-3[/TD]
[TD]F[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Management [/TD]
[TD]pSP 5.6-1[/TD]
[TD]C[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Training[/TD]
[TD]pSP 6.2-1[/TD]
[TD]D[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Environment[/TD]
[TD]pSP 6.4-1[/TD]
[TD]B[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Project[/TD]
[TD]pSP 7.1-1[/TD]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Validation[/TD]
[TD]pSP 7.1-2[/TD]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

------------------------------------------------ Result --- Form should be looking like this at end, skipping 0 score documents.

[TABLE="width: 761"]
<tbody>[TR]
[TD="colspan: 4, align: center"]Check Form[/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD]Smith73[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Score[/TD]
[TD]Document ID & Rev.[/TD]
[TD]VER[/TD]
[TD]Description[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]QPM - 01[/TD]
[TD]F[/TD]
[TD]ISO 13485 & Quality Policy Manual[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]QSP 4.2-1[/TD]
[TD]B[/TD]
[TD]Document Control[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]QSP 4.2-2[/TD]
[TD]F[/TD]
[TD]Control of Records[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]QSP 4.2-3[/TD]
[TD]F[/TD]
[TD]Engineering Change Order[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]QSP 6.2-1[/TD]
[TD]D[/TD]
[TD]Training and Qualification[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]QSP 6.4-1[/TD]
[TD]B[/TD]
[TD]Work Environment[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]QSP 7.1-1[/TD]
[TD]A[/TD]
[TD]Project Controls[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]QSP 7.1-2[/TD]
[TD]A[/TD]
[TD]Validation of Processes[/TD]
[/TR]
</tbody>[/TABLE]

 

[LloydFinancials]

Hello GSBR88,

Since you are indexing off the person's name, what does the database look like where you are looking up the name? Is there a name then info below, then a second name below then info for the second name below that? I can convert the top table to the bottom table, but it is just a data conversion. I am not sure how the name fits in yet.

Luke

 

[GSBR88]

HI Luke,
Thank you for your reply, Its more complicated than it looks- There is a data of different users and there documents details in one page which is coded by color. So there is form need to be filled with the same details based on color, the above is just a trail to covert data to form and here is a real file how it looks. Any suggestions will be appreciated.

Fill Form click to open image.

Thank you
GSBR88

 

[LloydFinancials]

I can't open your attachment. Maybe use google drive or Forum Tools addin link here: https://www.dropbox.com/s/31r9s6t9j69lkab/Forum Tools.xlam?dl=0

 

[GSBR88]

https://drive.google.com/open?id=0B7EOXzyKqlXNTW82ZnEtcGJLWE0

So this is a color based recognition.
EX: for smith41 i need to pick up top Documents Name (Top Row) based on color Green ( done), (Red) not done and Yellow in progress. End of the day I am trying to convert to Form with user name and their documents list. Any help will be truly appreciated.
Thank you

GSBR

 

[GSBR88]

https://drive.google.com/file/d/0B7EOXzyKqlXNTW82ZnEtcGJLWE0/view?usp=sharing

 

[LloydFinancials]

Ok. So lets look at Smith57. What will the solution and colors look like when he is done? Please provide in Excel: a sample of data before and after, and a solution tab or Form for Smith 57. I am not sure what you mean by Form?