+ Reply to Thread
Results 1 to 2 of 2

select all the rows based on my criteria and should be copied to other workbook ..

  1. 11-07-2012, 02:43 AM #1
    venkatkumar07
    venkatkumar07 is offline
    Registered User
    Join Date
    11-07-2012
    Location
    kuala lumpur
    MS-Off Ver
    Excel 2003
    Posts
    1

    select all the rows based on my criteria and should be copied to other workbook ..

    Hi everyone,

    Iam new bie to excel i got a requirement to select all the rows based on the country wise and paste it in new excel sheet. In that i have to select Netherland and just copy the full row that belongs to Netherland and paste it in new workbook. This should apply for all the sheets in the requirement workbook.


    workbook 1 -----

    sheet1
    Netherlands 30 Confirmation Falck NL 3556960 3757515 Old Link New Link
    Netherlands 30 Confirmation Falck NL 3597109 3757569 Old Link New Link
    Norway 2809 STCW kursbevis MED kursnavn 3635189 3850439 Old Link New Link
    Brazil 2887 Carta de Confirmaτπo 3703829 3965785 Old Link New Link

    sheet2
    Netherlands 3612 FN - NL Stempel 1-ledig 3574382 3767117 Old Link New Link
    Netherlands 3612 FN - NL Stempel 1-ledig 3574386 3767118 Old Link New Link
    Denmark 4377 Generel sertifikat 3561433 3783894 Old Link New Link

    sheet3
    Netherlands 6371 FBHV Card met Certificaattekst (Geldig tot) 3690481 3936981 Old Link New
    United States 6871 Default Joining Instructions 3630690 3817968 Old Link New Link

    Target workbook 2--

    sheet1
    Netherlands 30 Confirmation Falck NL 3556960 3757515 Old Link New Link
    Netherlands 30 Confirmation Falck NL 3597109 3757569 Old Link New Link


    sheet2
    Netherlands 3612 FN - NL Stempel 1-ledig 3574382 3767117 Old Link New Link
    Netherlands 3612 FN - NL Stempel 1-ledig 3574386 3767118 Old Link New Link


    sheet3
    Netherlands 6371 FBHV Card met Certificaattekst (Geldig tot) 3690481 3936981 Old Link New
    Reply With QuoteRegister To Reply
  2. 11-07-2012, 09:52 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: select all the rows based on my criteria and should be copied to other workbook ..

    When you are in Advanced reply, click on the paperclip to open the upload window.

    View PicTo Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    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)

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