Dynamic Data Validation

[irisqueiroz]

Hi,


I'm trying to make a worksheet of expenses control. The idea is to select a month and the week of this month, and the it will appear a table to complete the expenses in that time.

How can I do this?


Ex: select month january, and week 1 ... then it will appear the table with the expenses in this week

if you select month march, and week 3 the table must be empty, since this day is in the future.


I'm attaching the worksheet.

https://www.dropbox.com/s/ee1ktj6ns9x9tul/Expenses.xlsx


Thanks!

 

[Hui]

Irisqueiroz


How come this is posted twice under this and xxxx's names?


You don't get any faster service and in fact you are wasting the Ninja's and othe helpers time by double posting


Hui...

 

[kaushik03]

Hi irisqueiroz,


First of all your data and sheets are in some other language (probably French!) which I found little difficult to understand and your sample data is not complete according to your explanation in the post.


However, according to my understanding, I have created a sample data for the months and weeks as follows (just beside your data):

[pre]

Month	         WeekNumber
1	2	3	4
Janeiro	30.27	22.39	44.20	38.70
Fevereiro	20.87	13.87	10.18	30.53
Março	34.43	42.27	33.47	38.50
Abril
Maio	2.48	15.51	13.19	11.61
Junho
Julho	30.68	39.08	26.17	21.98
Agosto
Setembro	7.91	34.31	7.60	38.15
Outubro	49.76	6.30	5.77	17.72
Novembro	44.47	28.21	0.88	49.20
Dezembro	48.91	16.52	34.27	49.17

[/pre]

Now, in sheet where you have created the drop down, at D5 below here is the formula linked to the data sample I have created and the drop downs you have created (at B1 and B2):


=SUMPRODUCT((Dados!$F$3:$F$14=Saídas!$B$1)*(Dados!$G$2:$J$2=Saídas!$B$2)*(Dados!$G$3:$J$14)) ENTER


Now, if you change the month and week number at B1 and B2, respectively, the formula should update automatically at D5.


Let me know if this is something close to what you are looking for..


Below here is the link for the file as well..

http://speedy.sh/murtk/Expenses.xlsx


Regards,

Kaushik

 

[irisqueiroz]

Hui, I don't know what are you talking about... I didn't post this twice.


kaushik03, thanks! I'll check it tomorrow

 

[Hui]

Irisqueiroz


Something has gone wrong my end


I opened another post, downloaded a file and got your file again instead of theirs


My apologies


Hui...