amolvaishnav
New Member
- Joined
- Sep 21, 2010
- Messages
- 33
i have specific data in different sheets like :
sr no. subassemblyname part no qty amount
1 do trolley 1234 10 100
2 do trolley 4567 05 50
3 -"- 455 1 1000
4 PT Trolley 0124 5 25000
5 PT Trolley 202 10 100
and so
what i need is to select only the unique subassembly name and the total amount
ex.
1 do trolley 1150
2 PT Trolley 25100
this is the data i require in the index sheet
so i get the unique costing in my index page using only unique names and total amount
sr no. subassemblyname part no qty amount
1 do trolley 1234 10 100
2 do trolley 4567 05 50
3 -"- 455 1 1000
4 PT Trolley 0124 5 25000
5 PT Trolley 202 10 100
and so
what i need is to select only the unique subassembly name and the total amount
ex.
1 do trolley 1150
2 PT Trolley 25100
this is the data i require in the index sheet
so i get the unique costing in my index page using only unique names and total amount
