Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Validation List to range

Posted on 2012-04-11
8
Medium Priority
?
264 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 400 total points
ID: 37831552
It would be easier if you upload a workbook
0
 
LVL 9

Accepted Solution

by:
wasiftoor earned 1600 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 37832009
I am really wondering what made me deserve 100 points.
0
 

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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

916 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