Worksheet copy without user interaction

[Sunicro]

I have a Master Workbook that I have to update manually. Then I have many
users that have their own copy of the same file but with different names to
show users of the file. I need a function that will update their file (just
the one sheet, call it Final Data) from the master file.

This way they get the updated information without having to manually copy it
from the master. And I need it to do it automatically when they open their
copy of the file. Would prefer the user not have to run anything manually. It
can be behind the scenes, they unaware, or maybe a button that says update
now.

I tried doing the linking, but couldn't figure out how to link the entire
tab. The number of rows changes constantly, but the number of columns is
fixed. I have a row(#3) that has the drop down sorting buttons attached.

The reason for all this is that each user has there own limiting, sorting
preferences, but all the source data is the same.

Any assistance is greatly appreciated. I have been looking over all the
previous posts and none seem to do exactly what I need.

 

[Alex Turner]

I have a Master Workbook that I have to update manually. Then I have
many users that have their own copy of the same file but with different
names to show users of the file. I need a function that will update
their file (just the one sheet, call it Final Data) from the master
file.

This way they get the updated information without having to manually
copy it from the master. And I need it to do it automatically when they
open their copy of the file. Would prefer the user not have to run
anything manually. It can be behind the scenes, they unaware, or maybe a
button that says update now.

I tried doing the linking, but couldn't figure out how to link the
entire tab. The number of rows changes constantly, but the number of
columns is fixed. I have a row(#3) that has the drop down sorting
buttons attached.

The reason for all this is that each user has there own limiting,
sorting preferences, but all the source data is the same.

Any assistance is greatly appreciated. I have been looking over all the
previous posts and none seem to do exactly what I need.

My approach would be to write a script to update the workbooks. The
users run the script rather than directly opening Excel. The script then
opens Excel for them and does all the updates.

There is stuff on this sort of thing on my blog and in my book.

AJ

 

[Sunicro]

On Thu, 20 Dec 2007 11:46:00 -0800, Sunicro wrote:

My approach would be to write a script to update the workbooks. The
users run the script rather than directly opening Excel. The script then
opens Excel for them and does all the updates.

There is stuff on this sort of thing on my blog and in my book.

AJ

Though I do appreciate the reply, pointing me to a site to buy a book
doesn't help me solve my issue by the end of the year.

I have a macro that will copy the data from one tab to a tab in another
workbook. What I am trying to do is have it happen without the user having to
activate anything unless it is a button that says update now. Also i am
having problems with it recognizing the last row of actual data. It goes
beyond and puts a zero in all the empty cells.

Any help or guidance is greatly appreciated.