Is there a way to "cut" certain cells and paste them to another cells or sheet without losing formulas with references to other cells (such as MS Excel does with command+X).
Numbers does not support Excel macros at all?
(iWork) Numbers: Cut and Paste, macros
big suriworkms officenumbers
Related Solutions
I can see why this might be frustrating. Tables in iWork by default are set to automatically detect the type of text that is entered in each cell. If iWork sees a number (of any type) it converts it a Western character. Luckily it is possible to change this.
Open the inspector and go to the table settings section. Under the table settings section you are presented with two other sections ("Table" and "Format"). Select "Format" and you will see that you can set the "Cell Format" of a table. Select the table in your document and and click on the "Cell Format" drop-down menu. As you will see, the current option is set to "Automatic." Change this to "Text" and you will no longer have the problem of iWork changing your input to Western characters!
Note: You may be forced to manually create and enter the values in the table using the character viewer or copy and paste individual characters from Wikipedia in each cell AFTER initializing the table to have the "Text" cell format. Copying and pasting the entire table from Wikipedia seems to override any initial formatting (in the form of cell format) in iWork.
I had the same sort of problem and with some help from people within the Apple Support community I came up with this solution. Hopefully it will work for you.
This is my list of players in sheet 1. In your case, the Players name would be the item codes.
Here is sheet where I want to information copied to.
The P# corresponds to the number next to the Players name in Sheet 1. If I enter a 1 and a 2 the names are filled in to the column to the left of the box.
This shows the formula required to transfer the players name from sheet 1 to sheet 2.
To take it a step further, when I fill in the Players winnings in Sheet 1 it also fills it in all the "Earnings" cells for that player in Sheet 2 using the formula shown below.
My list of players goes to 300 but the last 20 or so are empty. That way I can still add more names or in your case, item codes, to it.
This may be more complicated than you require but hopefully it helps you.
Best Answer
One way to cut formula and paste in new location with references 'in tact and relative' is following:
Alternatively one can make references in formula absolute with ⌘ + K and then cut-paste whole cell.