View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikeburg[_44_] mikeburg[_44_] is offline
external usenet poster
 
Posts: 1
Default Create a list of unallocated payments


Help? When clicking a spreadsheet, I am trying to create a simple list
of customer numbers & payments from another spreadsheet whose payments
are unuallocated. For example:

On sheet "CRJournal":

No. Paymt Allocated
553 16.50 16.50
256 58.49
249 38.50 38.50
268 39.49
244 85.30
412 88.79 88.79
569 49.04 49.04
424 40.24


I need:

On Sheet "UallocatedCalcs":

No. Paymt
256 58.49
268 39.49
244 85.30
424 40.24

Any & all help with this sheet activate code will be greatly
appreciated.

mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=474481