Copy data from one table to another with a formula.
I am organising ammunition from a list of my ammunition into different storehouses. They must comply with many regulations and not all ammo can be stored together. I want to be able to type in a storehouse number in an end column. When this number is typed in i want the data from that row of the table to be copied into another table that represents the storehouse contents. This way i can quickly move ammo across between he storehouses without having to copy and paste each time. I experimented with an =if function, but i couldn't find a way to move a complete row into a different table.