Xrull
06-22-2010, 05:41 PM
Good day everybody,
The accounting system I work with produces reports in Excel, but the data is easily manipulated.
In column A here are always 10 lines of data that represents a type of heading.
There is another set of headings that go from column B to O then there is an empty row, then that is followed by a block of data. This pattern repeats until it gets to the end of the worksheet.
It is very difficult to explain how the data is set up.
All I need to do is add 3 columns on the sheet named Fixed, and use the headings in the columns B to O on the Disjointed sheet and put those headings in columns D to P.
The sheet named Disjointed shows how the data looks when it is downloaded, and the sheet named fixed shows the data should look.
This is a cross post. I posted here yesterday, but I didn't get a reply:
http://www.excelforum.com/excel-programming/733957-disjointed-information-to-table.html
I'm trying to use the offset formula in P14, but I can't follow through:
=IF(OFFSET($O13,-1,-13)=" Sloc",OFFSET(O13,-10,-14),"")
I'd appreciate a VBA solution.
Thanks,
Xrull
The accounting system I work with produces reports in Excel, but the data is easily manipulated.
In column A here are always 10 lines of data that represents a type of heading.
There is another set of headings that go from column B to O then there is an empty row, then that is followed by a block of data. This pattern repeats until it gets to the end of the worksheet.
It is very difficult to explain how the data is set up.
All I need to do is add 3 columns on the sheet named Fixed, and use the headings in the columns B to O on the Disjointed sheet and put those headings in columns D to P.
The sheet named Disjointed shows how the data looks when it is downloaded, and the sheet named fixed shows the data should look.
This is a cross post. I posted here yesterday, but I didn't get a reply:
http://www.excelforum.com/excel-programming/733957-disjointed-information-to-table.html
I'm trying to use the offset formula in P14, but I can't follow through:
=IF(OFFSET($O13,-1,-13)=" Sloc",OFFSET(O13,-10,-14),"")
I'd appreciate a VBA solution.
Thanks,
Xrull