+ Reply to Thread
Results 1 to 3 of 3

Auto copying cells between worksheets

  1. #1
    Registered User
    Join Date
    11-10-2006
    Posts
    6

    Question Auto copying cells between worksheets

    Hello all! I know there has to be a simple answer to this, I just can't figure out how to do it. I have 1 excel file that has 2 worksheets within it. Basically what I need is some sort of formula or script that will auto fill sheet 2 with information that I type into sheet 1. Here is what I need it to do

    The trigger will be Column K on Sheet 1 Y or N

    Example:
    If Sheet 1 cell K4 has a Y then copy the information from Sheet 1 A4, H4, & I4 to Sheet 2 A4, D4, E4
    If Sheet 1 cell K5 has a N then copy nothing to sheet 2
    If Sheet 1 cell K6 has a Y then copy the information from Sheet 1 A5, H5, & I5 to Sheet 2 A5, D5, E5
    If Sheet 1 cell K7 has a Y then copy the information from Sheet 1 A6, H6, & I6 to Sheet 2 A6, D6, E6
    If Sheet 1 cell K8 has a N then copy nothing to sheet 2
    If Sheet 1 cell K9 has a N then copy nothing to sheet 2
    If Sheet 1 cell K10 has a Y then copy the information from Sheet 1 A7, H7, & I7 to Sheet 2 A7, D7, E7

    So I need to to copy information if the K column has a Y, but I need it to appear on sheet 2 all grouped 1 after the other. If you need more info I will try to explain better. Thanks!

    In addition I have cells A2-K2 merged together as 1 cell and I would like that to auto fill in sheet 2 where I have A2 through f2 merged together.

    Any help would be greatly appreciated! Thanks!
    Last edited by bpopilek; 11-10-2006 at 04:12 PM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065
    In Sheet2:

    A4 should say =IF(Sheet1!K4="Y",Sheet1!A4,"")
    D4 should say =IF(Sheet1!K4="Y",Sheet1!H4,"")
    E4 should say =IF(Sheet1!K4="Y",Sheet1!I4,"")

    A5 should say =IF(Sheet1!K6="Y",Sheet1!A5,"")
    D5 should say =IF(Sheet1!K6="Y",Sheet1!H5,"")
    E5 should say =IF(Sheet1!K6="Y",Sheet1!I5,"")

    A6 should say =IF(Sheet1!K7="Y",Sheet1!A6,"")
    D6 should say =IF(Sheet1!K7="Y",Sheet1!H6,"")
    E6 should say =IF(Sheet1!K7="Y",Sheet1!I6,"")

    A7 should say =IF(Sheet1!K10="Y",Sheet1!A7,"")
    D7 should say =IF(Sheet1!K10="Y",Sheet1!H7,"")
    E7 should say =IF(Sheet1!K10="Y",Sheet1!I7,"")

    That should do it! :-)

    Not sure about the merge problem though
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    11-10-2006
    Posts
    6
    Thanks for the quick reply!

    If I am understanding this correctly, it would work to a degree.

    This is assuming that the cells will transfer directly from a4 to a4, h4 to d4 , and so on. What if row 5 column k=N, will sheet 2 row 5 be left empty? Is there a way to make it print say row 8 of sheet1 to row 5 of sheet2, if sheet1 K5-K7 = N? Am I being too vague? Thanks!

    P.S. I got the merged cells to copy between sheets, so that is no longer an issue. Thanks!
    Last edited by bpopilek; 11-10-2006 at 04:54 PM.

+ Reply to Thread

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