Title is kinda un clear but what im trying to do is format a range of cells that always changes. Below is an example. What i have is a data output into excel starting at cell A1 "\\SERVERNAME\Data" and goes to the next row to cell B2 "Modify" and C2 "Read". The number of rows for each range fluctuates based on the number of users in that group. The first rang has 3 rows and the second range has 6.

\\SERVERNAME\Data
Modify Read
drewc2

\\SERVERNAME\\Data\Admin
Modify Read
nardD arthuDK
Mason arew2
McGe1 DurkeJ
WFF57 panelC

Here is a link to how i want it to look. http://spreadsheets.google.com/ccc?k...vUGRyVHc&hl=en

How do i write a marco to do this?