Results 1 to 2 of 2

Thread: Autofomrat Group of rows with same cell value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Question Autofomrat Group of rows with same cell value

    Hi

    Column A contains account numbers, and other columns contains some transactions related to account.

    30552-1 GARCIA, NORMA 8/18/2011 20550
    30552-1 GARCIA, NORMA 8/18/2011 J1040
    30552-1 GARCIA, NORMA 8/18/2011 J2010
    47365-1 HARDEN, BOWDY 2/8/2011 99213
    47365-1 HARDEN, BOWDY 2/8/2011 73110
    24240-1 HENRY, PAUL G 8/30/2011 97110
    24240-1 HENRY, PAUL G 8/30/2011 97140
    48247-1 HILL, RITA A 8/19/2011 99244
    4798-1 HUSSETT, DEVON L 8/30/2011 97110
    4798-1 HUSSETT, DEVON L 8/30/2011 97140
    4798-1 HUSSETT, DEVON L 8/16/2011 97110

    I want macro to select group with same account number and then format it with alternate colors band and border.

    I have attached screen shot as well excel sheet
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	excel format.jpg 
Views:	36 
Size:	98.3 KB 
ID:	1152  
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •