hi,
I am looking to have all data on one sheet and have total amount of a group
on another sheet, how do i do this??

this may seem simple to experts liek you but today si an off day for me : )
thanks for your help