动态列表 [英] Dynamic Lists

问题描述

我在工作表中有一组数据"NLIM_Data"。如果有多个列，其中一个是"日期"，则任何新数据都会通过Userform添加到此工作表中。

I have a set of data in worksheet "NLIM_Data" with numerous columns, one of these is "Date", any new data is added to this worksheet by means of a Userform.

我有另一个工作表"Dashboard"其总结了从"NLIM_Data"产生的某些统计数据。工作表，由年份决定。

I have another worksheet "Dashboard" which summaries certain statistics generated from the "NLIM_Data" worksheet, dictated by year.

我在Cell B27工作了第一年，在B28工作室工作了第二年，第二年比第一年少了一年。第一年通过下拉列表"年"选择。每年更新。

I have the first year in Cell B27 and a second year in cell B28, the second is 1 year less than the first. The first year is selected by a dropdown list "Year" updated each year.

我希望年份能够按日期列填充，而不是逐年添加一年，我希望有一种方法可以使用吗？

Rather than adding a year incrementally to this list i would like the year to be populated by the date column, is there a way this can work??

史蒂夫

推荐答案

史蒂夫，你好b $ b

我正在为您制作样品，并想确认：

（1）哪里是下拉列表？ 在UserForm上，在工作表"仪表板"或其他上？

（2）指定年份的范围。即第一年和最后一年？ 例如2017-2008（从今年到过去10年） 



问候，

Hi Steve,

I'm making a sample for you, and would like to confirm:
(1) where is a Drop Down List?  on UserForm, on sheet "Dashboard", or other?
(2) specify the range of year. i.e. the first year and the last?  e.g. 2017-2008 (from this year to the past 10 years) 

Regards,

这篇关于动态列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！