If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I reference data from one worksheet to another using combob
How do I reference data from one worksheet to another worksheet cell with a
combo box and then have the data relating to this appear in the nesxt cell in a combo box. ie.- Workssheet 2, cell D6 need to reference worksheet 1 cells C2 & C3 (Documents) then have cells A2 to A12 ( Document Issues) in worksheet 1 appear in cell E6 in Worksheet 2. Also I will have multiple cell references from worksheet 1 to worksheet 2 following this simular format into cell D & E6. Then it needs to put this information into individual rows on worksheet 2. ie- choose data for D6 then E6 and goto the next row for adding additional Thanks in advance for your help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to reference cell in other worksheet | JimDandy | Worksheet Functions | 4 | December 17th, 2005 06:41 PM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
Saving data in a worksheet within a workbook | Homeuser | General Discussion | 2 | August 21st, 2005 10:49 PM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |