Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Populate Data From Another Sheet With Criteria

  1. #1
    Join Date
    28th May 2006
    Posts
    133

    Populate Data From Another Sheet With Criteria

    Hi,

    I hope the thread title is correct.

    I have a spreadsheet which I need to populate the data from sheet based on current date.

    Cell C7 in the "Staff" tab needs to update from tab "Data" for John based on the current date . The current date is located in cell A3 in the "Staff" tab.

    On daily basis, as I open the spreadsheet , cell C7 should update from the "Data" tab automatically based on the date in cell A3 in the "Staff" tab.

    Example, on January 4 2008, cell C7 should populate as 2 from the "Data" tab.

    I tried using the IF formula, but I cant expand the formula for the whole month of January since it is limited only to 7 arguments.

    Appreciate help.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th May 2004
    Location
    central Europe
    Posts
    773

    Re: Populate Data From Another Sheet With Criteria

    in C7 on sheet staff :
    =VLOOKUP(A7;Data!$A$3:$W$6;MATCH(Staff!$A$3;Data!$A$2:$W$2);FALSE)
    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

  3. #3
    Join Date
    28th May 2006
    Posts
    133

    Re: Populate Data From Another Sheet With Criteria

    Thank you ! That worked.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. View Data From Another Sheet Based On Criteria
    By loleffe in forum EXCEL HELP
    Replies: 1
    Last Post: April 17th, 2008, 13:44
  2. Move Data By Criteria To New Sheet
    By Levett in forum EXCEL HELP
    Replies: 10
    Last Post: September 10th, 2007, 09:02
  3. Populate Data From One Sheet To Another
    By neildexter in forum EXCEL HELP
    Replies: 4
    Last Post: May 31st, 2007, 05:10
  4. Copy Data From One Sheet When Criteria Is Met
    By billyj in forum EXCEL HELP
    Replies: 2
    Last Post: April 26th, 2007, 01:03
  5. Return Data to Another Sheet Based on Criteria
    By brook1 in forum EXCEL HELP
    Replies: 20
    Last Post: July 30th, 2006, 22:57

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
  •  
porno