VBA formula needed to lookup values [SOLVED]

[marcvanderpeet12]

Dear all,


I have an excel sheet which i based like this:

[pre]

Name:        John; Josh; Grace

Activity 1 : 10%
Activity 2 :        20%
Activity 3:              20%
Activity 4:         10%
I would no like to create a VBA code which can show the name with the relevant activities. Kinda like:

John; activity 1; 10%
Josh; activity 2; 20%
Josh; activity 4; 10%
Grace; activity 3; 20%

[/pre]
Anybody tips on how I can achieve it?


Dear regards,


Marc

 

[Luke M]

Will each activity in first table only have 1 number/person for that line, or is it possible multiple people will have data in the same row?

 

[marcvanderpeet12]

No it's possible that for example both John & Josh write have data on activity x.

 

[marcvanderpeet12]

by the way, is it possible to share excel sheets on this forum? Cant find an attachment function...


Dear regards,


Marc

 

[Luke M]

Not directly with the current forum. You can upload a workbook to a file sharing site and post a link here. One of the things I'm most excited about the new forum we'll be going to soon is that it has the ability to directly upload files. =)


Working on the problem with VB...

 

[Luke M]

I think I may have found an answer. Your problem is often referred to as a "reverse Pivot", as your current layout looks like a PivotTable report, but you want the raw data layout. Check out this post:

http://superuser.com/a/78464


Granted, this isn't a formula so it's not "live", but I think it's what you are looking for, and it's certainly one of the easier ways.

 

[marcvanderpeet12]

I works, thanks al lot Luke!