+ Reply to Thread
Results 1 to 5 of 5

Do Until Looping (not looping through all other columns)

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    3

    Do Until Looping (not looping through all other columns)

    Hello!

    Excel 2010 / Windows 7
    I am new to the forum and running into trouble with my Loop. I think I need a loop inside of a loop but haven't really coded in years. I need to take the information on the "Master Tracker" and rearrange the data for the "RawData" sheet. My long term goal is pivot based off the "RawData". Right now it is not looping through all of the columns. Just column B in Master Tracker.

    Master Tracker has column as "A" Account codes
    Column B:1 throught BI:1 as various months
    Column B:6 through BI:166 as various month charges per account code.

    They way it is now is that is is starting with row 6 in my "Master Tracker" and finding the last row in column "A" and reporting the correct values in column B. But I need it to keep doing that for a total of 60 columns. (so start in A:6 find the last row again and report the values in column C, now column D and so on..)

    Master Tracker
    MasterTracker.png

    RawData
    RawData.png

    Any help is greatly appreciated! Thanks in advance!
    60026893.xlsm

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Do Until Looping (not looping through all other columns)

    Where are the data in columns C to last column in the master came from ? I can only see column A. You need to explain and show us the desired result

  3. #3
    Registered User
    Join Date
    02-04-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Do Until Looping (not looping through all other columns)

    Quote Originally Posted by AB33 View Post
    Where are the data in columns C to last column in the master came from ? I can only see column A. You need to explain and show us the desired result
    Thanks so much for your response! I have attached the workbook in the initial post. The VBA code I am having issues with is CreateRawData()

    in the Master Tracker, column A is the account codes
    Column B is Mar 2010
    Column C is Apr 2010
    Column D is May 2010.

    So what happens is that the report finds the accounts codes and reports March 2010 but never gets to Apr, May, etc (column C-BI) - whenever.

    I want to basically turn the Master Tracker into a new list with column headings so I can pivot down the road. The Master Tracker the way it is now is not sortable or pivot-able because of the layout. I can't change the layout of the Master Tracker but need the raw data so I can do something with it.

    Let me know if you have any follow-up questions. I really appreciate your time!!

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Do Until Looping (not looping through all other columns)

    Orle,
    I saw the attached, but find it is diffcult to understand how you ended up in the master sheet. You copied column A of the raw data in to master. How do you get the data from raw in to master?

  5. #5
    Registered User
    Join Date
    02-04-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Do Until Looping (not looping through all other columns)

    Quote Originally Posted by AB33 View Post
    Orle,
    I saw the attached, but find it is diffcult to understand how you ended up in the master sheet. You copied column A of the raw data in to master. How do you get the data from raw in to master?
    It is the other way around. I am taking from the Master and producing Raw Data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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