Combo Box dropdown data
It works for me. The formula was entered on Sheet3 in cell A1.
Check the sheet names - no spaces in the ones I used.
The #REF! error value occurs when a cell reference is not valid.
--
Jim Cone
Portland, Oregon USA
"Lynda"
wrote in message
Hi Jim, thank you for responding. When i enter your function i get #REF!
Cheers
Lynda
"Jim Cone" wrote:
=OFFSET(Sheet2!B1,Sheet1!C5-1,0,1,1)
--
Jim Cone
Portland, Oregon USA
"Lynda"
wrote in message
Hi everyone,
I am back with a question I asked earlier and didnt receive a response.
Perhaps I didnt explain myself well enough. I will try again. I have 3
spreadsheets in the one workbook. Sheet one has my Forms-Combo
Box/dropdowns in it. (I prefer to use these as I have a number of others
throughout the sheet with quite large VBE data attached to them and rather
than rewrite everything I chose to use the Forms-Combo Box to keep everything
uniform.) Anyway, sheet 2 has my lists in it for the combo boxes and sheet 3
is my data capture sheet.
Sheet 1 Combo box gets list from sheet 2. Combo box is attached to cell C5
in sheet 1.
Sheet 2 has my list going from B1:B15
Sheet 3 I want the cell A1 (sheet3) to pick up the data from cell C5
(sheet1).
I can get a1(sheet3) to recognise the cell C5(sheet1) but it puts the number
of the cell from sheet2 instead of the text, eg In my combo box/dropdown on
sheet 1 I chose Apple which in my list on sheet 2 would be B4. Instead of
showing Apple in Sheet3 A1 it puts the number 4.
I am wanting to capture all the data on a separate sheet in each survey as
this will be going to a large number of people and it will make collating the
data in a master sheet much easier.
BTW I am using Excel 2003.
I hope this makes better sense and someone will be able to help me.
Cheers
Lynda
|