|Subject:||RE: how 2 spreadsheets in diff locations with auto update|
|Date:||Fri, 12 May 2006|
you didn't say if there was a change that the other file might be open by
another user. if so you will have problems what ever you do.
I have a situation where i have to save a file it 2 different
I wrote a macro that saves the file in the three different loactions. you
can do it on record and put the macro in a this workbook module in the before
save event or before close event. in the before save event, it will
automaticly save to the second loaction when ever you save the file to your c
Otherwise you would have to use drive formulas in the second file and that
is a hassel i assure you becasue each cell needs it own formula. I only
recomend drive formulas when you are creating a summary and not the entire
here is an example of a dirve formula that counts.
one that just draws data.
one that sums
"confused in uk" wrote:
> Does anyone know how to save the same Excel spreadsheets in different
> locations but you only need to update one and the other will auto update?
how 2 spreadsheets in diff locations with auto update posted by confused in uk on Fri, 12 May 2006