changing value of cells

how do i replace the text in multiple cells to read the same as the text in
other cells of the same value?

if the text in cell d reads XXX and the text in cell f reads yyy, how do I
change the text in only those f cells that read yyy to read the same as the
text in only those d cells that read xxx? there are thousands of these f
cells that need to be updated.

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

Your use of the word "cells" makes me suspect that you're talking about
Excel, as there isn't really a concept like "cells" in Access. If that's the
case, you'd be best off reposting your question to a newsgroup related to
Excel.

If you are talking about Access, then recognize that Access deals with
tables that contain fields. It's not completely clear to me what it is
you're trying to do, but to update values, you'd use an Update query. To
only update certain values, you'd put an appropriate Where clause in that
Update query.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"kellyy" wrote in message
...
how do i replace the text in multiple cells to read the same as the text
in
other cells of the same value?

if the text in cell d reads XXX and the text in cell f reads yyy, how do I
change the text in only those f cells that read yyy to read the same as
the
text in only those d cells that read xxx? there are thousands of these f
cells that need to be updated.