| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Lists
Hi Ralph,
Weird, I got the Ref thing too. Overcame it by doing this. Enter = in your sheet 2 cell. Select the 1st sheet and click on G3. Now finish the formula with ="","", and then reclick G3. Gave me the exact 'looking' formula but works fine. I tried a re-enter on your ref formula by F2 Enter and it brought up MyDocuments file folder of Excel workbooks....???? On your copy paste formula I deleted everything between the ( ) and did it manually like above and worked fine. A new one on me. HTH Regards, Howard "RalphB" wrote in message ... I have a list on one sheet and would like to show the same list on anothersheet. The problem is, I want the list on sheet2 to be updated at the same time the list on sheet1 is changed so that both they are always the same. Both sheets are in the same workbook. Can anyone one help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down lists from multiple source lists | Excel Worksheet Functions | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| Comparing Lists to Partial Lists | Excel Programming | |||
| Form lists influencing other lists | Excel Programming | |||
Hybrid Mode
