+ Reply to Thread
Results 1 to 2 of 2

Problem having data auto update from one worksheet to another

  1. #1
    Registered User
    Join Date
    10-13-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Problem having data auto update from one worksheet to another

    I am trying to pull data from one worksheet (Database) to another (Data Final) using IF functions.

    Eg. To populate the Data Final worksheet with the names of only people who are active in the club I'm entering something like this:

    =IF('Database'!CG1=1, 'Database'!A1, "")
    =IF('Database'!CG2=1, 'Database'!A2, "")
    =IF('Database'!CG3=1, 'Database'!A3, "")
    =IF('Database'!CG4=1, 'Database'!A4, "")
    =IF('Database'!CG5=1, 'Database'!A5, "")

    It's working well, but, when I add someone to the Database worksheet, it does not populate in the Data Final worksheet, instead, the formula in the Data Final worksheet skips a number. So, for example, if I added a row at row 3 in the Database it would give this in my Data Final worksheet:

    =IF('Database'!CG1=1, 'Database'!A1, "")
    =IF('Database'!CG2=1, 'Database'!A2, "")
    =IF('Database'!CG4=1, 'Database'!A4, "")

    =IF('Database'!CG5=1, 'Database'!A5, "")
    =IF('Database'!CG6=1, 'Database'!A6, "")

    Anyway that I can change my formula so that it updates in Final Data when a row is added to Database?

    Any help would be greatly appreciated!
    Last edited by Leslie1234; 10-13-2010 at 10:12 AM. Reason: Incorrect Title

  2. #2
    Registered User
    Join Date
    08-09-2010
    Location
    Midlands
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Help!!! :)

    try using the indirect function


    Please Login or Register  to view this content.
    Hope that works,

    Maudise

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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