A
Ademola Pratt
Guest
I have some work I had developed using the MS Excel XP and transferreds to MS
Excel 2003. Let us assume there are five or more boxes named A, B, C, D,
E..that is a FOLDER. Let us say that Folder A contains 118 Files, Folder B
Same, etc. There is a standard Template developed for 118 Tables, for
example in Folder A and other folders. The expectation is that Folder A
Table 1 is unique for all the Table 1 in all the five Folders or more. For
eaxmple, A folder named Cosolidated Table 1 will link all the FILES of the
Tables from all the Folders A, B, C, D, E.. and produced it as the summation
of all the fields in Table 1 of all the Folders to have a consolicated Tabler
1 through the use of linking each field from each of the Table 1 in each of
the Folders.
Now I would like to back up only my target files from each of the Folders
and Restored same in the Consolidated Folder, so that I can backup the
specific files as stated from source and go to Restore the result into
another system. So that all the LINKING as provided in the Consolidated
Folder will pick the data against the field of interest and summarises all
the data, say in D8 together automatically. i.e the Cell Reference D8 from
all the Table 1 from all the Folders from this reeference and others will sum
up all the data as entered into D8 and add them together, thereby enjoying
the use of backup and restore. Presently, I want to use the COPY and PASTE
as exisiting in WindowsXP OPS, but I am trying also in using Vista OPS Backup
and Restore for a specific files not My Computer but a/some specific files.
Are we clear or go further.
ademola.pratt@gmail.com
Excel 2003. Let us assume there are five or more boxes named A, B, C, D,
E..that is a FOLDER. Let us say that Folder A contains 118 Files, Folder B
Same, etc. There is a standard Template developed for 118 Tables, for
example in Folder A and other folders. The expectation is that Folder A
Table 1 is unique for all the Table 1 in all the five Folders or more. For
eaxmple, A folder named Cosolidated Table 1 will link all the FILES of the
Tables from all the Folders A, B, C, D, E.. and produced it as the summation
of all the fields in Table 1 of all the Folders to have a consolicated Tabler
1 through the use of linking each field from each of the Table 1 in each of
the Folders.
Now I would like to back up only my target files from each of the Folders
and Restored same in the Consolidated Folder, so that I can backup the
specific files as stated from source and go to Restore the result into
another system. So that all the LINKING as provided in the Consolidated
Folder will pick the data against the field of interest and summarises all
the data, say in D8 together automatically. i.e the Cell Reference D8 from
all the Table 1 from all the Folders from this reeference and others will sum
up all the data as entered into D8 and add them together, thereby enjoying
the use of backup and restore. Presently, I want to use the COPY and PASTE
as exisiting in WindowsXP OPS, but I am trying also in using Vista OPS Backup
and Restore for a specific files not My Computer but a/some specific files.
Are we clear or go further.
ademola.pratt@gmail.com