Maybe you can just apply Data|Filter|autofilter to that column.

Then apply a custom filter of not equal to #n/a and copy the visible cells/rows
to where you want them.

Betty Csehi wrote:

I have a large database where I need a macro (or something) to find specific
information, cut it from its current row, and then paste it somewhere the
database. For example, the original database now looks like this:
A
1 #N/A
2 #N/A
3 GBA4326
4 #N/A
5 SLGG24

I want to find everything that is NOT #N/A, cut it and paste it below the
current database. So, with my example above the info below the original
database will now look like this:
A
1200 GBA4326
1201 SLGG24

and the original database will now look like this:
A
1 #N/A
2 #N/A
3 #N/A

I hope you get the gist of what I need. If anyone can help, I'd certainly
appreciate it as my database is over 1,000 rows. Thanks!

--

Dave Peterson