Code/Macro to populate table based on user input.

Hello Happy Campers!
(first off, nice new look forums!)

I have a workbook (attached)

Sheet1 - Main Table
Sheet2 - Data

In sheet 2 i will add info into cells A1 & B1 (always 2 cells as A is the item, & B is the qty) and there will always be more than one line of data, but not a fixed amount.

I would like either formula's or Code to do the following;
From the info, populate 'Main Table' by looking at the item and then placing the respective qty in the column with matching date. (date, taken from date of entry on sheet or would i need to add a cell with the date i want to add/find?)

The sheet attached has the info how i would like it to look.

Many thanks in advance

Galvinpaddy

Sorry fella, i cannot see a file that has been loaded, it also appears that the files i loaded yesterday are missing unless its something wrong my end??
Would you be able to email me the file if i PM you my email address?