Excel excel programming technics

[sknyer]

Hi,

I am very new to Excel Programming. Ofcourse, handling since last few years creating some reports, importing data, and some calculations are also done.

But, I need to program for my daily work i.e.

I want to input every day purchase and selling data raw by raw and and atlast getting calculated.

Now I need a new format, for inputing in a sheet, a specific location is selected
where daily inputs are entered, such us inward purchase data and payment details as well as selling data and payment inward bill wise.

My desired field is -

purchase
date (Entry field) ill No. Entry field) particular Entry field) qty Entry field) valueEntry field)

payment
chq no. date amt

Selling field

Inv.no date qty Amt

The above are input and output field which is common

the Date wise result must be shown below the above i/o data field in same page Like this


Report format
Purchase Payment Sales
------------------------------------------------------------------------

date Inv.No. Qty. Value Chq.nO. Amt. Bill DAte Qty. Amt
--------------------------------------------------------------------------

xxxx xxxx xxxx xxxx xxxx xxxx xxx xxxx xxx xxx


the report will be produced automatically one by one (date Wise)

Can any body help me plese