Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
using data from one sheet to another
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
using data from one sheet to another
Unless that last number is 0.
Sandy Mann wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
using data from one sheet to another
The reason people use the first is that's as large a number as excel can store.
And the reason people use the second is that it's pretty large--larger than my checkbook (except right after payday!). Sandy Mann wrote: Thank you form pointing that out Dave. I did not know that and with my bank balance I should have noticed it before. A quick Google gave me: =LOOKUP(9.99999999E+307,Sheet1!H:H) or as seems to becoming more popular: =LOOKUP(99^99,Sheet1!H:H) -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Dave Peterson" wrote in message ... Unless that last number is 0. Sandy Mann wrote: 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 -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
using data from one sheet to another
"Dave Peterson" wrote in message
... And the reason people use the second is that it's pretty large--larger than my checkbook (except right after payday!). Wow! You just went up in my estimation Dave! <g -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Dave Peterson" wrote in message ... The reason people use the first is that's as large a number as excel can store. And the reason people use the second is that it's pretty large--larger than my checkbook (except right after payday!). Sandy Mann wrote: Thank you form pointing that out Dave. I did not know that and with my bank balance I should have noticed it before. A quick Google gave me: =LOOKUP(9.99999999E+307,Sheet1!H:H) or as seems to becoming more popular: =LOOKUP(99^99,Sheet1!H:H) -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Dave Peterson" wrote in message ... Unless that last number is 0. Sandy Mann wrote: 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 -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
using data from one sheet to another
Well, that was an estimate of my checkbook, too. I may have been off by a
factor of 1,000,000,000%. Sandy Mann wrote: "Dave Peterson" wrote in message ... And the reason people use the second is that it's pretty large--larger than my checkbook (except right after payday!). Wow! You just went up in my estimation Dave! <g -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Dave Peterson" wrote in message ... The reason people use the first is that's as large a number as excel can store. And the reason people use the second is that it's pretty large--larger than my checkbook (except right after payday!). Sandy Mann wrote: Thank you form pointing that out Dave. I did not know that and with my bank balance I should have noticed it before. A quick Google gave me: =LOOKUP(9.99999999E+307,Sheet1!H:H) or as seems to becoming more popular: =LOOKUP(99^99,Sheet1!H:H) -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Dave Peterson" wrote in message ... Unless that last number is 0. Sandy Mann wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
using data from one sheet to another
Intelligent and funny, what a gift!
Regards, Alan "Dave Peterson" wrote in message ... Well, that was an estimate of my checkbook, too. I may have been off by a factor of 1,000,000,000%. Sandy Mann wrote: "Dave Peterson" wrote in message ... And the reason people use the second is that it's pretty large--larger than my checkbook (except right after payday!). Wow! You just went up in my estimation Dave! <g -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Dave Peterson" wrote in message ... The reason people use the first is that's as large a number as excel can store. And the reason people use the second is that it's pretty large--larger than my checkbook (except right after payday!). Sandy Mann wrote: Thank you form pointing that out Dave. I did not know that and with my bank balance I should have noticed it before. A quick Google gave me: =LOOKUP(9.99999999E+307,Sheet1!H:H) or as seems to becoming more popular: =LOOKUP(99^99,Sheet1!H:H) -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Dave Peterson" wrote in message ... Unless that last number is 0. Sandy Mann wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |