1. I have two worksheets, sheet1&sheet2, Sheet1 data and sheet2 as a summary.
2. I want to summarize qty of item sold(or purchased) in qty filed, for each item. (items are summarized with unique function). qty of items purchased and sold should be reflected against individual item.
3. please suggest the way to do this which will keep updating automatically
2. I want to summarize qty of item sold(or purchased) in qty filed, for each item. (items are summarized with unique function). qty of items purchased and sold should be reflected against individual item.
3. please suggest the way to do this which will keep updating automatically