+ Reply to Thread
Results 1 to 30 of 30

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

  1. #1
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,131

    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

  3. #3
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  4. #4
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  5. #5
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,131

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

    maybe your excplication is not good

    Cheers
    Leo

  6. #6
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  7. #7
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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

  8. #8
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

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

    Can I get any help, please?

  9. #9
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,131

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

    maybe make cleare the result you are expecting.

    Cheers
    Leo

  10. #10
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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

  11. #11
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  12. #12
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,131

    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

  13. #13
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,131

    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

  14. #14
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  15. #15
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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

  16. #16
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  17. #17
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

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

    Can I get any help, please?

  18. #18
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,131

    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

  19. #19
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  20. #20
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,131

    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

  21. #21
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  22. #22
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,131

    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

  23. #23
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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

  24. #24
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  25. #25
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  26. #26
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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.

  27. #27
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

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

    I hope to complete Thread

  28. #28
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    233

    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

  29. #29
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,131

    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

  30. #30
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    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 to 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. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1