Results 1 to 6 of 6

Auto –populate data from one sheet to another based on month

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Auto –populate data from one sheet to another based on month

    Hi - I'm close but not there.. please help
    The workbook contains a summary sheet with different criteria’s listed in a column.
    A different sheet where the data entry should be have a set of criteria’s listed in column A with 12 Months in the other columns
    User enters data per month. Only data for the current month should show up on the summary sheet.
    How can I get my formula straight so I dont get the #N/A. All month work but April. Also is there a formula combination between the index/match and vlookup? as I have 200 metrics in data entry sheets and only selected in summary - would cut down on formula writing - any help is super appreciated - thanks in advance - attached sample of concept
    Attached Files Attached Files

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