Excel 2003

[Guest]

I have a workbook with 5 worksheets on my local drive.
I want to send shortcut to One of the Worksheets to my desktop, not the
whole workbook. Also, when i enter information into the worksheet, opened by
the shortcut, i would like it to update the original sheet in the original
workbook.
Whew....i hope you could understand what i would like to be able to do.

Thanks Anyone!

 

[Bob I]

The workbook is a file, Shortcuts start the application and open the
file. Unless you make a Workbook with only the one Worksheet, you will
have ALL 5 sheets available. I hope you understand how Excel works.

 

[Guest]

Yeah ...i was just wondering if i could do more with updating or linking or
something. Thanx

 

[Gord Dibben]

You can link from one workbook/worksheet to another and have the links
auto-update.

Have both workbooks opened and copy/paste special>links from one to the other.

See help on "linking" for more.

For VBA code to copy info from one workbook to the other without opening the
second workbook see Ron de Bruin's Copy/Paste/Merge section.

http://www.rondebruin.nl/tips.htm


Gord Dibben MS Excel MVP

 

[Guest]

Thank You
I did begin to do it the long way....Using Cells Formulas but will check
your way.

 

[Bob I]

Sorry, I fail to understand what the issue is with opening the workbook.
What purpose would it serve to only "open one sheet" of the file? You
may want to share what the objective is, rather than try to "solve" a
problem due to the method you are using to reach the objective.