Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
How do I collect data from an interactive web worksheet and impor. | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |