Using a new column to flag changes in other fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an 18 page price list that we use as a database to
print ONE price sticker to use on our product display.

When we change prices we only change about 50 out of 800
products. I would like to make the changes and then sort
the data so that the changed products are sorted all
together. this will enable me to print price sticker
labels for just the changed products without wasting label
stock. One printed I will re-sort the price list back
into the original order.

Is there any way that I can have a flag added to a record,
in a new column? I wil lthen use that flag to sort the
changes all together.

Thanks muchly!
 
One of many possibilities is to use two extra columns: one to keep a
historical record of prices, and one to use for a flag. For example, if you
currently have

A B
1 Item Price
2 Baubles 1.59

Change it to

A B C D
1 Item Price Record Flag
2 Baubles 1.59 1.59 "Equation"

Where the Equation is actually

=B2=C2

which will return TRUE or FALSE.

Then, when you change the prices, make the changes in column B only. Sort
based on column D, select only those rows where the value in column D is
FALSE, do your printing, then copy the items from column B over to column C.
That will change all your values that were FALSE to TRUE, and you'll be
ready for the next go round.

HTH,
Bernie
MS Excel MVP
 
Back
Top