That was easy! Thank you for your help.
Since I needed the "destination spreadsheet" to update any changes made to
the "source spreadsheet", I used the Paste Link option which works fine now.
Is there any way to get rid of the zeros in the cells that data hasn't been
entered in? Can I do it by code?

"Bill Manville" wrote:

I have been on vacation so only just had time to read your message.
All you can link using paste link is one cell to another.

So, the way to achieve what you want is to have the combo box on the
source sheet linked to a cell, say Z99, on the source sheet by setting
its LinkedCell property. Z99 will contain the value in the combobox if
it is a Control Toolbox combo or the ListIndex of the item selected
from the list if it is a Forms toolbar combobox.

Then on the destination sheet you have a similar combo box linked to a
cell, say Y88. And you copy Z99 from the source sheet and paste link
it into Y88 on the destination sheet. Then the destination combo
should show the same as the source combo. However, you would not be
able to change the value of the destination sheet's combo without
overwriting the formula in the linked cell - if you don't need the
combo on the destination sheet to allow selection of a different item
then you should disable it.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup