Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a Dynamic .XLS file from two other .XLS files
I want to have an .XLS file that is dynamically updated. For example:
A.XLS is updated daily. B.XLS is updated daily I want to open C.XLS at the end of each week and it would have the same data that exists from column A from A.XLS in column A in the file C.XLS. Similarly, C.XLS would contain the information that was entered in column A of file B.XLS. Can this be done? If yes, can you point me in the right direction? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a Dynamic .XLS file from two other .XLS files
A 'paste link' function may suit your needs. There are two ways to do the
paste link. One is each cell at file a.xls or b.xls and go to file c.xls select Edit Paste Special and click button paste link. If you delete the $ sign (press F2 to delete), you could copy the formula down. The other one is type the formula at a cell of c.xls by yourself. Below is the example: ='[c.xls]Sheet1'!$B$15 c.xls = file name sheet1 = sheet name $b$15 or b15= cell name $ means absolute value If you want to save a backup everyweek, that the other issue. You may post it at the VBA questions. Anna "Matt_PQ" wrote: I want to have an .XLS file that is dynamically updated. For example: A.XLS is updated daily. B.XLS is updated daily I want to open C.XLS at the end of each week and it would have the same data that exists from column A from A.XLS in column A in the file C.XLS. Similarly, C.XLS would contain the information that was entered in column A of file B.XLS. Can this be done? If yes, can you point me in the right direction? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
zero suppression on opening .xls file | Setting up and Configuration of Excel | |||
clicking .XLS file opens Excel 2003 but doesn't find the file | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Creating a PDF file programatically from Excel | Excel Discussion (Misc queries) |