how i can put last column contain value in 1 cell in excel?
i have figures from F4 to F83 ( each week the last figures will be in different cell between 4 and 83 - for exp this week it's was 82 rows and next week 50 rows)
and i want put the last figures in F84
please can you help me with that
i found vb formala but i need simple thing i don't have experience with this things
thanx andy i have petty cash table in column D i have debit side and in column E i have credit side and in column F i have the balance so for each transaction i write the debit or credit side then it's will be the balance i need the last row balance to be shown for example in F84 which it will be Total Ending Cash Balance so for example in this week if the wrote last transaction in F70 i want to show this number in F84 i hope u understant what i mean now