Find / Cut / Paste

[seedub]

potentials.xls
	A	B	C	D	E	F	G
28	26375	320gTostitosRSTC			39.695	4670
29	23672	50gNachoDoritos(WhiteVend)			2.462	144
30	23771	50gNachoDoritosVP-VFS			2.332	68
31	25012	28gNachoDoritos100Count			3.346	78
32	26069	40gNachoDoritos			1.710	83
33	26391	280gNachoDoritos			9.063	1710
34	26394	280gCoolRanchDoritos			12.333	2327
35	26397	280gBoldBBQDoritos			0.270	51
36	26401	430gNachoDoritos-XXL			4.716	786
37	26534	70gNachoDoritos			3.232	202
38	26897	75gNacho			10.571	783
39	26899	75gCoolRanch			0.486	36
40	26902	75gBoldBBQ			0.405	30
Wed Pkg

I am looking for a way (macro) to find, cut and paste values from another sheet to this one. As you can see in column A there are 5 digit product codes. There can be anywhere from 1 to 50 codes on this sheet. What i need is to be able to look up on another sheet called "Actuals" (see diagram below), find the corresponding code and paste the value from column B in the actuals tab, to column G (cases produced) in the sheet above.

If the lookup doesnt find a product code, it should enter a "0" into column G

my best guess is to cut and paste the values because after all the lookups are done if there are any remainders left in the Actuals sheet, the product code(column A) and corresponding number in column b needs to be moved into the sheet above, on the next availible line. (pasted into columns A (product code) and G(cases produced)).

Hopefully this is understandable

thanks

potentials.xls
	A	B	C	D
1	23672	700
2	23771	490
3	25012	1854
4	25013	792
5	26069	2505
6	26375	2664
7	26391	331
8	26394	48
9	26397	1169
10	26401	4
11	26534	5
12	26897	213
13	26899	8549
14	26902	85
Actuals

 

[Evagrius Ponticus]

Does it have to be a macro? I think it can be done using native excel functions.

 

[seedub]

the only reason im asking for a macro is because that is only the "dayshift" production. On this same sheet below what you see is sections for afternoons and midnights..

the report that is imported into the actuals tab is imported 3 times a day and changes in length as well as what is produced every shift. I figured it would be easier to have a macro set up for each shift of every day of the week to do this, then it would be to hard code it. as this file is wiped clean every week and setup for the next week.