yep it worked...
Ok another question :- )
Now that I have my columns seperated by the employee name in column B
or 2, with a 25 space row insert, like in this example
I have 6 employees that I am doing a productivity report on, so there
is 6, 25 space inserts..
Now on each employees data block I guess you call it, I want to select
those blocks and sort them by the activity type which is
in column C or 3. My manual step was to highlight the effected block
of data and then sort it by column C with no headers, then
move down 25 space, and select manually the next block of data and sort
again my column C with no headers.
The 25 space is needed, because later I insert a template in there that
sums up all the numbers and presents in
into a manager view, but that's the last step, I will be happy to
automate the majority of it :- ) and I learn a lot
along the way.
See it's impossible to select columns A - F and then sort by C, because
of the 25 spaces it dones't sort it right, there is no way to
tell it to ignore the empty spaces, so I have to find the first set of
data, highlight it and sort it and so on..
This is a good one to learn I'll bet...
:- )
Bookmarks