On Apr 16, 2010, at 17:06 , JOE Conner wrote: > On 4/16/2010 5:32 AM, James Wilde wrote: >> Hi: >> >> > Short answer: YES. > > Now as to how (one way, out of many possible): > 1. Select all (CTRL A), copy (CTRL C). > 2. Navigate to a new sheet (or a new spreadsheet if you will) > 3. Paste the clipboard (CTRL V). This will preserve your original data in > case you make an error later. > 4. Select all (CTRL A) > 5. SORT the data on the column containing the PAID information. DATA -> > SORT. > 6. Now all the rows that contain no PAID data are bunched together. You can > select just these rows and print your selection.
So easy! Now why didn't I think of that? Thanks Joe. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
