PDA

View Full Version : Re-arranging columns and rows



futonguy
11-18-2010, 09:21 PM
Hi,

this is the 1st time i am using Excel VBA and i do need lot of helps (if possible) to guide me through.

Basically i am trying to create an automatic bar chart plotting using Excel VBA. Unable to copy the excel format here, so i uploaded an example of what im trying to mean onto this forum.
The original data information (1st box) was given to me, however i would like to use VBA to re-arrange to the 2nd box.


Can anyone able to guide me with this?
Thanks

kemas
11-18-2010, 11:32 PM
in a16
=TRANSPOSE($D$7:$D$11)
ctrl+shift+enter

futonguy
11-19-2010, 12:04 AM
Hi Kemas,
what do you mean by ctrl+shift+enter ??

orange
11-19-2010, 08:16 AM
Seems to be an Excel issue --- wrong forum???