L
lillady718
I have got to keep track of depleting money through my excel worksheet.
As each "person's" name comes in with monetary amount I put it into my
already formulated cell/rows.
However, after a period of time, I'd like to be able to
alphabetize/sort by the "person's name".........but when I try it will
say "CANNOT CHANGE PART OF AN ARRAY"
I can eventually just alphabetize the names....but then of course the
monetary values are NOT sorted/so incorrect for each name.....
Any help would be greatly appreciated..........thanks

As each "person's" name comes in with monetary amount I put it into my
already formulated cell/rows.
However, after a period of time, I'd like to be able to
alphabetize/sort by the "person's name".........but when I try it will
say "CANNOT CHANGE PART OF AN ARRAY"
I can eventually just alphabetize the names....but then of course the
monetary values are NOT sorted/so incorrect for each name.....
Any help would be greatly appreciated..........thanks
