copy with matched cases

C

chrisdtran

Hi all;
I would appreciate for any of your help!
In my worksheet "Receiving", column A contains part names & column B
contains quantities of each part that I receive and enter daily. e.g:
A1=part1; A2=part11; A3=part200; B1=100; B2=200; B3=300 (entry on day
1).
What should I do to achieve the followings once an assigned "Macro"
button is activated:
1. In worksheet "Inventory", Column A remains unchanged that contains a
list of 200 part names: where A1=part1; A11= part11; A200=part200.
2. Enter the date one column to the right to the previous date. Let
say; Column B for today entry, column C for tomorrow entry and so on.
3. The quantities of each part are stored accordingly on each "date"
column and correct/matched part name on each "Part Name" row.

Thanks so much.
 
Top