I have a challenge here...this is what my sheet looks like
after performing a database query
A B C D E F G
1X Y Z

then, there is a formula in "d1" that looks at the value
in "c1" and if it meets certain criteria (eg. x) enters a
value into "d1" such as "greater than"...

A B C D E F G
1X Y Z Greater Than

then, based on the existence of "Greater Than" in "d1", an
input box opens upon which the users entries fill E, F &
G...

All is well until new data is found at which point the new
data is placed into A1..C1, the old data moves down one
row BUT the entries in E1..G1 stay there and do not move
down to the next row.

Any ideas on how to keep the data from the qeury and the
corresponding user entries together in the same row?

Thanks for any input!!!