You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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.