Results 1 to 3 of 3

Auto copying cells between worksheets

Threaded View

  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.

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