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!