How do I reference data from one worksheet to another using combob

C

caricc

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can the IF function be used with values from multiple worksheets? 4
Macro to Run Functions and VBA code??? 0
How do I reference one OR another worksheet? 2
Merge data from two separate tables 3
move data from one spreadsheet to another and repeat 1
Indirect references with VLOOKUP 5
Structured references between worksheets 0
Displaying Returns from another worksheet that change? 3

Top