Fill userform, combobox and frame based on data from multiple worksheets
I'm going to attach the file but want to explain a few things.
1. I need to fill the labels on the form and I want to do this using vba because each year it changes. And if I change the worksheet in one cell they all change and this way all the labels will change. The labels are worksheets FY2019 to FY2023 and the row is C1:N1 on each worksheet.
2. I need for my combobox (which I was able to get it to create a dynamic list from each worksheet) to not have blanks or duplicates. The objective is to select a country and fill in the five frames with information from each worksheet based on the select in the combobox
3. I need to be able to add info to a corresponding worksheet based on the fiscal year; i.e., If I have to add another country to FY2019, I need to be able to add a new country in the combobox and from the FY2019 frame add new number that will go into FY2019 worksheet. The trick to this is that on each worksheet in column A that is "INT'L", "INT'L" AND "US GOV" on each sheet. The newly added info has to be inserted into one of these categories on corresponding page.
So I've attached the file and I await your response on any way I can be helped. Thank you for your help in advance.
|