Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking cells from differnet worksheets.......How?
Please bear with me here, I know and understnd very little about Excel. I
have gleaned and created a few work sheets, [time cards that I morph into monthly statements for clinets, and monthly + annual gross statements for myself], pretty simple stuff. I have done this by copying and pasting formulas from templates downlaoded off the net. Sort of self eduacted if you will. So what I am missing, and after is a fromula, to link the monthly total from a clients time sheet/statment to my monthly statement. Is there a "hotlinking" formula, [or a template to copy it from], that I can paste into the appropriate cell on my monthly statement, that links to a monthly total from individual statemenets? If this is overly complex I can continue to do it anually, just figured this program, when drinven properly could manage it......... Thanks in advance! jeff |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking cells from differnet worksheets.......How?
You can link to cells in other worksheets within a workbook and to cells in
sheets in other workbooks. When linking to cells outside of the current Excel file (workbook). It is just a matter of the format of the formula in the cell: links to cells in other sheets in the same workbook have the name of the sheet in front of the cell address, while links into other .xls files have the name of that file, the sheet name and the cell address. Getting this to work is actually very easy and Excel takes a lot of the effort out of it. Linking to other sheets in the same workbook: Start a formula in a cell by typing the = symbol then choose the other sheet and click the cell in that sheet and press the [Enter] key. Done! Linking to other workbooks is just as simple: open both workbooks (you can even link to many others, not just one other). Again start a formula by typing the = symbol and then choose the other workbook, sheet in it and cell within that sheet and press the [Enter] key. Again, Done! For most things the other workbooks don't even have to be open later. When you close them, the link in your workbook is amended to include the complete path to those external workbooks. There are some functions that don't work unless both books are open, but for the needs you have described, that won't affect you. "jefferson" wrote: Please bear with me here, I know and understnd very little about Excel. I have gleaned and created a few work sheets, [time cards that I morph into monthly statements for clinets, and monthly + annual gross statements for myself], pretty simple stuff. I have done this by copying and pasting formulas from templates downlaoded off the net. Sort of self eduacted if you will. So what I am missing, and after is a fromula, to link the monthly total from a clients time sheet/statment to my monthly statement. Is there a "hotlinking" formula, [or a template to copy it from], that I can paste into the appropriate cell on my monthly statement, that links to a monthly total from individual statemenets? If this is overly complex I can continue to do it anually, just figured this program, when drinven properly could manage it......... Thanks in advance! jeff |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking cells from differnet worksheets.......How?
Mr Latham, DUDE!!
Thanks so much! This completely sets me up now! I figured this was possible but had no idea it would be SO simple. You're making me look good! Thanks again! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking cells from differnet worksheets.......How?
No problem. Glad I could help some.
"jefferson" wrote: Mr Latham, DUDE!! Thanks so much! This completely sets me up now! I figured this was possible but had no idea it would be SO simple. You're making me look good! Thanks again! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Cells from different worksheets | Excel Discussion (Misc queries) | |||
Linking Cells on different worksheets | Excel Discussion (Misc queries) | |||
linking cells between worksheets | Excel Discussion (Misc queries) | |||
formulas for linking cells in different worksheets | Excel Worksheet Functions | |||
Counting cells that meet 2 differnet criteria | Excel Worksheet Functions |