Solved

Validation List to range

Posted on 2012-04-11
8
249 Views
Last Modified: 2012-04-11
Hi,

I am looking for some code to do the following

I have a validation List (Open/Closed). I would like on entry to the spreadsheet this list to be extended down the column to as far as Column A goes

So if today there is 20 rows, all 20 rows have that validation  on entry, if tomorrow it is 15, then 15 rows have validation and if the day after there is 25 rows, then 25 rows have validation.

Thanks
Seamus
0
Comment
Question by:Seamus2626
  • 4
  • 3
8 Comments
 
LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 100 total points
ID: 37831552
It would be easier if you upload a workbook
0
 
LVL 9

Accepted Solution

by:
wasiftoor earned 400 total points
ID: 37831553
You can copy the formula for all row of column A. You can do that by dragging the first cell with the validation by selecting and than dragging from the bottom right edge of the cell. After that you should never have to worry about extending this.
0
 

Author Closing Comment

by:Seamus2626
ID: 37831829
All sorted

Thanks
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 37832009
I am really wondering what made me deserve 100 points.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:Seamus2626
ID: 37832438
I never used the second answer as i worked it out myself. Had i not and loaded the WB, from our previous dealings, you would have came good :-)
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 37832496
Honestly such questions which do not have any technical value should be deleted rather than awarded. These questions are supposed to form EE's knowledge base and should have technical value.

You could, however, post your solution and then accept your own answer. This way the question and the solution becomes a valuable part of EE.
0
 

Author Comment

by:Seamus2626
ID: 37832528
I was actually going to split the points between me and wasiftoor but couldnt see the button to award myself points, so presumed that was no longer an option on EE. Now I know that i can post myself and award points, that is what i will do!

Thanks
Seamus
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 37832622
To be able to include yourself in the acceptance there must be a comment from you. Since you had no comment therefore you could not see the button. You should have posted your solution and then the button would have been there.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now