Results 1 to 6 of 6

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

Threaded View

  1. #4
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

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

    In Sub-Summary,
    Put this in B2:
    =INDEX('Data Entry'!$B$2:$E$7,MATCH($A2,'Data Entry'!$A$2:$A$7,0),MATCH(B$1,'Data Entry'!$B$1:$E$1,0))
    Copy down
    Last edited by Max, Singapore; 08-10-2012 at 11:00 AM.
    Max
    Singapore

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