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

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

Originally Posted by AB33

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!!

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?

Originally Posted by AB33

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.