Hi, just a quick query, I have a sheet that uses dynaic ranges, created by ctrl+shift+f3, if want the column title to be dynaic so that the dynaic range changes as the column heeder changes, the column headers are in alphabetical order and change if an entry is made on list that is higher that the previous highest entry.
Just wondering
JD
Hi,
For that sort of question it would be very difficult to give you a purely theoretical answer without having seen an example in an actual workbook.
Regards
Here is a sample workbook.
Ok, and based on that workbook can you give an example of what you would like to see?
Regards
Here is slightly updated example with extra details
And you can't just use Create from Selection each time a new column is added? Alternatively, some VBA would resolve this, though the difference between clicking a button for that and clicking Name Manager/Create from Selection is not a huge one.
Or am I missing something?
Regards
Hi It has to be user intuative so that as the user enters the course details the list updates and adds the new heading and subsequent drop down list so I need everything automated, if there is a way without using vba that would be good as I have to create this for svereal offices and not all pcs are macro enabled in excel, the user have a basic understaing of excel but nothing indepth to create the a new range themselves.
Hope that exlains the need for the flexibility of this request.
Thanks
JD
Without VBA, no.
The Name part of a Defined Name is static and cannot reference a range.
Regards
Could I use a hyperlink button to update the columns using the ctrl+shift+f3 as part of a formula?
JD
Sorry - not sure what you mean?
Regards
Hi I have found what I am looking for at this link http://www.contextures.com/xlDataVal15.html
Thanks for the time.
JD
This might be late but still be of interest. I took your courses and created a dynamic list called Main out of them and made the headers of the columns dependant on the contents of the Main list. All the lists can be made dynamic if you want.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks for the reply great solution, I have implemented it and it works brilliantly.
Cheers
JD
Glad that it worked for you and thank you for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks