Saving Data in a Range of Cells Dependent in Selection from Drop Down List

[Mlwhiteman]

Hi,

I am looking to combine a drop-down list with a range of editable data that can then be saved and later loaded (if possible). What I mean exactly by this is to first have a single drop down list containing all of the calendar months of the year. A range of data (dates, vendors, costs, and budget category for monthly transactions) will then be populated based upon the selection of month. I would like to know if it is possible to edit this range of data for said month, save the current state of the range including any newly-included transactions, and then later load this newly-saved state. Thank you for all of your time and help in advance!

 

[Mlwhiteman]

Bump.

 

[MARK858]

You might get more help if you supplied the ranges for the data, dropdown location, explain exactly what you mean by "and then later load this newly-saved state" and preferably post some usable screenshots (see the links in my signature for some ways to do this).

Basically you haven't given the info most would need to make any proposals.

Btw, if you are just having the Months in the dropdown why can't you just filter the data by the month?

 

[Mlwhiteman]

Excel 2013/2016

	B	C	D	E	F
Laundry / Food
St. Louis
Bingo!	We didn't win
Bingo!	We didn't win
Half of Phone Cancellation Fee	Mom wanted me to pay extra money
Car Insurance M (April)	Late Payment. Yikes.
Rent M (May)	Late Payment. Yikes.
Car Insurance M (May)	Late Payment. Yikes.
Ring Insurance M (June)	Late Payment. Yikes.
Rent M (June)	Late Payment. Yikes.
Car Insurance M (June)
Part of Rent M (July)
Boss Chris at ETC	Cookout with ETC

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]3[/TD]
[TD="align: center"]Date[/TD]
[TD="align: center"]Description[/TD]
[TD="align: center"]Amount[/TD]
[TD="align: center"]Category[/TD]
[TD="align: center"]Notes[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]

[TD="align: center"]$20.00[/TD]
[TD="align: center"]FL Res.[/TD]
[TD="align: center"]Pay Phillips for Laundry[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]13[/TD]

[TD="align: center"]$275.00[/TD]
[TD="align: center"]Wedding[/TD]
[TD="align: center"]Down Payment for Church[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]9[/TD]

[TD="align: center"]$42.00[/TD]
[TD="align: center"]Ent.[/TD]

[TD="align: center"]7[/TD]
[TD="align: center"]23[/TD]

[TD="align: center"]$42.00[/TD]
[TD="align: center"]Ent.[/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]24[/TD]

[TD="align: center"]$95.18[/TD]
[TD="align: center"]Phone Bill[/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]24[/TD]

[TD="align: center"]$200.00[/TD]
[TD="align: center"]CarIns[/TD]

[TD="align: center"]10[/TD]
[TD="align: center"]24[/TD]

[TD="align: center"]$182.00[/TD]
[TD="align: center"]Rent[/TD]

[TD="align: center"]11[/TD]
[TD="align: center"]24[/TD]

[TD="align: center"]$200.00[/TD]
[TD="align: center"]CarIns[/TD]

[TD="align: center"]12[/TD]
[TD="align: center"]24[/TD]

[TD="align: center"]$12.00[/TD]
[TD="align: center"]Ring Ins.[/TD]

[TD="align: center"]13[/TD]
[TD="align: center"]24[/TD]

[TD="align: center"]$182.00[/TD]
[TD="align: center"]Rent[/TD]

[TD="align: center"]14[/TD]
[TD="align: center"]24[/TD]

[TD="align: center"]$200.00[/TD]
[TD="align: center"]CarIns[/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: center"]24[/TD]

[TD="align: center"]$80.82[/TD]
[TD="align: center"]Rent[/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: center"]29[/TD]

[TD="align: center"]$24.00[/TD]
[TD="align: center"]Eating Out[/TD]

[TD="align: center"]17[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Jun 17 (L)​

Originally I was just asking if what I was requesting was possible because I had not seen anything online regarding the topic, let alone how to do it. Above is an excerpt of the range of data. (The full range of data extends to row 133). I am proposing that a drop-down menu be added to cell G4. This drop-down menu would contain all months of the year (January 2017 - December 2017). Additionally I am proposing two buttons (or something similar) - one to save data and the second to load data.

Consider this example:
Assume I start with no data entered. I initially select "June 2017" from the drop-down menu. I have a table similar to that posted above, but empty. I manually enter the line items as seen above. Then I click the "save data" button, and the range of data (B4:B133) is saved into the variable x. I then select "July 2017", and do the same as before (with different data), but the range of data is saved into the variable y. Then, I select "June 2017" again from the drop-down menu and click the "load data" button where I want to load the variable x in order to populate the range B4:B133 with the data as seen above.

The main purpose of this would be to reduce the need for 12 different sheets to just 1 sheet. I hope this now makes sense. If not, I can further clarify.

 

[Mlwhiteman]

Bump.

 

[Fluff]

What you're asking is not possible. When you close xl anything stored in a variable will be lost. Therefore youl'd need to write the stored data to a sheet in order to keep it.