Links or macros?

[Bonnie]

What is the best way to save data from one identical
worksheet to another on a server, without having to
remember to manually update? Any help would be appreciated.

Thanks,

Bonnie

 

[John Wilson]

Bonnie,

Links to other unopened workbooks in Excel are
exteeeeeeeeeeeeeeemly slow.
Unfortunately, whetever Lotus did to make their links update
like lightning, the folks at MS couldn't duplicate.

My suggestion would be to save the sheet on the server
via a macro.

Post back with more specifics and someone will surely
help you out with this.

John

 

[Bonnie]

Thanks for the reply. I am not sure how to make a macro
with these commands. Would you suggest on thatI could use
to update one worksheets new info to another? Please type
the command for me.

Certainly appreciate this.

Bonnie

 

[John Wilson]

Bonnie,

It may be more than a couple of lines of code.
What's the name of the workbook that you're trying to
update?
What's the drive and path?
Where's your "copy from" range?
Where's your "copy to" range?

I can give you some code if you post back with specifics.
Basically, you have to find and open that workbook on the server,
copy and paste to it and then save and close it.

If it *IS* only a coule of cells, linking them might be better.
If it's more than that, the open, copy, paste,save,close
would surely be faster.

John