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

Expert Asked on October 3, 2016 in VBA.
Add Comment
2 Answer(s)

Hi KOP,

Its possible. Please provide more information.

Regards-PNRao

 

Keymaster Answered 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.
Add Comment

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

Expert Answered on October 9, 2016.
Add Comment
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.