G'day forum goers,

I've done my googling, done my lurking, done multiple help/sticky/faq's...
And I'm stuck!

New to VB so it's challenging for me as I don't know the syntax (nor is the office vb an easy one to use...) so forgive me if this is impossible or incredibly simple to do!

The problem:
I'm recording receipts in excel and currently im doing that using a table with the following columns -> Date, Company, ABN, Product, Q, CPU, Total, R_Total, Type, TD.
I enter the data from the receipts and then wish for a new row to be inserted above with some of the data prefilled if possible.
Things I'd like prefilled is date, company, abn to be a copy of the previous entry and Q, type have default values of "1" and "unknown"

If possible I'd like this to be a case of 
IF C2 <> ""
THEN new row above coding goes here with prefilled data
soooo big question - can this be done? Bigger question - if so how?