View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
MikeG0930 MikeG0930 is offline
external usenet poster
 
Posts: 4
Default Linking data from ComboBoxes on spreadsheet?

I thought I might have a response by now. Am I in the correct group or should
I be in the programming group for this problem? Sorry for not being patient.

"MikeG0930" wrote:

I have several (source) spreadsheets from several people that are saved in
the same folder. These spreadsheets are formatted the same. I have ComboBoxes
in certain cells to help keep data entered uniform for reporting purposes.

I also have a "Master Workbook" that contains a duplicate of each
(Destination) spreadsheet. To update each sheet I used the Paste Link option.
This works fine except it doesn't paste the contents of the ComboBoxes. Is
there a way to correct this? Thanks.