Indirect Function - drop down starts at end of list

Hello
forum rules suggest waiting 24hrs before bumping. The volunteers working for free on this forum are not always available at your command. Give them some time, or try a pay site if it is urgent

To Attach a Workbook:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit

I assume you're using an INDIRECT formula to define the range to be used as the source for a drop down list.

Post the formula you're using.

Originally Posted by specialfx

it is 24 hrs

Sorry, must have been dreaming

OK, what's in C1?

It might be easier for us to figure out what's going on if you posted a SMALL sample file that demonstrates the problem.

See post #5 for instructions.

See if this helps:

http://contextures.com/xlDataVal02.html

Ok, we'll need a more detailed explanation of what you're wanting to do.

I can't make heads or tails out of the sample file.

That looks just like the original sample file.

Sorry, but I can't figure out what you want to do based on the contents of the sample file.