Find / Cut / Paste

seedub

New Member
Joined
Sep 26, 2007
Messages
11


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
ABCD
123672700
223771490
3250121854
425013792
5260692505
6263752664
726391331
82639448
9263971169
10264014
11265345
1226897213
13268998549
142690285
Actuals
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

seedub

New Member
Joined
Sep 26, 2007
Messages
11
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,606
Messages
5,597,134
Members
414,128
Latest member
Jorglo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top