Using combo box to show monthly variable data

[SChapman]

I require a way to use a combo box so that when a month is chosen the data is populated for that particular month once the data has been input by the user.

How can I do this?

My thoughts are copy the inputted data for each month once it's been completed on another sheet (make this hidden) then copy it back once the month is selected in the combo box but how can I make the cells empty again when another month is selected so that it can be completed by the user.

Hope this makes sense, I have attached a sheet to give you an understanding of what I mean....

Thanks in advance.

[Fotis1991]

Not clear at all which is your goal. As both of your sheets have no data i can understand.

Would you like to put some data in your sheets and then to explain which will be the expected results?

[SChapman]

How would the data matter? I only want lets say....January data to be input by the user then when February is chosen in the combo box, the cells would empty so February could be completed. If I wish to then look back at January's data then I select January to populate it.

Hopefully that is clearer

[Fotis1991]

...Hopefully that is clearer

Unfortunnately not for me.

Maybe someone else wil be better than me to understand this.

Good luck.

[oeldere]

Please Login or Register  to view this content.

Why having a problem with adding data if a forummember who likes to help YOU, asked you for data?

[SChapman]

The data is confidential and I was only asking the question. My apologies if it came across rude.

[SChapman]

I have added dummy data to the spreadsheet and attached to show what kind of data would be input by the user, I would need this to then save under January for later reference then when February is selected in the combo box, it would clear the cells so that the data could be input again by the user for February's results.

Thanks guys.

[Fotis1991]

With this lay out of your data and the way that you want to do this, you will need An Expert in VBA! And i am not!

[SChapman]

Thanks for looking Fotis1991!

Is there an alternative way without using VBA? But using the same or similar form design?

[oeldere]

Thanks for adding an file (with dummy data)

I'm also not an VBA expert, but also with the dummy data i don't understand what has to be done.

[Fotis1991]

One way could be in your first sheet(using dates) to have ALL your months and people type data for eatch month.

Then in your second sheet using the combo list to choose the month that you want to see the data and get your results using formulae.

[SChapman]

One way could be in your first sheet(using dates) to have ALL your months and people type data for eatch month.

Then in your second sheet using the combo list to choose the month that you want to see the data and get your results using formulae.

Would this not make the first sheet (using dates) be fairly big due to the data required for each month? That would mean copying the current form 12x on one sheet, one for each month. Right? Or am I missing something?

Thanks for adding an file (with dummy data)

I'm also not an VBA expert, but also with the dummy data i don't understand what has to be done.

Hi oeldere, I require similar data as shown in my example to be entered manually by the user for every section per month. When the month is chosen in the combobox it shows the data that has been input i.e I wanted to look at January's data. Or if the data for a particular month hasn't been entered by the user (due to the fact that month hasn't passed yet) then the cells would be empty for the user to input the data for that month. Each month that has passed where data has been captured by the user, I need to be able to choose a particular month and see the data for the month that I select.

Does that make sense?

[Fotis1991]

I give you a small example of what i mean.

[SChapman]

I give you a small example of what i mean.

Sorry about the late reply, I'm struggling to get time to work on this.

That is similar to what I'm looking for! However, the data cannot be edited without the formulas being deleted. Each months data needs to be captured by a user & when this is done it will overwrite the formula within the cell, your example would work with static data only from what I can see. Is it possible to do a separate sheet (hidden) to capture each months data as it's entered then when the month is changed it will pull the data back?

Unless you can think of an easier way of course?

Thanks for your help on this!

[SChapman]

My apologies, I've just noticed you have done a similar thing to what I just suggested (Lack of sleep due to the kids). I'll have a better look & come back to you

[SChapman]

I go back to original reply, maybe I could show you the actual workbook?