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
|
|||
|
|||
limking workbooks
I have 4 workbooks in seperate folders that I need to combine into one
monthly summary. The workbooks are different but each contain a columns named, B/L,Amount,Billed. These are the 3 columns I want merged into one spreadsheet. What would be the best way to do this? Thanks KJH |
#2
|
|||
|
|||
copy the column(s)(or cells) that you want to summarize and paste
specialpaste links to the destination column(s) in your summary worksheet.each time there is a change in your workbooks the summary sheet updates too.Once you have the cells on your sheets you can organise them how you like,ie you can have all the columns visibleor you can summ them all together to show one total . hope this helps paul "KJH" wrote: I have 4 workbooks in seperate folders that I need to combine into one monthly summary. The workbooks are different but each contain a columns named, B/L,Amount,Billed. These are the 3 columns I want merged into one spreadsheet. What would be the best way to do this? Thanks KJH |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Consolidate different sheets to different workbooks | markx | Worksheet Functions | 3 | April 26th, 2005 03:30 PM |
Freeze Pane problem in shared workbooks | JM | General Discussion | 1 | February 1st, 2005 12:04 AM |
Linking Workbooks | Dede McEachern | Worksheet Functions | 0 | January 21st, 2005 08:27 PM |
Save prompt on unchanged workbooks | R Ormerod | General Discussion | 1 | July 21st, 2004 04:37 PM |
Link TO/FROM closed workbooks ! | Marco | Links and Linking | 1 | December 4th, 2003 07:03 PM |