LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Ignore blank rows to populate custom drop down list column ran

It will, you just need to know how. You will have the same problem in
Access, with a much less rich environment IMO.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"vidtec" wrote in message
...

Thank you for your help. I was afraid that this was not going to be as

easy
as changing a "0" to "1" or something similar in the properties settings.

I
will play around with your suggestion and see if I can get to work in my
situation. Thank you so much for your time it is appreciated. Next year

after
Vista and Office 12 comes out I plan on upgrading to Access. I am trying

to
do too much in Excel with inventory control with to many Items that have

too
much information per item, I think I need to upgrade to a database and

create
reports & forms. Excel is great but just won't go through the hoops I need

it
to anymore. Thanks again.. :-)



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMPRODUCT - Ignore blank rows sahafi Excel Worksheet Functions 8 June 13th 07 06:11 PM
Populate a column of data with a formula using a drop down list nafflerbach Excel Discussion (Misc queries) 1 May 24th 07 12:20 PM
Using a drop-down list along with an auto-populate drop-down CrazyLostConfused Excel Discussion (Misc queries) 1 April 17th 07 12:10 AM
Drop Down List Ignore Blank Ben Dummar Excel Discussion (Misc queries) 1 September 22nd 06 07:53 PM
How do I set up a drop down validation to ignore any blank cells? MLP Excel Discussion (Misc queries) 1 August 3rd 05 11:20 PM


All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"