LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Pedro Fonseca
 
Posts: n/a
Default Getting the last value of an incrementing sheet

Greetings.

I have some separate worksheets setup for my personal finances (one
for each bank account). I have the typical date, description, type of
operation (debit, credit) and the amount of the operation. On the last
column of the row I then update the amount of money of the previous
row (it's in this column that I have the formula that will know what
type of operation it is and subtracts or adds to the amount of money
that is the previous row). Pretty basic stuff I guess... It's kind of
a diary, where I will keep adding rows to the bottom (more recent
dates at the bottom).

What I'd like was to have a static page with the most current values
of each worksheet - just to have an easy way to keep all my account
balances at a glance. I'd have to find a way, from this static page,
to go fetch the last value at the bottom of every worksheet. But alas,
this would have to be dynamic: everyday I keep adding rows to every
worksheet...

Can anyone point me in any direction in order to do this? If any
programming needs to be done, there's no problem (I'm a C++, Java and
PHP programmer that doesn't know anything about MS Office), but I'd
really like it to be generic (i.e. work in *every* MS Office 2003, and
not just my computer because it needs a control that I have to install
just to make it work)...

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Impoting data from Sheet 1 to Sheet 2 a-leano Excel Discussion (Misc queries) 1 April 20th 05 01:05 AM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. RonMc5 Excel Discussion (Misc queries) 9 February 3rd 05 12:51 AM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"