![]() When you insert columns in an Excel workbook, you receive an error about available memory. You can no longer open as many Excel workbooks in the same instance as you could before you upgraded to Excel 2013/2016. The computer uses more memory when you open multiple Microsoft Excel 2013 workbooks, save Excel workbooks, or make calculations in Excel workbooks. The ISNUMBER is just to check that you haven't corrected this train entry before.After you upgrade to Office 2013/2016/Microsoft 365, you experience one or more of the following symptoms: I detailed how to create a linked clone sheet here but in essence, in a new sheet put this formula in A1 and copy down and across. ![]() Lastly you could "clone" the whole table with formulas in a new sheet, and modify the formula for F to pull in values from D if A is train. Of course you could also just record and modify a macro to do the move for you and assign the macro to a button or a shortcut key. ![]() Now sort via transaction, complete the move, and re-sort via helper column F. If you are worried about returning the spreadsheet to the original order (across multiple months), you can (before sorting) add a helper column say in G, put a 1 in G1 then select all of G and Home > Fill > Series to number G as 1,2,3,4. You can sort, cut and paste, just don't "filter" for "train" as this only hides the rows in between and would still cause problems. The suggestion by to sort by column A is possibly the best move (no pun intended), as it also overcomes the multiple selection issue above. copy D5,D6,D11 would simply paste as F5,F6,F7). You could write a VBA macro to shift the selection to column D (which would be overkill), but that still doesn't really help, as Excel doesn't maintain the positions of multiple selections on a copy and paste (i.e. ![]() As you rightly point out, even if you could "find all" "train" cells it would still just select from column A and not from column D. This is an interesting problem that perhaps Excel hasn't quite yet solved! Selection groups or "masks" cannot be moved or shifted on its own as its always attached to the data/cell you have selected. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |