|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
Named Cell issue - dangers of cut and paste
-I also have a cell that lists the Total Income, which i name GSI
-I also have collumn listing Expenses and at the bottom, sums the total
expenses, which iname TOTAL_EXPENSE
-Lastly, below that, i calculate the Net Income by subracting the
expenses from the income, which i call NET_INCOME
-All are in one column.
In both formulas and code elsewhere , i refer to GSI and TOTAL_EXPENSE
cells by name. For instance the NET_INCOME cell is GSI - TOTAL_EXPENSE.
My issue here is, when i now cut and past that column to create a new
column, the forumla in the new column still refers to the named column
in the original column. So in this example, for column two, the net
income cell refers to the column 1 cell, since it is referencing
My question is, how do i handle this and still be able to use named
columns, which are so much more clearer if someone were looking at my
formula or code. Is there a way to create ARRAYs of named cells in
this case? so that the first column would be referred to as
TOTAL_EXPENSE and the second column would be referred to as
i hope i explained myself clear. Please advise if you are able to.