Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy & paste non blank cells (Excel 200)

    I have a worksheet named EAA with data from different geographical areas in Columns A, B, C, D, E, F, G, The data is dynamic and changes from week to week. In column K & L the subtotals for the various geographical areas are displayed. I would like to copy the subtotals in Column K and the corresponding area code in column L in the adjacent cell and paste (Values only) to a worksheet called Summary but without the blank cells that are in between the subtotals starting in Cell B3. Could someone please help out with a formula or a macro? Thank you

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Copy & paste non blank cells (Excel 200)

    Could you post a sample sheet so we can see the exact layout?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Aug 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy & paste non blank cells (Excel 200)

    I have attached a sampe worksheet to explain what I am after. Thank youi
    Attached Files Attached Files

  4. #4
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy & paste non blank cells (Excel 200)

    Your Sheet EAA, cell H4,

    entered the formula and copied bown to H7 :

    =LOOKUP(2,1/(C$1:C$5000=G4),D$1$5000)

    Regards
    Bosco

Posting Permissions

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