+ Reply to Thread
Results 1 to 5 of 5

How to use drop down menu to populate data to other sheets

  1. #1
    Registered User
    Join Date
    03-23-2013
    Location
    seattle
    MS-Off Ver
    Excel 2007
    Posts
    36

    How to use drop down menu to populate data to other sheets

    Thanks for all of your help, you've been great.

    So, I got data that is being entered daily in 5 columns. What I have is different sheets for each day of the month where I manually copy processed data from sheet1 to other sheets depending on the day of the month...

    sheet1-processed data
    may-1, may2, etc for the sheets for each month to save processed data to.

    What I would like to do, is to add drop down selection in sheet1 above processed data, to be able to select day of the month sheet, and submit or load "ProcessedDataTable" from sheet1 into specified column selection of selected sheet.

    Any guidance?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,117

    Re: How to use drop down menu to populate data to other sheets

    1st, I would question why you have a sheet for each day of the month? It would probably be far simpler and easier if you had all your data in 1 sheet, as a data base, and then ran summaries on other sheets?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-23-2013
    Location
    seattle
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: How to use drop down menu to populate data to other sheets

    Thanks for asking. Problem is, my data is 1,500 rows down for each day, i have script that filters some of it out, but the rest need to save it to other sheets as a record and possibly monthly comparison/analisys.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,117

    Re: How to use drop down menu to populate data to other sheets

    you have 2007, that has over a million rows available. 1500*31 is less than 50 000 (46000)

  5. #5
    Registered User
    Join Date
    03-23-2013
    Location
    seattle
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: How to use drop down menu to populate data to other sheets

    Thanks for advice, after thinking about it, I guess I could do it all at once... Now, how can up pull specific data into another sheet (date specific).

    I got 5 columns that I work with, and one of the columns is DATE, that will have different dates in it, formatted 05-01, 05-02, 06-01, and so on. In another sheet, I would like to have drop down of some sort to select available date, and show all data that has that date in that column...

    Any help?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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