BrutalDawg
New Member
- Joined
- Jun 10, 2015
- Messages
- 41
Hello,
Here is what I would like to do. I have Sheet1 with a list of item numbers in column A and quantity in column B. On sheet2 the list will have Destination(A) Item Number(B) Due Date (c) and quantity (D). Sheet 1 is our quantity we have, while sheet2 is the demand schedule. I need a macro, that will compare item number and quantity from sheet 1 -> sheet 2 -> then display results on sheet3. My end goal is to be able to show current inventory compared to the two or 3 week demand from sheet2 for each item number. Any help would be awesome!
Here is what I would like to do. I have Sheet1 with a list of item numbers in column A and quantity in column B. On sheet2 the list will have Destination(A) Item Number(B) Due Date (c) and quantity (D). Sheet 1 is our quantity we have, while sheet2 is the demand schedule. I need a macro, that will compare item number and quantity from sheet 1 -> sheet 2 -> then display results on sheet3. My end goal is to be able to show current inventory compared to the two or 3 week demand from sheet2 for each item number. Any help would be awesome!