Hi can anyone help?
I have some Data in Range("A5:H5") and a named Range("A5:H11")
I get new set of results in Range ("A3:H3") after filtering some Data and then transpose the results into the first column of my named Range ("A5:A11") using the following code
ie
<tbody>
</tbody>
And with the next set of results in Range ("A3:H3") after filtering more Data, I want to transpose the results in the same way to the next available column in the named range but I am struggling to find the Next Empty Column within the Named Range so I can transpose the results using the same method as above.
ie after filtering more Data the next results would be transposed into Range ("B5:B11) and so on...
<tbody>
</tbody>
Any help would be much appreciated
Regards
pwill
I have some Data in Range("A5:H5") and a named Range("A5:H11")
I get new set of results in Range ("A3:H3") after filtering some Data and then transpose the results into the first column of my named Range ("A5:A11") using the following code
Code:
[FONT=Verdana]Range("A5").Resize(7, 1).Value = Evaluate("transpose(Data!A3:H3)")[/FONT]
ie
A | B | C | D | E | F | G | H | I | J | K | |
1 | |||||||||||
2 | |||||||||||
3 | 1 | 3 | 5 | 7 | 9 | 11 | 13 | ||||
4 | |||||||||||
5 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||||
6 | 3 | ||||||||||
7 | 5 | ||||||||||
8 | 7 | ||||||||||
9 | 9 | ||||||||||
10 | 11 | ||||||||||
11 | 13 | ||||||||||
12 | |||||||||||
13 | |||||||||||
14 | |||||||||||
15 |
<tbody>
</tbody>
And with the next set of results in Range ("A3:H3") after filtering more Data, I want to transpose the results in the same way to the next available column in the named range but I am struggling to find the Next Empty Column within the Named Range so I can transpose the results using the same method as above.
ie after filtering more Data the next results would be transposed into Range ("B5:B11) and so on...
A | B | C | D | E | F | G | H | I | J | K | |
1 | |||||||||||
2 | |||||||||||
3 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | ||||
4 | |||||||||||
5 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||||
6 | 3 | 4 | |||||||||
7 | 5 | 6 | |||||||||
8 | 7 | 8 | |||||||||
9 | 9 | 10 | |||||||||
10 | 11 | 12 | |||||||||
11 | 13 | 14 | |||||||||
12 | |||||||||||
13 | |||||||||||
14 | |||||||||||
15 |
<tbody>
</tbody>
Any help would be much appreciated
Regards
pwill