Macro to create a repoart from a table. Excel 2010

Quick support from the experts is needed to create a macro to accomplish step 2 below (I will post another question today under my username to see if an approach I suggest can lead to the answer:

1. takes the table in the attached excel file in sheet "Data". This is the sheet with the input to the Macro.

2. Needing macro to create an output of a table based as per sheet "RESULT WANTED".

Clarification on step 2 (following explanation referencing sheet "RESULT WANTED".
-The grey section i.e. column headers (C3:P3) is fixed label and the rows headers (A4:A107) stay with same labels.
-The projects that match the label (for example: RFQ-Est. and week "2015..Wk3" its project name should be written in that cell (for example as in cell B6).
-In this case there are two projects which fulfill this criteria so both are included in the same cell, where each consequent project after the first one in that cell (others where more than one project fulfill the same criteria) and are entered in the same cell but in the next line below (manually one would hit SHIFT+ENTER).
0_Table_Macro.xlsx
easycapitalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

easycapitalAuthor Commented:
No answers yet.

I am still looking for the same output.

But to put my question from Another perspective.

When one uses a lookup formula excel bring only the first results which matches the criteria, but in this case I already know there may be several which may match the criteria - then I am already asking how to deal with this scenario.

I am looking to be able to list all the values which match the criteria and insert them in the same cell.

Please ask if you have any questions, this post is very urgent and important for me.

Thank you.
0
DougCommented:
Easy,
I don't have a solution but I do have some questions. How important is the structure that you've provided on the RESULT WANTED sheet? Are you open to a different format? Would a VBA solution be acceptable?
0
easycapitalAuthor Commented:
VBA solution would definitely be accetable.
Could you please provide a solution within an excel file?
Thank you.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

DougCommented:
Your Results Wanted sheet lists Week information in this format: 2015..Wk_1
but your Macro_Output sheet lists Week information in this format: YR15-Wk_1. Which is the correct format?
0
easycapitalAuthor Commented:
I have now changed it to Y15..W_1 to have it more clean.
0
DougCommented:
easy,
I found a solution without using VBA.  It requires additional formulas on the Macro_Output sheet. In addition, you'll need to sort columns A through D by column D in ascending order. See the comment in cell E5.

I did not change the Year and Week format to your revised format. That's something that you'll be able to revise. Just make sure that the Year and Week values in column A of RESULT WANTED are the same as those in column E of Macro_Output.
0_Table_Macro-with-button-and-repor.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DougCommented:
Easycapital,
Still waiting for an indication as to whether your question was answered. Please let us know. Thanks.
0
Martin LissOlder than dirtCommented:
I've requested that this question be closed as follows:

Accepted answer: 500 points for bugdrown's comment #a41067744

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
easycapitalAuthor Commented:
Thank you!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.