Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Moving rows with Date field from one worksheet to another  (Read 1885 times)

0 Members and 1 Guest are viewing this topic.

Nelsondavid

    Topic Starter


    Rookie

    • Experience: Familiar
    • OS: Windows 7
    Moving rows with Date field from one worksheet to another
    « on: December 01, 2016, 09:10:14 AM »
    Hello,

    Have a Excel file with multiple sheets , each sheet is identified by the persons ID number
    See attached file.Here i need to copy data from FILE1 in each sheet to FILE2

    As you see in file1 that data for each person is scar tared , that is date are up and down ...that data need to be moved to file2 where already date from 21 oct to 20 nov is marked.


    THANKS

    [attachment deleted by admin to conserve space]

    soybean



      Genius
    • The first soybean ever to learn the computer.
    • Thanked: 469
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: Moving rows with Date field from one worksheet to another
    « Reply #1 on: December 01, 2016, 09:53:09 AM »
    Quote
    i need to copy data from FILE1 in each sheet to FILE2
    I'm wondering about the wording of the quoted part of your post.  I suspect it would be better worded like this: i need to copy data from each sheet in FILE1 in to corresponding sheets in FILE2.   Is that correct?  Are FILE1 and FILE2 names of separate Excel files?

    Nelsondavid

      Topic Starter


      Rookie

      • Experience: Familiar
      • OS: Windows 7
      Re: Moving rows with Date field from one worksheet to another
      « Reply #2 on: December 01, 2016, 10:05:13 AM »
      yes i need to copy data from each sheet in FILE1 in to corresponding sheets in FILE2.

      The thing to take care here is in file1 data is scattered , that data need to be put in order as per the date in file2 . Yes file1 and file2 are separate files 

      soybean



        Genius
      • The first soybean ever to learn the computer.
      • Thanked: 469
      • Computer: Specs
      • Experience: Experienced
      • OS: Windows 10
      Re: Moving rows with Date field from one worksheet to another
      « Reply #3 on: December 01, 2016, 10:10:14 AM »
      Can you elaborate on how the data in File1 is scattered?  Do you mean unsorted?  Is that what you're trying to convey by highlighting in green some dates in File2?

      Nelsondavid

        Topic Starter


        Rookie

        • Experience: Familiar
        • OS: Windows 7
        Re: Moving rows with Date field from one worksheet to another
        « Reply #4 on: December 01, 2016, 10:15:44 AM »
        thats right it is not sorted

        Nelsondavid

          Topic Starter


          Rookie

          • Experience: Familiar
          • OS: Windows 7
          Re: Moving rows with Date field from one worksheet to another
          « Reply #5 on: December 01, 2016, 10:18:45 AM »
          In file2 what you see is 21 oct to nov 20 one month , marked green are sundays

          soybean



            Genius
          • The first soybean ever to learn the computer.
          • Thanked: 469
          • Computer: Specs
          • Experience: Experienced
          • OS: Windows 10
          Re: Moving rows with Date field from one worksheet to another
          « Reply #6 on: December 01, 2016, 10:18:54 AM »

          Nelsondavid

            Topic Starter


            Rookie

            • Experience: Familiar
            • OS: Windows 7
            Re: Moving rows with Date field from one worksheet to another
            « Reply #7 on: December 01, 2016, 10:23:50 AM »
            it is not plain sorting only with reference to date , the row with a particular date in each sheet should move to the same date in file2

            Nelsondavid

              Topic Starter


              Rookie

              • Experience: Familiar
              • OS: Windows 7
              Re: Moving rows with Date field from one worksheet to another
              « Reply #8 on: December 01, 2016, 10:28:12 AM »
              here what am looking for is a sort of macro which can be used to move the data from file1 to file2 .

              just for example have shown 3 sheets in both files , in actual we need to deal with 600 to 700 sheets in each file

              soybean



                Genius
              • The first soybean ever to learn the computer.
              • Thanked: 469
              • Computer: Specs
              • Experience: Experienced
              • OS: Windows 10
              Re: Moving rows with Date field from one worksheet to another
              « Reply #9 on: December 01, 2016, 10:32:53 AM »
              What is the purpose copying the data from one Excel file to another?  Is this just for sorting, in File2, the same data that is in File!? 

              Nelsondavid

                Topic Starter


                Rookie

                • Experience: Familiar
                • OS: Windows 7
                Re: Moving rows with Date field from one worksheet to another
                « Reply #10 on: December 01, 2016, 10:41:26 AM »
                File1 is timesheets of each employee , there may be days when the employee is absent and no entry of that day available in file1.when we move data from file 1 to file 2 , the days employee is absent , only date should be there in that row

                soybean



                  Genius
                • The first soybean ever to learn the computer.
                • Thanked: 469
                • Computer: Specs
                • Experience: Experienced
                • OS: Windows 10
                Re: Moving rows with Date field from one worksheet to another
                « Reply #11 on: December 01, 2016, 10:56:11 AM »
                Well, you have a complicated situation regarding all that data and I don't think I can take the time to delve into it further with you.  Engaging a discussion in a forum devoted to Excel might be a good way to proceed.  You could try http://www.excelforum.com/ or search on excel forum for others.

                Nelsondavid

                  Topic Starter


                  Rookie

                  • Experience: Familiar
                  • OS: Windows 7
                  Re: Moving rows with Date field from one worksheet to another
                  « Reply #12 on: December 01, 2016, 08:16:49 PM »
                  Link to see demo files , file1 and file 2 link

                  In file2 i manually entered the data , in the same way i need data from file1 to be copied to file2 in all sheets

                  https://www.dropbox.com/s/7jq9gxuxuimtlgu/FILE1.docx?dl=0

                  https://www.dropbox.com/s/hc1stm1llbsahh9/FILE%201.xlsx?dl=0

                  Nelsondavid

                    Topic Starter


                    Rookie

                    • Experience: Familiar
                    • OS: Windows 7
                    Re: Moving rows with Date field from one worksheet to another
                    « Reply #13 on: December 01, 2016, 09:53:29 PM »
                    Link to see demo files , file1 and file 2 link

                    In file2 i manually entered the data , in the same way i need data from file1 to be copied to file2 in all sheets

                    https://www.dropbox.com/s/7jq9gxuxuimtlgu/FILE1.docx?dl=0

                    https://www.dropbox.com/s/ymf8041y66zn36e/FILE2.xlsx?dl=0

                    patio

                    • Moderator


                    • Genius
                    • Maud' Dib
                    • Thanked: 1686
                      • Yes
                    • Experience: Beginner
                    • OS: Windows 7
                    Re: Moving rows with Date field from one worksheet to another
                    « Reply #14 on: December 02, 2016, 02:53:04 AM »
                    Any reason you're quoting your own Post ? ?
                       
                     
                    " Anyone who goes to a psychiatrist should have his head examined. "