• Ask a Question
150
Insert Image Size must be less than < 5MB.
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel
      Expert

      VBA How to get a user to copy their selected range selected by date and transfer to another workseet

      I have a sheet that information will come in everyday, a person has to verify the work that came in. I want them to select the range of data that they have verified  and copy it and transfer the information to another worksheet.   Is this possible?   KOP

      Asked by KOPower on October 3, 2016 in VBA.
      2 Answers
      Keymaster

      Hi KOP,

      Its possible. Please provide more information.

      Regards-PNRao

       

      Answered by PNRao on October 3, 2016..
      • Sorry for the late response, I have a spreadsheet with 11 columns – Column A to Column L. Column A has a date, I would like to have a button that a person presses the button a message will pop up asking to select a date or date range from Column A and then it would copy all data that is the rows relating to that date or date range in column A to column L and copy this into another worksheet.

        Transaction Date Call # Program Indentifier PSO Comments In order Obs Error BEA Comments – Description of Benefit Type – Error Monitoring date BEA
        September 29 2016 3 GCOS 999999 iiiiiii x October 21 2016 Kris Jones
        September 29 2016 4 GCOS 8888 llll x October 27 2016 Kris Jones
        September 29 2016 5 GCOS 77777 kkkkk x October 27 2016 Kris Jones
        September 29 2016 2 GCOS 1111999000 hhhhh x October 3 2016 Kris Jones
        September 29 2016 3 GCOS 999999 iiiiiii x October 21 2016 Kris Jones
        September 30 2016 4 GCOS 8888 llll x October 27 2016 Kris Jones
        September 30 2016 5 GCOS 77777 kkkkk x October 27 2016 Kris Jones
        A message puts up asking to select date so in this example let’s say September 29, 2016, then it would select all the data from each row from column A to Column L relating to September 29, 2016, copy it and input it in another worksheet. If the date input was September 29th and September 30th then everything that is related to these dates would be copied into another worksheet under the last blank row.

        Hoping that this is possible thank you again for all your help.

        Kris

        on October 9, 2016.
      Cancel
      Add comment
      Expert

      Sorry for the late response, I have a spreadsheet with 11 columns – Column A to Column L. Column A has a date, I would like to have a button that a person presses the button  a message will pop up asking  to select a date or date range from Column A and then it would copy all data that is the rows relating to that date or date range in column A to column L and copy this into another worksheet.

       

      Transaction Date Call # Program Indentifier PSO Comments In order Obs Error BEA Comments – Description of Benefit Type – Error Monitoring date BEA
      September 29 2016 3 GCOS 999999 iiiiiii x October 21 2016 Kris Jones
      September 29 2016 4 GCOS 8888 llll x October 27 2016 Kris Jones
      September 29 2016 5 GCOS 77777 kkkkk x October 27 2016 Kris Jones
      September 29 2016 2 GCOS 1111999000 hhhhh x October 3 2016 Kris Jones
      September 29 2016 3 GCOS 999999 iiiiiii x October 21 2016 Kris Jones
      September 30 2016 4 GCOS 8888 llll x October 27 2016 Kris Jones
      September 30 2016 5 GCOS 77777 kkkkk x October 27 2016 Kris Jones

      A message puts up asking to select date so in this example let’s say September 29, 2016, then it would select all the data from each row from column A to Column L relating to September 29, 2016, copy it and input it in another worksheet. If the date input was September 29th and September 30th then everything that is related to these dates would be copied into another worksheet under the last blank row.

      Hoping that this is possible thank you again for all your help.

      Kris

      Answered by KOPower on October 9, 2016..