VBA for cell rearranging

[ryanmic]

Pls help to rearrange this information using VBA. Find attached excel file for your reference. Need help in solving this.

[MarvinP]

Hi ryanmic,

This is close to a Pivot Table - see attached. But..... not what you wanted exactly....

See http://www.pivot-table.com/excel-piv...le-values-area for the possible next step.

[Mordred]

Your post does not comply with Rule 10 of our Forum RULES. Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly.

[ryanmic]

need a vba code to find a solution

[Mordred]

Try the uploaded workbook.

[ryanmic]

Try the uploaded workbook.

Thanks for your effort Mordred, if you see my attached i have two tables, table1 is the raw one from which table2 would be derived, cell content("Task" field) would be combined if it matches that name & time criteria. I hope you would help.
Thanks.

[watersev]

hi, ryanmic, please check attachment, run code "test"

[ryanmic]

Hi Watersev,
This is too good, i thank for this kindness. I have been trying to gain similar knowledge and also help. Can you suggest were I can get to know more about VBA functions and properties .

[watersev]

hi, ryanmic, there many teaching possibilities on-line, this forum is a nice place to learn from. The only thing required form you is your desire.

In terms of VBA functions and properties there are many on-line resources available but you can always refer to VB help file which is pretty good and clear mostly.