Results 1 to 5 of 5

Thread: Macro to Automatically Update a sheet based on values in another sheet on daily basis

  1. #1
    Junior Member
    Join Date
    Feb 2014
    Posts
    2
    Rep Power
    0

    Macro to Automatically Update a sheet based on values in another sheet on daily basis

    Hi,

    I want the values of X and Y in sheet 1 to get updated on a daily basis based on the values entered in sheet 2 for the corresponding date.
    I have attached a sample of the workbook. Im quite new to macros so help would be really appreciated. Thanks in advance.
    Attached Files Attached Files

  2. #2
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    13
    In Cell B5 Paste below code :

    =INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),2)

    In Cell C5 Paste below code:

    =INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),3)

  3. #3
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    13
    You can try this also:

    Paste below code in Cell B5 and drag it to Next cell (C5):

    =INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),MATCH(B$4,Sheet2!$B$4:$D$4,0))

  4. #4
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    12
    you can simply use a querytable.

  5. #5
    Junior Member
    Join Date
    Feb 2014
    Posts
    2
    Rep Power
    0

    Thanks!

    Thank you so much! You saved my day





    Quote Originally Posted by LalitPandey87 View Post
    You can try this also:

    Paste below code in Cell B5 and drag it to Next cell (C5):

    =INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),MATCH(B$4,Sheet2!$B$4:$D$4,0))

Similar Threads

  1. Replies: 2
    Last Post: 09-30-2013, 03:40 PM
  2. Need help to add sheet, rename and update in TOC
    By kets0985 in forum Excel Help
    Replies: 2
    Last Post: 07-28-2013, 06:04 PM
  3. Replies: 30
    Last Post: 07-19-2013, 07:52 AM
  4. Replies: 10
    Last Post: 06-20-2013, 12:21 AM
  5. How to Update Daily Log In Another Sheet
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 6
    Last Post: 04-06-2013, 01:47 PM

Tags for this Thread

Posting Permissions

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