+ Reply to Thread
Results 1 to 3 of 3

Conditional data transfer between worksheets based on multiple conditions or criteria

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    St. Louis
    MS-Off Ver
    Excel 2010
    Posts
    20

    Exclamation Conditional data transfer between worksheets based on multiple conditions or criteria

    I have a workbook containing multiple worksheets and want to transfer (copy/paste) data from row "3" of worksheet "2" to row "3" of worksheet "1" depending upon values (text, numeric, blank) found in columns "L", "M" or "N" (or some combination of same) of worksheet "1". Can anyone solve this please? Please see attached example.
    Attached Files Attached Files

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

    Re: Conditional data transfer between worksheets based on multiple conditions or criteria

    in Worksheet "1"!A3
    ='Worksheet "2"'!A3
    copy across the row and down the columns

    I seriously doubt this is what you want in the long term 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
    02-20-2013
    Location
    St. Louis
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Conditional data transfer between worksheets based on multiple conditions or criteria

    Not quite what I'm looking for, all that does is populate worksheet "1" with values found in worksheet "2". The function I'm looking for would ONLY do that based on a set of criteria - data found in other, specified cells of worksheet "2".

+ 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