Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calling Roger Govier or anyone else that can help with numbers to
Sorry for not getting back earlier Roger had a few family issues to take care
of. I didn't want to change the format because I have created a number of surveys or requests for information sheets in the same format that being dependant dropdown lists using the combo box from forms toolbar. I never thought I would encounter a problem like this as I have explained in my earlier threads (enclosed below) I would be grateful for any assistance. I have even experimented with IF function but it starts to get to complicated. Thanks in advance Lynda Thank you for your response. I am using Combo Boxes from the Forms Control toolbar because i given VBE code for my dependant dropdown lists I am trying to keep my sheets uniform by keeping with the same dropdown. I had a look through Debra's page but it appears it is for data validation lists. This is the code Jim Cone wrote for me =OFFSET(Sheet2!J1,'Sheet1'!G35-1,0,1,1). I have managed to get it to work on all the dropdowns except the dependant lists. If you can help i would be grateful. Cheers Lynda "Lynda" wrote: I was originally corresponding with Jim Cone in the General Questions area but I think I frustrated him too much to return to me. I have decided to post in the Functions area in case someone else can help me. Jim suggested that the OFFSET function was what I needed to use to fix my problem. This is the information I gave Jim for him to decide on the OFFSET function. Sheet 1 Combo boxes (dropdowns) gets lists from sheet 2. I have my combo boxes attached to cells in sheet 1. Sheet 2 has my lists for the dropdowns Sheet 3 I want the cells in sheet3 to pick up the data from cells attached the dropdown cells in sheet 1. 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 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. I am using Excel 2003. I was having a lot of trouble understanding how it works but I am determined to work it out. I have been persisting at home with the problem I am having with the function. I have managed to get most of them working, the ones I am having trouble with now are those that are attached to a dependant drop down list. Sheet 1(dropdowns) Sheet 2(Lists) Sheet 3(Data) D38 (got this one working) ColumnA G3 G38 (this one is dependent on D38) ColumnB H3 K38 (this one is dependent on G38) ColumnC I3 E44 (got this one working) Column O K3 H44 (this one is dependent on E44) Column P L3 Sorry for the long drawn out explanation and I hope it makes sense, I just hope someone can help me. Cheers Lynda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical - Thanks to Roger! it worked like a charm | Excel Discussion (Misc queries) | |||
Sarah to Roger Govier...Needing more help please! | New Users to Excel | |||
For Max + Roger Govier | New Users to Excel | |||
Bob P. and Roger G. -- IF(and(...IF(OR( vs. IF(Boolean | Excel Worksheet Functions | |||
Formulas, question for Roger Govier | Excel Worksheet Functions |