Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

moving cell data to another cell

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

Posted on Sep 16, 2024 6:12 AM

Reply
Question marked as Top-ranking reply

Posted on Sep 16, 2024 1:12 PM

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.

1 reply
Question marked as Top-ranking reply

Sep 16, 2024 1:12 PM in response to Pleasecanyouhelp

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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.