+ Reply to Thread
Results 1 to 8 of 8

Auto populate cells from seperate worksheet with =IF(a1>0)

  1. #1
    Registered User
    Join Date
    04-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2010
    Posts
    14

    Auto populate cells from seperate worksheet with =IF(a1>0)

    My first post here,
    i need help with the following:
    I am building a Quotation Form that needs to be autopopulated by
    selecting a quantitie of products from a different worksheet.
    so if: sheet1 A1 has a value of more than 0
    then sheet2 A1 will indicate what is on sheet1 A2 and !3 =(A2&A3) in a single cell

    Thanks a Million!
    p.s i am translating all from french...
    Last edited by tack1986; 04-28-2013 at 11:44 AM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,683

    Re: Auto populate cells from seperate worksheet with =IF(a1>0)

    put on sheet2 A1
    =if( sheet1!A1>0, sheet1!A1, "what to put if 0 or less")

  3. #3
    Registered User
    Join Date
    04-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Auto populate cells from seperate worksheet with =IF(a1>0)

    Thanks !!!!!
    i edited the last part, how would i integrate the 2 cells in that formula?

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,683

    Re: Auto populate cells from seperate worksheet with =IF(a1>0)

    then sheet2 A1 will indicate what is on sheet1 A2 and !3 =(A2&A3) in a single cell
    sorry can you explain a little more

    Sheet1!A1 is >0 the put that onto Sheet2!A1

    now you mention A2 and A3

    If i'm correct

    IF( sheet1!A1 >0 , Sheet1!A2&Sheet1!A3, "what to put if 0 or less")

  5. #5
    Registered User
    Join Date
    04-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Auto populate cells from seperate worksheet with =IF(a1>0)

    did not work but that gave me a good base to figure it out!!thank you, you prob saved me a few hours ...

  6. #6
    Registered User
    Join Date
    04-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Auto populate cells from seperate worksheet with =IF(a1>0)

    ahhh kkkk if 0 or less,nothing is to be indicated..... i...seee...

  7. #7
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,683

    Re: Auto populate cells from seperate worksheet with =IF(a1>0)

    seems to work OK
    to show nothing
    =IF( Sheet1!A1 >0, Sheet1!A2&Sheet1!A3, "")

    whats the issue - or is it all now sorted

  8. #8
    Registered User
    Join Date
    04-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Auto populate cells from seperate worksheet with =IF(a1>0)

    wow! all that to find i can not do: =IF( Sheet1!A1 >0, Sheet1!A2&Sheet1!A3, "")
    i had to do: =Si( Sheet1!A1 >0, Sheet1!A2&Sheet1!A3, "")
    Si is french for if...Man that was a waste of time...

+ 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