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]-->
<tbody>
</tbody>etc
<!--[endif]-->
and then running the macro will pull thatinformation into a master sheet already set up like below
<tbody>
</tbody>
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 :
<tbody>
</tbody>
does this make sense? and is it possible? Thankyou!
<!--[if !supportLineBreakNewLine]-->
| component x | 02Jul13 | p | |
| component y | 02Jul13 | q | |
| component z | 04Jul13 | r | |
| component x | 02Jul13 | s |
<tbody>
</tbody>
<!--[endif]-->
and then running the macro will pull thatinformation into a master sheet already set up like below
| component x | component y | component z | |
| 02Jul13 | |||
| 03Jul13 | |||
| 04Jul13 |
<tbody>
</tbody>
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 :
| component x | component y | component z | |
| 02Jul13 | p+s | q | |
| 03Jul13 | |||
| 04Jul13 | r |
<tbody>
</tbody>
does this make sense? and is it possible? Thankyou!
