hi Dears,

I have three worksheets i.e Sheet1, Sheet2, Sheet3. In Sheet1 I have
three Colomuns

Col1 Col2 Col3
Date Stock Consumption Amount
: : :
: : :
and so on

In Sheet2 I have three Col

Col1 Col2 Col3
Date Stock received Amount
: : :
: : :
an so on

I would like to copy data from sheet1 and sheet2 based on Col1 for a
specific period into sheet3. Sheet3 should be shown just like a Stock
Register

Col1 Col2 Col3 Col4 Col5
Col6
Date Opening Stock Received Total Consumption
Closing

Can any body write codes for me and for other learners.

Thanks

Syed Haider Ali


--
Syed Haider Ali
------------------------------------------------------------------------
Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994
View this thread: http://www.excelforum.com/showthread...hreadid=570421