+ Reply to Thread
Results 1 to 2 of 2

transpose loop with "empty cell" condition

  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    Lund, sweden
    MS-Off Ver
    Excel 2007
    Posts
    1

    transpose loop with "empty cell" condition

    Hi,

    As I'm a total beginner when it comes to macros, I would really need help with looping a macro throughout my spreadsheet, conditioned by empty cells. I'm probably not that good at explaining, so below I've attached the example. My only comment is that the ORDER in which the cells are being transposed is extremely important, as u can also notice from the file.

    Thanks in advance, your help will be highly appreciated !
    Ana
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: transpose loop with "empty cell" condition

    Hello Ana
    Welcome to the forum
    The attached is a simple 'loop' solution as requested
    Run the macro called "trpose"
    The code is commented for you to customise
    Barry
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1