Apr 30, 2006 08:51
When I try to sort my spreadsheet (which is Quattro Pro, but it works as far as I can tell exactly like Excel), it will only sort a column at a time, which means of course that every gets screwed up. because I'm trying to treat the columns as fields, and the rows as single entries. How do I lock the rows straight across so that, for example, if I sort the items in column A alphabetically, the material in the other columns stays aligned with the proper entry in column A? I would have thought this behavior would be the default.
My submission tracker thingy doesn't work properly if I can't group all the entries for one title together -- as it gets longer it becomes harder to know whether I've seen all the places a story's been.
Of course this would be much simpler if the damned stories sold.
submission tracker