Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Join workbooks
Is it possible to join workbooks?
I have 3 employees that are using one sheet for each event that they budget for. Each employee has a different workbook because they have so many events. Within each employees workbook I have used sheet one to total all the following sheets to the appropriate budget line. So know I have 3 workbooks with sheet 1 that need to be added togeather to total the budget for the whole department. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Join workbooks
Hi,
Select 1st worksheet copy and paste it in your summary sheet starting cell A1 Select 2nd copy, go to summary cell A1, paste special,under operation select Add, do the same with sheet 3 If this helps please click yes, thanks "ruby" wrote: Is it possible to join workbooks? I have 3 employees that are using one sheet for each event that they budget for. Each employee has a different workbook because they have so many events. Within each employees workbook I have used sheet one to total all the following sheets to the appropriate budget line. So know I have 3 workbooks with sheet 1 that need to be added togeather to total the budget for the whole department. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Join workbooks
Hi;
I was trying to get away from copying and paste. Looking for something automatic because the employees can continuously update their events. But to understand what you are suggesting is that I take a copy of each of my first sheets in each employees workbook and add them togeather in another workbook? Thanks for your info. "Eduardo" wrote: Hi, Select 1st worksheet copy and paste it in your summary sheet starting cell A1 Select 2nd copy, go to summary cell A1, paste special,under operation select Add, do the same with sheet 3 If this helps please click yes, thanks "ruby" wrote: Is it possible to join workbooks? I have 3 employees that are using one sheet for each event that they budget for. Each employee has a different workbook because they have so many events. Within each employees workbook I have used sheet one to total all the following sheets to the appropriate budget line. So know I have 3 workbooks with sheet 1 that need to be added togeather to total the budget for the whole department. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Join workbooks
Hi Ruby,
I just being able to connect to the comunity, you are correct what I am suggesting is to copy each first page of your 3 workbooks into the summary page, or you can have your summary page linked to the other workbooks for example your first sheet in your workbook is called summary, and the first sheet on the others workbooks are in Workbook1 first sheet is called s1, in Workbook2 s2 and in workbook3 s3 so in the summary sheet you can have a formula summarizing the other sheets ='[Workbook1.xlsm]s1'!A1+'[Workbook2.xlsm]s2'!A1+'[Workbook3.xlsm]s3'!A1 Just change Workbook1 for your workbook name and s1 for the name of the tab where you have the summary of that workbook, the same with the others "ruby" wrote: Hi; I was trying to get away from copying and paste. Looking for something automatic because the employees can continuously update their events. But to understand what you are suggesting is that I take a copy of each of my first sheets in each employees workbook and add them togeather in another workbook? Thanks for your info. "Eduardo" wrote: Hi, Select 1st worksheet copy and paste it in your summary sheet starting cell A1 Select 2nd copy, go to summary cell A1, paste special,under operation select Add, do the same with sheet 3 If this helps please click yes, thanks "ruby" wrote: Is it possible to join workbooks? I have 3 employees that are using one sheet for each event that they budget for. Each employee has a different workbook because they have so many events. Within each employees workbook I have used sheet one to total all the following sheets to the appropriate budget line. So know I have 3 workbooks with sheet 1 that need to be added togeather to total the budget for the whole department. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I join two formulas? | Excel Worksheet Functions | |||
Join tables like inner join in Access | Excel Discussion (Misc queries) | |||
join text | Excel Discussion (Misc queries) | |||
How do I join two workbooks into one pivot table? | Excel Worksheet Functions | |||
Msquery and join | Excel Discussion (Misc queries) |