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!

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.

njcoffice58 wrote:

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!

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

"Bob I" wrote:

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.

njcoffice58 wrote:

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!

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

Have both workbooks opened and copy/paste speciallinks 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

On Thu, 24 May 2007 14:53:03 -0700, njcoffice58
wrote:

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

"Bob I" wrote:

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.

njcoffice58 wrote:

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!

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

"Gord Dibben" wrote:

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

Have both workbooks opened and copy/paste speciallinks 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

On Thu, 24 May 2007 14:53:03 -0700, njcoffice58
wrote:

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

"Bob I" wrote:

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.

njcoffice58 wrote:

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!

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.

njcoffice58 wrote:

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

"Bob I" wrote:


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.

njcoffice58 wrote:


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!