View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default using data from one sheet to another

Assuming that by "a budget" you mean a checkbook type account where the
present balance is continually calculated down the page then try something
like:

=LOOKUP(2,1/Sheet1!H1:H1000,Sheet1!H1:H1000)

This will return the last number in Column H

Adjust the range to suit, (it can be bigger than you will ever use). You
can use the sheet name that you rename the sheets to but if the sheet name
has a space within it like, January 2007, then enclose the actual name in
single quotes: 'January 2007'

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Debbie" wrote in message
...
Hi

I want to keep a running balance in a budget , month on month and I
understand that its not best to use an accumalator. I was advised to have
twelve separate tabs which is fine and I have copied the sheet to the next
tab but I don't know how to link cells from one sheet to another. Can
anyone
help please, and yes I am an absolute beginner.

Thanks
--
Deb