+ Reply to Thread
Results 1 to 30 of 30

transfer of specific data Based On Multiple Conditions from worksheet to Multiple sheets

  1. 12-24-2016, 12:41 AM #1
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    transfer of specific data Based On Multiple Conditions from worksheet to Multiple sheets

    Greetings to all
    Is it possible transfer of specific data Based On Multiple Conditions from worksheet to Multiple sheets
    I hope, to add some other conditions in the same code
    I want to transfer data first five columns with the columns from No. 95 to 98, depending on the column 31 from data sheet to salma sheet
    And also first five columns with the columns from No. 114 to 117, depending on the column 32 from data sheet to saied sheet
    Thank you very much for the help
    Last edited by salmasaied; 01-01-2017 at 11:43 PM.
    Reply With QuoteRegister To Reply
  2. 12-24-2016, 07:39 AM #2
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee 

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 12-24-2016, 07:12 PM #3
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Hi , LeoTaxi
    Thanks a lot for replies
    Thank you very much for trying
    I'll add this code in the original file, and I'll tell you the result
    Accept appreciate and respect
    Last edited by salmasaied; 12-25-2016 at 08:11 PM.
    Reply With QuoteRegister To Reply
  4. 12-25-2016, 05:11 PM #4
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    My dear sir, LeoTaxi
    welcome
    I have tested the code and is works nicely
    But the problem of incompatibility between codes
    Thank you very much for the help
    Kind regards
    Last edited by salmasaied; 12-25-2016 at 08:20 PM.
    Reply With QuoteRegister To Reply
  5. 12-25-2016, 07:00 PM #5
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    maybe your excplication is not good

    Cheers
    Leo
    Reply With QuoteRegister To Reply
  6. 12-25-2016, 07:20 PM #6
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Hi , LeoTaxi
    Thanks a lot for replies
    There is no explanation is good
    Of important to declare variables in the create a codes
    Thank you very much for the help

    Please Login or Register  to view this content.
    Last edited by salmasaied; 12-25-2016 at 08:45 PM.
    Reply With QuoteRegister To Reply
  7. 12-25-2016, 09:42 PM #7
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Please help in this thread
    Thank you very much for everyone to provide assistance
    Reply With QuoteRegister To Reply
  8. 12-26-2016, 03:40 AM #8
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Can I get any help, please?
    Reply With QuoteRegister To Reply
  9. 12-26-2016, 03:42 AM #9
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    maybe make cleare the result you are expecting.

    Cheers
    Leo
    Reply With QuoteRegister To Reply
  10. 12-27-2016, 01:46 AM #10
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Please help in this thread
    Thank you very much for everyone to provide assistance
    Reply With QuoteRegister To Reply
  11. 12-27-2016, 04:41 AM #11
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Please help in this thread
    Thank you very much for everyone to provide assistance
    Last edited by salmasaied; 12-30-2016 at 01:33 AM.
    Reply With QuoteRegister To Reply
  12. 12-27-2016, 07:07 AM #12
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    So far clear, but what must happen after data is transfered to sheets salma and saied ?

    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  13. 12-27-2016, 07:22 AM #13
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    no more dubble entrys
    same format as sheet Data


    Kind regards
    Leo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  14. 12-27-2016, 09:34 PM #14
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Hi , LeoTaxi
    Thanks a lot for replies
    I have tested the code sent from your side, but a negative impact on the two sheets PayMentSalary & data2
    Kind regards
    Last edited by salmasaied; 12-27-2016 at 09:39 PM.
    Reply With QuoteRegister To Reply
  15. 12-27-2016, 09:40 PM #15
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Please help in this thread
    Thank you very much for everyone to provide assistance
    Reply With QuoteRegister To Reply
  16. 12-27-2016, 09:49 PM #16
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Please help in this thread
    Thank you very much for everyone to provide assistance
    Last edited by salmasaied; 12-28-2016 at 02:13 AM.
    Reply With QuoteRegister To Reply
  17. 12-28-2016, 02:33 AM #17
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Can I get any help, please?
    Reply With QuoteRegister To Reply
  18. 12-28-2016, 05:09 AM #18
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    because i dont know what you want there, so nothing happen in those sheets
    Reply With QuoteRegister To Reply
  19. 12-28-2016, 12:20 PM #19
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Welcome, LeoTaxi
    Thanks a lot for replies
    these conditions do not apply to all names
    With respect to the attached file from you
    Please Clear the two sheets PayMentSalary & data2 And note the result
    Thank you very much for the help
    Kind regards
    Last edited by salmasaied; 12-30-2016 at 01:35 AM.
    Reply With QuoteRegister To Reply
  20. 12-28-2016, 08:28 PM #20
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    All sheets empty in this file, except Data
    see if this code give the good result in 4 sheets

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  21. 12-29-2016, 10:54 AM #21
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Welcome, LeoTaxi
    Thanks a lot for replies
    Although the three conditions the existence of in the data sheet does not give the code results in two sheets only
    Please focus on the the two sheets salma & saied taking account copy formatting from the source sheet
    Thank you very much for the help
    Kind regards
    Last edited by salmasaied; 12-29-2016 at 11:47 PM.
    Reply With QuoteRegister To Reply
  22. 12-29-2016, 11:03 AM #22
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Before i go further, you provid excel file with the desired result for all sheets
    Reply With QuoteRegister To Reply
  23. 12-29-2016, 11:15 AM #23
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Welcome, LeoTaxi
    Thanks a lot for replies
    There is no further than that the desired results are in accordance with the conditions set forth in the Thread
    Thank you very much for the help
    Kind regards
    Reply With QuoteRegister To Reply
  24. 12-30-2016, 02:14 AM #24
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Welcome, LeoTaxi
    There is still a problem in copying the formats of the two sheets
    Thank you very much for the help
    Kind regards
    Last edited by salmasaied; 12-31-2016 at 04:56 PM.
    Reply With QuoteRegister To Reply
  25. 12-30-2016, 05:15 AM #25
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Welcome, LeoTaxi
    Here are the results in the four sheets
    remained copied formats of the sheet source The two sheets salma & asied
    Is there a way the other is used to copy the formats of the two sheets
    Thank you very much for the help
    Kind regards
    Last edited by salmasaied; 01-01-2017 at 11:46 PM.
    Reply With QuoteRegister To Reply
  26. 12-30-2016, 05:32 AM #26
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Welcome, LeoTaxi
    Please do not use this line of code because it causes problems
    Do not copy formats only after deleting the column DN 
    Please Login or Register  to view this content.
    Thank you very much for the help
    Last edited by salmasaied; 12-31-2016 at 07:41 PM.
    Reply With QuoteRegister To Reply
  27. 12-31-2016, 01:12 AM #27
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    I hope to complete Thread
    Reply With QuoteRegister To Reply
  28. 12-31-2016, 07:15 PM #28
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    good greeting
    We are about to ending Thread
    Is it any help
    Thank you very much for the help
    Reply With QuoteRegister To Reply
  29. 01-01-2017, 06:11 AM #29
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    1 more try

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  30. 01-01-2017, 10:25 AM #30
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,147

    Re: transfer of specific data Based On Multiple Conditions from worksheet to Multiple shee

    Try

    in "Saied" F8

    =IFERROR(INDEX(PayMentSalary!$A$8:$CP$50,SMALL(IF(data!$AF$8:$AF$50="excelforum3",ROW(PayMentSalary!$A$8:$A$50)-ROW($A$8)+1,""),ROWS($A$8:A8)),MATCH(saied!F$6,PayMentSalary!$A$6:$CP$6,0)),"")

    Enter with Ctrl+Shift+Enter

    Copy across and down
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Transfer data Specific a row from multiple sheets to another sheet
    By salmasaied in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2016, 02:23 AM
  2. [SOLVED] Merge multiple sheets data into one worksheet based on multiple criteria
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-05-2016, 10:32 AM
  3. Conditional data transfer between worksheets based on multiple conditions or criteria
    By ExcelDummy2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2013, 12:40 PM
  4. [SOLVED] Transfer a specific cell from multiple sheets to a separate sheet
    By johnnylzep in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2012, 08:12 AM
  5. [SOLVED] Comparing data between two worksheet , based on multiple conditions
    By pyol17 in forum Excel General
    Replies: 34
    Last Post: 09-03-2012, 02:06 AM
  6. Transfer specific data from 1 worksheet to another using conditions
    By Chrisaaron in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-24-2010, 06:17 AM
  7. Transfer data from multiple cells to new worksheet based on cell value
    By Lostinxcel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2010, 05:57 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1