How to add next cell value

[azii]

From table 2
1 2 3 4 5 6 are the dates
daily I have to fill one colum (e.g. culum 7 means 07-03-2013)
when filled
I need table 1 to be filled auto
I am unable to develop any formula.
Please help me solving this issue.

TABLE 1​

TODAY SALE
Warehouse	NP	CAN-G	UREA
Ahmedpur East 1 <tbody> </tbody>	-	-	-
Bahawal Pur 1 <tbody> </tbody>	-	-	-
Bahawal Pur 2 <tbody> </tbody>	-	-	-

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

TABLE 2​

Warehouse	Prod	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	TOTAL=
Ahmedpur East 1	NP							05 10																									10.00
Ahmedpur East 1	CAN-G							20																									-
Ahmedpur East 1	UREA							25																									-
Bahawal Pur 1	NP							30																									-
Bahawal Pur 1	CAN-G						35	18																									35.00
Bahawal Pur 1	UREA							12																									-
Bahawal Pur 2	NP																																-
Bahawal Pur 2	CAN-G																																-
Bahawal Pur 2	UREA																																-

<colgroup><col><col><col span="5"><col><col span="25"><col></colgroup><tbody>
</tbody>

 

[patel45]

upload a sample file with (current and desired tables) on a share site then paste the link here

 

[azii]

Please guide me where to upload the files.