Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 24th 09, 08:57 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 4
Default Linking data from ComboBoxes on spreadsheet?

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking data from ComboBoxes on spreadsheet? MikeG0930 Links and Linking in Excel 4 September 29th 09 08:24 AM
Linking 2 spreadsheet using data from the last row of spreadsheet Mike Excel Discussion (Misc queries) 13 February 11th 09 10:48 AM
Linking 2 spreadsheet using data from 1st spreadsheet vennesse Excel Discussion (Misc queries) 1 February 11th 09 10:43 AM
Linking two spreadsheet, pulling data from one cell to another, data is being truncated Ben Excel Worksheet Functions 0 September 13th 07 11:41 PM
Is using data validation and comboboxes heretical? Jono Excel Discussion (Misc queries) 0 March 13th 06 03:09 PM


All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017