screamer31
New Member
I have a basic formula like G9-C17 but problem is the one of the reference cells is supposed to get changed everyday. In the row17, new column data will be appended everyday. Hence the formula would go on like G9-D17, G9-E17 and so on, changing daily. Any idea how make this dynamic reference?
P.S. I tried with Indirect but didn't seem to work
P.S. I tried with Indirect but didn't seem to work