If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I link two worksheets?
I want to sent up a main excel worksheet at our corporate office, and then
have a worksheet set up for all our other offices to use with some of the fields on the main worksheet(each office will have different numbers to put in the fields), and then have each office info drop into the main worksheet so we at corporate do not have to rekey or cut and paste that info. How do I do this? What is this called? I thought it was linking but now Im not sure. Please help. |
#2
|
|||
|
|||
How can I link two worksheets?
Let's assume your Corporate sheet is called "Corp" and the next sheet is
"CC1" (Cost Center 1). You can do an exact cell reference... Say you are looking for revenue for CC1. On the Corp tab, in the cell where you want CC1's revenue to appear type "=", then click on the CC1 tab and click on its revenue number, then press enter. The formula will look like this =CC1!B5 B5 being the cell on the CC1 tab where the revenue number is. There are more advanced ways of doing this too, like using VLOOKUP and SUMIF. "Deanne" wrote: I want to sent up a main excel worksheet at our corporate office, and then have a worksheet set up for all our other offices to use with some of the fields on the main worksheet(each office will have different numbers to put in the fields), and then have each office info drop into the main worksheet so we at corporate do not have to rekey or cut and paste that info. How do I do this? What is this called? I thought it was linking but now Im not sure. Please help. |
#3
|
|||
|
|||
How can I link two worksheets?
Okay I have another question. Here is what I have: I am at corp./ and would
have the corp sheet, but I have 54 offices in US. How do I get them a worksheet (i will design to match ours), and how do they send it to us every month so that the info goes into corp? info you gave I understand-thank you. Thanks for helping me. "JR" wrote: Let's assume your Corporate sheet is called "Corp" and the next sheet is "CC1" (Cost Center 1). You can do an exact cell reference... Say you are looking for revenue for CC1. On the Corp tab, in the cell where you want CC1's revenue to appear type "=", then click on the CC1 tab and click on its revenue number, then press enter. The formula will look like this =CC1!B5 B5 being the cell on the CC1 tab where the revenue number is. There are more advanced ways of doing this too, like using VLOOKUP and SUMIF. "Deanne" wrote: I want to sent up a main excel worksheet at our corporate office, and then have a worksheet set up for all our other offices to use with some of the fields on the main worksheet(each office will have different numbers to put in the fields), and then have each office info drop into the main worksheet so we at corporate do not have to rekey or cut and paste that info. How do I do this? What is this called? I thought it was linking but now Im not sure. Please help. |
#4
|
|||
|
|||
How can I link two worksheets?
Since you are at corporate level, you can give all 54 branch offices a
standard template, ie of a standard format. When you collected all of them at interval, you can combine data from each of the files into your master file, using macro. "Deanne" wrote in message ... Okay I have another question. Here is what I have: I am at corp./ and would have the corp sheet, but I have 54 offices in US. How do I get them a worksheet (i will design to match ours), and how do they send it to us every month so that the info goes into corp? info you gave I understand-thank you. Thanks for helping me. "JR" wrote: Let's assume your Corporate sheet is called "Corp" and the next sheet is "CC1" (Cost Center 1). You can do an exact cell reference... Say you are looking for revenue for CC1. On the Corp tab, in the cell where you want CC1's revenue to appear type "=", then click on the CC1 tab and click on its revenue number, then press enter. The formula will look like this =CC1!B5 B5 being the cell on the CC1 tab where the revenue number is. There are more advanced ways of doing this too, like using VLOOKUP and SUMIF. "Deanne" wrote: I want to sent up a main excel worksheet at our corporate office, and then have a worksheet set up for all our other offices to use with some of the fields on the main worksheet(each office will have different numbers to put in the fields), and then have each office info drop into the main worksheet so we at corporate do not have to rekey or cut and paste that info. How do I do this? What is this called? I thought it was linking but now Im not sure. Please help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Link Rows Between Worksheets | veng | General Discussion | 3 | December 7th, 2005 04:57 PM |
Can't find Master Link and Child Link Attributes | Laurel | New Users | 20 | February 24th, 2005 04:29 PM |
updating graphics inserted with Insert and Link option | Ann Pillman | General Discussion | 1 | October 11th, 2004 04:04 PM |
Link to Excel problem | Jeff | General Discussion | 0 | July 21st, 2004 02:00 AM |
Too many hyperlinks? | [email protected] | Powerpoint | 7 | May 25th, 2004 02:19 AM |