Dealing with data in rows and columns
 

Hello,
I am working on a huge spreadsheet that has data in several columns an
three rows. I realize grouping the rows will allow me to sort the dat
better, but the data is downloaded daily so if I go through and grou
it, I will have to do it every day. I have been trying to create
macro but haven't figured out how!!! Basically what I want is to b
able to automatically select rows 2 and 3 of the data and group them t
row 1... Does anyone have any ideas? Or any other way I can sort th
data better??

--
RJPerr
-----------------------------------------------------------------------
RJPerri's Profile: http://www.excelforum.com/member.php...fo&userid=2723
View this thread: http://www.excelforum.com/showthread.php?threadid=46743

Dealing with data in rows and columns
 

group them to row 1 ???

"RJPerri" wrote in
message ...

Hello,
I am working on a huge spreadsheet that has data in several columns and
three rows. I realize grouping the rows will allow me to sort the data
better, but the data is downloaded daily so if I go through and group
it, I will have to do it every day. I have been trying to create a
macro but haven't figured out how!!! Basically what I want is to be
able to automatically select rows 2 and 3 of the data and group them to
row 1... Does anyone have any ideas? Or any other way I can sort the
data better???


--
RJPerri
------------------------------------------------------------------------
RJPerri's Profile:
http://www.excelforum.com/member.php...o&userid=27234
View this thread: http://www.excelforum.com/showthread...hreadid=467439

Dealing with data in rows and columns
 

if you know how to do it on a spreadsheet, then turn on th emacro recorder,
group the rows then turn off the recorder.

To turn on the recorder, from the worksheet menu, select Tools, then Macro,
then Record New Macro. In the Record Macro window, add a n=meaningful name
like GroupRows and click OK
select rows 2 and 3 then from the Data menu select Group and Outline, then
select Group

exame the macro & you'll get an idea of how simple it is to code :)

here's one I prepared earlier, and adjusted to suit

Sub GroupRows()
Rows("2:5").Rows.Group
End Sub




"RJPerri" wrote:


Hello,
I am working on a huge spreadsheet that has data in several columns and
three rows. I realize grouping the rows will allow me to sort the data
better, but the data is downloaded daily so if I go through and group
it, I will have to do it every day. I have been trying to create a
macro but haven't figured out how!!! Basically what I want is to be
able to automatically select rows 2 and 3 of the data and group them to
row 1... Does anyone have any ideas? Or any other way I can sort the
data better???


--
RJPerri
------------------------------------------------------------------------
RJPerri's Profile: http://www.excelforum.com/member.php...o&userid=27234
View this thread: http://www.excelforum.com/showthread...hreadid=467439