Extract & Enter Data in excel

[nabeelahmed]

Hi Friend, Can somebody help me for below attached file, I have mentioned in sheet 2 what i required.

Stock sheet Working.xlsm

1 file sent via WeTransfer, the simplest way to send your files around the world

we.tl

 

[nabeelahmed]

Hi Friend, Can somebody help me for below attached file, I have mentioned in sheet 2 what i required.

Stock sheet Working.xlsm

1 file sent via WeTransfer, the simplest way to send your files around the world

we.tl

Dear Friends, I have described below what i am trying to do and i need your help in this regard, Please help me.

(What i want to do)
1- When I enter Tag# following Should be shown in Sheet 2
(i) Item Description from Sheet1 Last entry for the same Tag#
(ii) UOM from Sheet1 Last entry for the same Tag#
(iii) Unit Price from Sheet1 Last entry for the same Tag#

2- What Quantity i will enter in Issue Field in Sheet2 should be added in issued Quantity Column in Sheet1 and should be issued from old dates entry first then from next date and so on

3- Current stock should be shown in Sheet2 Column "Current Stock" (for the entered Tag# stock from Sheet1 total of all dates of entry)

4- Date from Sheet2 should be enter for the same Tag# into Column"Issuing Date" in Sheet1