View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gale7 Gale7 is offline
external usenet poster
 
Posts: 1
Default pls help!! copy -paste to another sheet. getting the sum

hello, i am a new member in excelforum and a newbi in programming with
macros.
i have the following problem

i have five columns in excel sheet1 (A, B, C, D, E) - (cus_id,
cus_name, date, product, price,)

i want to put a command button where, when i press it, to appear in
sheet2 all the data (rows) leaving a (----------------) every time the
cus_id changes.
finaly i want to take (in sheet2) the sum of each customer, depending
on the customer id.

thnxs in advance



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/