F
Fred
Here's a riddle for all the Excel gurus...
How do you automatically hide a row based on the contents
of a single cell in that row?
I have several pairs of records that I need to merge into
a single row. Presently, I am comparing the record ID
(Column A) to the next row's record ID. If they match
then data is extracted from row 2 and placed in row 1.
However I need to produce a report showing only the "odd"
row numbers.
Right now I highlight each row then hide it. But my list
continues to grow daily, and I am looking to automate this
process. Any ideas?
How do you automatically hide a row based on the contents
of a single cell in that row?
I have several pairs of records that I need to merge into
a single row. Presently, I am comparing the record ID
(Column A) to the next row's record ID. If they match
then data is extracted from row 2 and placed in row 1.
However I need to produce a report showing only the "odd"
row numbers.
Right now I highlight each row then hide it. But my list
continues to grow daily, and I am looking to automate this
process. Any ideas?