copying new data on a w'sheet without deleting historical data, and recalculating

Hi guys, im just stuck on this, its probably not that hard, any help would be much appreciated.

There are 3 sheets - raw,A, and B
In 'raw' i will have unfiltered data from which i need to transfer 2 cells onto Sheet A and B. I need the Date and 'Total Equity' (which will be called Price in Sheet A/B).....the code should be something like -' If Column A has accoun# 323 and column G = USD, then copy the corresponding cells in column C(date) and column E (total eq.), send iit to sheet 'A', if acct# is '540' and colimn G =USD then send the corresponding Column C,E amounts to sheet 'B'.



Take a look at the Sheet ‘A’, I need new data to be entered into the sheet(in Row 2 everyday, without deleting any of the previous historical data). Then once this is imported into the sheet I want the following calculations to be run on the new figures

- Index (which is C2/$C$3777*100)

– Daily % change (which is LN(C2/C3))…should be done for whole column

- Volatility – (STDEV(E3:E3777)*SQRT(252))

- Cummulative Return - E2+G3

- Drawdown - ‘ –(MAX($G5:G$3776)-G5)


I hope that wasnt too confusing, if unclear please ask

thanks in advance