I have a table with numbers in each cell.. what I want to know is can I select any cell and make that cell contents move to another table and cell. this is for a multiplication sum but the user has to pick from a table the sum of the multiplication. the sum would look like this table 1 numbers from 1 to 50 then
wait input from table one * 1.07 = ????
its not then sum but how to move the user selected data into the sum.
thanks 🙏
iMac 27″, macOS 14.6
If the two tables are on the same sheet, the user can select a cell then click and hold until the cell lifts from the table then option-drag it to the other table. Option drag will make a copy of it. If they forget to use option, it will move it. The "* 1.07 =" needs to be in a different cell as text or in three cells, one for the "*" as text, one for 1.07, and one forthe "=" as text.
Or you can use one of the other input methods. Here is a slider:
You can remove the border between columns B and C so it doesn't jave tht line in the middle of the equation. I didn't do it for the screenshot because I wanted to show that it is two different columns.
If the two tables are on the same sheet, the user can select a cell then click and hold until the cell lifts from the table then option-drag it to the other table. Option drag will make a copy of it. If they forget to use option, it will move it. The "* 1.07 =" needs to be in a different cell as text or in three cells, one for the "*" as text, one for 1.07, and one forthe "=" as text.
Or you can use one of the other input methods. Here is a slider:
You can remove the border between columns B and C so it doesn't jave tht line in the middle of the equation. I didn't do it for the screenshot because I wanted to show that it is two different columns.
moving cell data to another cell
