LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #14   Report Post  
DOR
 
Posts: n/a
Default FYI: Change in Requirment Parameters for this post

OTOH, if all you want to do is identify the new entries, why not take a
really simple approach.

Use a column to contain an indicator of the fact that you have reviewed
an entry, say the date of your review or your initials or whatever.
Then hide that column when you distribute the spreadsheet. When you
receive it back, display that column. All the new entries will be
blank in that column. Autofilter that column on blanks. Now you will
see all the new entries, and only the new entries. Then, after you
review them, enter your "reviewed" indicator in the first entry and
drag it down through all the visible rows; only the visible rows will
be changed. Sort the table, hide the column again and redistribute ...

Use protection as necessary to prevent others changing that column.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I automatically update column index number in VLookup whe. Gene Excel Worksheet Functions 2 July 10th 12 11:23 AM
how to highlight current row & column automatically by a color asif4u Excel Discussion (Misc queries) 8 June 12th 07 04:42 PM
Column number of last column containing a number Karl Excel Worksheet Functions 8 June 4th 05 12:15 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
how to highlight current row & column automatically by a color iffi Excel Discussion (Misc queries) 1 February 6th 05 06:30 PM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"