There are no suggested values; I manually monitor data on a random date (whenever I happen to be close to an elapsed time meter that is connected to my heating system. I write the data on paper, and note also the date. Then, I enter the collected data into my AOO spreadsheet.
I am afraid I failed to be clear about what I desire. I am looking for a Calendar-type of dropdown menu to be repeated within a row of spreadsheet cells. I don't know the correct name ! (Might need a macro? Or, perhaps an add-on to AOO.). Thus, I have not been successful searching in AOO's Help file. As I mentioned, I seek an easier way to enter a calendar date; similar to what may be found in a financial s/w (e.g., checkbook register entry) or in a Calendar s/w, where I can quickly select a desired Month, then the Day of that month, all within a preselected Year. It would be great if the DD/MM/YYYY is repeated (unchanged) until I menu-select a new DD/MM/YYYY. Is there such a function in AOO? Once the date is selected, the spreadsheet formula calcs the elapsed number of days between one cell and the immediate next cell. For example: A1 contains the date of, last Thursday; today is Wednesday, which is set in A2. I need to count the number of days; A2-A1, to calc amount of Heating Fuel consumed. .... Counting the number of elapsed days is not the issue; quick selection of revised date data is. Maybe such a dropdown menu is available in AOO Base, and I will need to combine Base and Spreadsheet? Regards, VinceB Sent from my iPad > On Jan 28, 2015, at 11:42, Brian Barker <[email protected]> wrote: > > At 11:19 28/01/2015 -0500, Vince Bonly wrote: >> Can someone point me to info on creating a dropdown menu in a Spreadsheet >> cell, if this is possible? I have created a spreadsheet to calculate Heating >> Fuel consumption, and frequently need to enter a specific date into a cell. >> A dropdown menu, I think, would save me time when needing to do this. > > o Enter the suggested values into cells somewhere in the spreadsheet. (These > can be tucked away somewhere.) > o Potentially select this cell range and use Insert | Names > | Define... to > give the list a name. > o Select the target cell or cell range. > o Go to Data | Validity... . > o On the Criteria tab, for Allow, select Cell Range. > o Click in the Source box and either drag over the list or type its name. > > There are many options you can adjust, such as "Show selection list" (which > you will want), as well as "Allow blank cells", and providing some help text > when the target cell is selected. The Error Alert tab allows you to control > whether values not in the list are permitted (Warning instead of Stop) and an > error message that can be produced. > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] >
