hi
so i need to convert a table into a different form using vba
ex. say a spreadsheet has two tables
Date : q/q/qq
a b c
j 1 2 3
k 3 2 1
l 2 3 1

Date : x/x/xx
x y z
q 1 2 3
w 3 2 1
e 2 3 1

to

Date RowHead ColHead Value
q/q/qq a j 1
q/q/qq a k 3
q/q/qq a l 2
q/q/qq b j 2
q/q/qq b k 2

You get the idea I have to do this in vba and the data is stored as a vba array in memory and is on the spreadsheet as well.

Hi

Since there is not direct option to transpose etc, you need to loop through the Array and then place the value in cells

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Thats what i am having a problem with i dont get how to place the valeus in a new arrya without using like 8 nested for loops

Hi

If this is multi-dimensioned array, you need to plan how to place the elements in the array so that the transpose can be done easier

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)