IPad – Why doesn’t Numbers remember the last cell position

I don't know if it's possible to do this with functions, but it might be. There is a function called VLOOKUP that seems like it would do what you want, but I couldn't get it to quite work in my experimenting with it—a function that exists within one cell has a hard time returning multiple values for multiple cells.

What I think does work, though perhaps not as convenient as you might want, is the filter view. On the right side of the window, if you select the view that says "Sort & Filter" and the Filter tab, you can "Add a Filter" that will match a value in a specified column. Toggling that filter using the checkbox in the corner of that Filter's box will hide all of the rows that don't match that criteria, then it's a simple matter of highlighting all of the cells, copying and pasting to another sheet.

Unfortunately, this won't continue to add rows as you add rows in the first sheet, so if that functionality is something you need, this won't answer your question. If you only need a one-time copy, though, I think that this is the easiest option (and the only one that I know of, but I'm not extremely familiar with Numbers).

use this AppleScript ▼

--finds next next blank (or non-blank) cell in column
--select starting cell, and run
property searchFor : missing value
tell application "Numbers"
  set t to front document's active sheet's first table whose selection range's class is range
  tell t's selection range
  set currentRow to its first cell's row's address
  set searchCol to its first cell's column's address
  end tell
  tell t's column searchCol
  repeat with i from currentRow + 1 to count cells
  if cell i's value is searchFor then --add not if want to find non-blank
  set t's selection range to cell i
  return
  end if
  end repeat
  end tell
end tell

from →
how do I move/find the next non empty cel… - Apple Community_2019-09-25