You could add 2 columns to your data. The first one would have the data numbered in order from 1 to whatever you need and the second column would have this formula (with the appropriate changes to suit your data).
I chose column B to be the ID that you are wanting to work on (replace the X in the formula with the ID to be worked on). This will enter a 1 for every row that has the ID that you want to work on and a 0 for the rest.
Enter in the first row of data and fill down.
Now, sort on the column with 1s and 0s from Smallest to largest. This will place all the data for the chosen ID at the bottom of your list. Make your changes to the first record of the chosen ID and fill down the column. Sort on the column that contains the consecutive numbers from Smallest to Largest to re-order the list to the original order.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks