+ Reply to Thread
Results 1 to 2 of 2

record , save and filter rainfall data to show only for the specific month

  1. #1
    Registered User
    Join Date
    04-16-2024
    Location
    Windhoek, Namibia
    MS-Off Ver
    365
    Posts
    7

    record , save and filter rainfall data to show only for the specific month

    good day everyone.

    i want to record rainfall data for the entire year by months.
    i already created a dropdown menu to select the month.
    the challenge I have is that the data is static.
    For example I select Januaryand record rainfall data for all the days of January.
    When I select february, the cells already has the data I entered for January.
    I want when I select a new month, the data for previous month is stored but does not show anymore to allow me to enter data for the new month and if I select a month where previous data was entered, it must show rthat inforamation.
    Can anyone help me fix this please. Any guidance will highly be appreciated.
    Much love.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,661

    Re: record , save and filter rainfall data to show only for the specific month

    Your requirements aren't really workable...
    You will be better off using one tab per year, one column per month and one row per day. Then a 'report' or 'search' tab
    Last edited by protonLeah; 05-12-2024 at 03:38 PM.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate sum of rainfall in a month ( urgent)
    By sheng keong in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2019, 07:40 AM
  2. converting hourly rainfall data into a daily rainfall sum
    By behnam1800 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-23-2019, 02:29 PM
  3. converting hourly rainfall data into a daily rainfall sum
    By behnam1800 in forum Excel General
    Replies: 1
    Last Post: 02-18-2019, 07:21 AM
  4. Show the data for a specific day of the month
    By tsakta13ole in forum Excel General
    Replies: 2
    Last Post: 01-10-2017, 11:27 AM
  5. how to convert minute rainfall to daily rainfall with missing value?
    By Ehsan83 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 09-30-2016, 07:32 PM
  6. Only show records that have specific data in more than 1 record?
    By nbaj2k in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-27-2006, 08:50 AM
  7. [SOLVED] Why does my advance filter only show one record?
    By Kyri in forum Excel General
    Replies: 1
    Last Post: 03-25-2005, 12:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1