copy data from sheet to another based on two dropdown selection

[ABDELFATTA]

hello
i try making code copy data from sheet to another based on two dropdown selection h1=name and i1 = month what i would when i select month and name it brings data relating the name and month and if i select month and no selected name bring data relating month and if i select only name without month then bring data name and if no selected month and name then bring all data

[nankw83]

Hi ABDELFATTA,

Try below code ...

Please Login or Register  to view this content.

[ABDELFATTA]

thanks nankw83 it works but not what i want still things missed when i select name and empty month it gives me error and the same thing with the month and the name are empty the right when i select only name then ignore the month if the month and name are empty then copy all of data and i note if i select only month for instance dec then copy all of data of months of course is wrong it should copy what i select the only dec month

[nankw83]

Noticed a small glitch in the code & just corrected it before your post ... Try the revised code again in post #2

[maniacb]

Try

Please Login or Register  to view this content.

[ABDELFATTA]

hi, nankw it remains one thing when i select dec month it also copy oct, nov this is not what i want i would copy what i choose specific month if i select dec then copy only dec without copy months

[nankw83]

This is weird ... It is working as expected for me - File attached

[ABDELFATTA]

yes is very weird i checked your file and i see you result month nov but when i run the problem continues i just last thing if you have time this is my mistake i had making clear from the beginning if is possible do that in worksheet change event thanks for your time

[nankw83]

So before making the code a worksheet change event, does the file work as expected for you ?

[ABDELFATTA]

actually still the problem continues , is it version office relating that ?

[Fluff13]

I get the same thing, try

Please Login or Register  to view this content.

[ABDELFATTA]

thanks Fluff now it works actually if i have no data in specific month it gives me error i fixed by on error resume next but if is possible instead of brings me message box this month doesn't contain data

[jindon]

Assuming years of dates in col.A are all current year.

Please Login or Register  to view this content.

[ABDELFATTA]

hi, jindon did you test your code in attached file ? it doesn't work for me it doesn't show anything in sheet (result)

[jindon]

Of course it is working here, but I just realized that the month names in your country is not like jan, feb, mar etc...

Try change to

Please Login or Register  to view this content.

[ABDELFATTA]

yes jindon your code works but not like nankw83 and maniacb i have ever explained this part
when i select month and no selected name bring data relating month and if i select only name without month then bring data name and if no selected month and name then bring all data
thanks again

[ABDELFATTA]

well done , maniacb your code works as what i want sorry i'm too late to answer you

[jindon]

OK, this should do.

Please Login or Register  to view this content.

[ABDELFATTA]

still missed something when month and name are empty it gives me error it supposes copying all of data

[jindon]

Ahhh, missed that.
Add one line in bold.

Please Login or Register  to view this content.

[ABDELFATTA]

thanks jindon every thing is ok i know my demands are so much but i have last thing if i have no data in specific month i would show message inform me " there is no data for this month"
thanks again

[jindon]

Add lines in bold.

Please Login or Register  to view this content.

[ABDELFATTA]

excellent i just understand this part of code it supposes showing formula in col m but nothing is existed am i right or wrong?

[jindon]

When both J1 & I1 are blank, M2 should have no formula, means no condition, so full extraction.
Check after the data transfer, if any row(s) are added below the header, record(s) are transferred, otherwise No data found.

HTH

[ABDELFATTA]

hi, jindon actually whether month & name are empty or not it doesn't show the formula it 's not important it's minor and curiosity from me the most important copy data based on two selection and multiple condition
i would thank you and nank maniacb , fluff for your codes and assistance
best regards,
abdelfattah

[jindon]

M2 is covered by the Button, so you can not see.
Move the button somewhere else and do a step debug, so that you can see the formula when one of H1:I1 cell is/are filled.

[ABDELFATTA]

before i issue post 25 i thought that like you i moved the button but nothing happened

[jindon]

Impossible,
You are not doing a step debug...
Fill H1 or I1 or both and run then code.

Please Login or Register  to view this content.

[ABDELFATTA]

i did and highlight in stop and show true in m2

[jindon]

Then select M2 to see the formula in the formula bar.

[maniacb]

Here is my version of the code as a worksheet_change event, as you requested above.

Please Login or Register  to view this content.

[ABDELFATTA]

thanks maniacb but it doesn't show anything except the headers

[maniacb]

Here is the code in the workbook.

[ABDELFATTA]

yes it works but not all of cases for instance if i select month and name does not work and if i select only month doesn't work so your code works only two cases first when select only name the second when the month and name are no selected
i hope fixing

[maniacb]

I capitalized the month values on your sheet to make the code work. Jindon and Nankw83 solutions don't have this limitation.

[ABDELFATTA]

jindon did it in post 20# and before it i made clear you can check it
thanks again

[maniacb]

Here is the updated code

Please Login or Register  to view this content.

[ABDELFATTA]

many thanks but i have note this is not firs problem face about writing month every code depends on month doesn't work if writing month is not match with office language so in the beginning the code doesn't work if the month by English my office is Arabic then works , is it problem from language or other problem ?