link to mulitple workbooks
 

i have a workbook(main) which is suppose to display data from various
workbook. however, every month the workbooks(various) will be in different
location and there will be additional data. so hw can i link all these data
to my workbook(main).

note: Additional data will cause the column of my required data to change.

link to mulitple workbooks
 

Violet,

Assuming all your monthly workbooks are laid out the same such that all data
is in the same location (just different data); then do this:

1. On your main workbook link all applicable cells to, say, Temp.xls
2. Load your monthly workbook template and Save As Temp.xls. Replace the
existing file.
3. Update links.

Don't ever delete temp.xls when your main workbook is open or all your links
will #ref. Just replace the Temp.xls with new worksheet templates for each
month.

You can do this under VBA control very easily by just recording macros.

Allan P. London, CPA





"violet" wrote in message
...
i have a workbook(main) which is suppose to display data from various
workbook. however, every month the workbooks(various) will be in different
location and there will be additional data. so hw can i link all these
data
to my workbook(main).

note: Additional data will cause the column of my required data to change.

link to mulitple workbooks
 

my data will not be same location.eg if i doing the data for feb den my total
column will b after feb col. but if i doing for oct den my column for totoal
is after oct so in this case my total col will oway be diff.n in my main
workbook i need to link to 3 diff workbook not jus one workbook.

"alondon" wrote:

Violet,

Assuming all your monthly workbooks are laid out the same such that all data
is in the same location (just different data); then do this:

1. On your main workbook link all applicable cells to, say, Temp.xls
2. Load your monthly workbook template and Save As Temp.xls. Replace the
existing file.
3. Update links.

Don't ever delete temp.xls when your main workbook is open or all your links
will #ref. Just replace the Temp.xls with new worksheet templates for each
month.

You can do this under VBA control very easily by just recording macros.

Allan P. London, CPA





"violet" wrote in message
...
i have a workbook(main) which is suppose to display data from various
workbook. however, every month the workbooks(various) will be in different
location and there will be additional data. so hw can i link all these
data
to my workbook(main).

note: Additional data will cause the column of my required data to change.