Excel macro - data transfer. is this possible?

limey13

New Member
Joined
Aug 1, 2013
Messages
1
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]-->
component x 02Jul13p
component y02Jul13q
component z04Jul13r
component x02Jul13s

<tbody>
</tbody>
etc
<!--[endif]-->

and then running the macro will pull thatinformation into a master sheet already set up like below

component xcomponent ycomponent 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 xcomponent ycomponent z
02Jul13 p+sq
03Jul13
04Jul13r

<tbody>
</tbody>


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

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,953
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
Hello

Did you try a Pivot table?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,680
Messages
5,524,249
Members
409,566
Latest member
MickB

This Week's Hot Topics

Top