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
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,517
Messages
5,832,211
Members
430,116
Latest member
d1pakjha

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