Excel/VBA

Hey,

I was wondering if there is someone to who I could send an excel sheet I am working on.. It would be easier than explaining all my problems on it..

But basically, I am constructing P&L Sheet on excel: I import data from Business Object (the position size) on TAB1 and data from another program (the prices) on TAB2.

I actually encoutered many issues doing it, cause i need it to be automated once those data are dropped in... Dont know if I should use VBA, i was thinking of just using some excel formulaes but its is actually harder than what i tought.. Would be great to talk with a trainer. (Our trainer during the course told us we could send our files and someone would work on it)

Thank you


PS: Exmple of issues
-dates from business object arent formatted as date
-need to use lookup formula with 2 constraints (or index/match) to match the price with specific code & date on the price sheet
-One of the criteria for the lookup is in Column1, but need it to switch to column 2 on certain conditions..