Excel macro - data transfer. is this possible?

[limey13]

So i am wondering if there is a macro that willallow me to type in on one sheet a list as follows (example)
<!--[if !supportLineBreakNewLine]-->
[TABLE="width: 200"]
<tbody>[TR]
[TD]component x[/TD]
[TD] 02Jul13[/TD]
[TD]p[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]component y[/TD]
[TD]02Jul13[/TD]
[TD]q[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]component z[/TD]
[TD]04Jul13[/TD]
[TD]r[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]component x[/TD]
[TD]02Jul13[/TD]
[TD]s[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
etc
<!--[endif]-->
and then running the macro will pull thatinformation into a master sheet already set up like below

[TABLE="width: 200"]
<tbody>[TR]
[TD][/TD]
[TD]component x[/TD]
[TD]component y[/TD]
[TD]component z[/TD]
[/TR]
[TR]
[TD]02Jul13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03Jul13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]04Jul13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Basically i need the macro to look at the datecells and component cells, match them with the final sheets location and placethe amount into the appropriate cell. also while running a summation if thesame component is used more than once on the same day.

runningthe macro on the given example would result in :


[TABLE="width: 200"]
<tbody>[TR]
[TD][/TD]
[TD]component x[/TD]
[TD]component y[/TD]
[TD]component z[/TD]
[/TR]
[TR]
[TD]02Jul13[/TD]
[TD] p+s[/TD]
[TD]q[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03Jul13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]04Jul13[/TD]
[TD][/TD]
[TD][/TD]
[TD]r[/TD]
[/TR]
</tbody>[/TABLE]


does this make sense? and is it possible? Thankyou!

 

[wigi]

Hello

Did you try a Pivot table?