Automatic Key In

JXChin - Feb 4, 2016 at 02:12 AM

I have 2 main sheets at play here:
SS Order
Order Placement

SS Order is a supply allocation form that has loads of past records and has a date cell which I can change. Order Placement is basically just where i would manually copy and paste my allocation into. It is a long page filled with dates at the top which I have to manually check for in order to paste the allocation at the right date slot.

How can I have it so that the VBA checks for the date I set at SS Order on a row of dates in Order Placement. Then, it copy and pasted my column of order(in SS Order) one cell below the date matched in Order Placement?