Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking two worksheets in the same workbook
I have a main worksheet and want to create a 2nd daily worksheet. I don't
need to see all the information from the main worksheet but want the main worksheet to reflect changes made in the daily worksheet. There are several additions and deletions in the daily worksheet and would like the main worksheet to update as well. Is there a way to copy the entire original worksheet, remove the columns and rows I don't want in the daily view and have it linked without have to individually link the cells? Time is short on this project and I greatly appreciate any assistance that will quickly solve my situation. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking two worksheets in the same workbook
I would think the best way is to make a copy of your main worksheet and call
it daily. Then, if, say, cell A19 of the main is going to come from daily, have it =Daily!A19. You can copy and paste anywhere across Main that you want it to link. If you subsequently delete or add any rows before A19, the formula will automatically update as needed. "nannybears" wrote: I have a main worksheet and want to create a 2nd daily worksheet. I don't need to see all the information from the main worksheet but want the main worksheet to reflect changes made in the daily worksheet. There are several additions and deletions in the daily worksheet and would like the main worksheet to update as well. Is there a way to copy the entire original worksheet, remove the columns and rows I don't want in the daily view and have it linked without have to individually link the cells? Time is short on this project and I greatly appreciate any assistance that will quickly solve my situation. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking two worksheets in the same workbook
Thank you Sean - Actually, that is what I've done and I am looking for a way
to format the entire worksheet at once to avoid having to format each cell seperately. Any suggestions for doing that? "Sean Timmons" wrote: I would think the best way is to make a copy of your main worksheet and call it daily. Then, if, say, cell A19 of the main is going to come from daily, have it =Daily!A19. You can copy and paste anywhere across Main that you want it to link. If you subsequently delete or add any rows before A19, the formula will automatically update as needed. "nannybears" wrote: I have a main worksheet and want to create a 2nd daily worksheet. I don't need to see all the information from the main worksheet but want the main worksheet to reflect changes made in the daily worksheet. There are several additions and deletions in the daily worksheet and would like the main worksheet to update as well. Is there a way to copy the entire original worksheet, remove the columns and rows I don't want in the daily view and have it linked without have to individually link the cells? Time is short on this project and I greatly appreciate any assistance that will quickly solve my situation. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking two worksheets in the same workbook
Hm, not sure where my repsonse to this went....
So, I presumt you only want to have certain cells linked... is there a common theme? (All constatnts, all formulas, etc...) If so, you can set your =Daily formula for one, click F5, then select Special, and pick the cell type to highlight them and paste. "nannybears" wrote: Thank you Sean - Actually, that is what I've done and I am looking for a way to format the entire worksheet at once to avoid having to format each cell seperately. Any suggestions for doing that? "Sean Timmons" wrote: I would think the best way is to make a copy of your main worksheet and call it daily. Then, if, say, cell A19 of the main is going to come from daily, have it =Daily!A19. You can copy and paste anywhere across Main that you want it to link. If you subsequently delete or add any rows before A19, the formula will automatically update as needed. "nannybears" wrote: I have a main worksheet and want to create a 2nd daily worksheet. I don't need to see all the information from the main worksheet but want the main worksheet to reflect changes made in the daily worksheet. There are several additions and deletions in the daily worksheet and would like the main worksheet to update as well. Is there a way to copy the entire original worksheet, remove the columns and rows I don't want in the daily view and have it linked without have to individually link the cells? Time is short on this project and I greatly appreciate any assistance that will quickly solve my situation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking of worksheets in a workbook | Excel Discussion (Misc queries) | |||
Linking to worksheets from another workbook | Excel Discussion (Misc queries) | |||
linking several worksheets to one workbook | Excel Discussion (Misc queries) | |||
linking worksheets in same workbook | Excel Discussion (Misc queries) | |||
Linking Data between worksheets in a workbook | Excel Worksheet Functions |