Weezer
09-27-2010, 08:47 AM
Hello Everyone!
I want to write a Macro that converts the rows to columns & columns to Row values. I have dates as headers, I want to make them into row values, I'm having trouble doing this, is there a formatting function that can help me do this? Since I'm converting Row values to Column names, I want them to be dynamic. I know which row the values start from (44) & which row they end at (156). I want to get all the Rows between this range & convert them to column headings. I'm having a lot of trouble & I don't know how to go about this.
Can someone please help me out!Any help would be highly appreciated.
Thanks
I want to write a Macro that converts the rows to columns & columns to Row values. I have dates as headers, I want to make them into row values, I'm having trouble doing this, is there a formatting function that can help me do this? Since I'm converting Row values to Column names, I want them to be dynamic. I know which row the values start from (44) & which row they end at (156). I want to get all the Rows between this range & convert them to column headings. I'm having a lot of trouble & I don't know how to go about this.
Can someone please help me out!Any help would be highly appreciated.
Thanks