Populate TextBoxes based on 2 Criteria from worksheet Data

Anyone may have an idea on this?

so if i follow you, you want to input the selected fiscal year (FY) and then select the fruit and have it fill out the months based on the DATA table? is that correct?

Originally Posted by dmcgov

so if i follow you, you want to input the selected fiscal year (FY) and then select the fruit and have it fill out the months based on the DATA table? is that correct?

That's indeed correct dmcgov. With my example, textboxes should be populated by the following May 2018: Done, Jun 2018: 0, Jul 2018: Done, ..., Mar 2019: Chase, Apr 2019: Chase.

Thank you.

so put this in the code for your form:

Please Login or Register  to view this content.

let me know if this works for you

Thank you dmcgov. I think you are on the right path. However, it only pulls the data from the first 12 columns, which means it doesn't take into consideration the Fiscal Year, as it only pulls the first fiscal year.
I reckon we have to add another variable to be able to consider other Fiscal Year as well.

yah, my bad. i skipped over the other columns. let me see if i can me this work for other dates other than 2018.

so i need to ask a question. i see that columns c-j have 2017 but not all months are there. how does this impact your userform?

nm i figured it out. i'll post shortly.

i see that columns c-j have 2017 but not all months are there

This is because the Fiscal Year or Financial Year starts from May to April. in the drop down list I added the 2017 (which I deleted now) because my data starts only from the May 2017 which is FY18. Hope it makes sense.

Hi, test my code

Please Login or Register  to view this content.

Regards.

if that doesn't work for you, then i have a solution (its a kludge though) that will work for you.

Dear maras_mak:

Thank you so much for your help and input on this. I did test it and it worked very well and achieved what I was looking for.
Would you mind please explain some of the codes you used as I could not make sense of them, particularly those in red.

Much appreciated.

Please Login or Register  to view this content.

dmcgov. maras_mak suggestion was working. Now I just need to understand some of the codes in there. Thanks a lot for your input. Much appreciated.

Hello,
So attached is part of the real workbook I needed the code for.

As you can see, nothing happens when the code is put into test.

This is the code I wrote to reflect the change on the worksheet Overview of course.

Where do I get it incorrect please? Much appreciated.

Please Login or Register  to view this content.

Anyone can help fix the code?

Thank you.

Hi, you have two identical products - 'White'.
I changed and added a type to each name.
I attach the corrected workbook.

Kind regards,
Maras.

Hello maras_mak,
Thanks fo this. I can only test tomorrow morning but wondering what's the rationale behind the changes in the code as compared to the one you initially provided? I think you made a slight change to it.

Hi, I changed the way of fiscal year search mainly because there was a different data layout in both attachments.
In the first were the values of a given fiscal year in the first row of the sheet, in the second one there are none.

Best regards,
Maras

Hi maras_mak,

I just test and have play around the updated workbook but unfortunately, nothing was displayed in any TextBox. Do I have to do something to execute the macro?

Thank you.

I think this is a date format problem.
For example, if you have the date format "01/05/2019",
Set fd_rng = .Range ("5: 5"). Find (DateValue ("5-1-" & fsl_yr)) change to Set fd_rng = .Range ("5: 5"). Find (DateValue ("1/5/ "& fsl_yr))

Greetings.
Maras.