KOPower's Profile
Expert
1605
Points

Questions
4

Answers
5

  • Expert Asked on October 9, 2016 in VBA.

    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

    • 264 views
    • 2 answers
    • 0 votes
  • Expert Asked on August 11, 2015 in VBA: Programming.

    Thank you so much it works great. I really appreciate all your help.

    • 538 views
    • 4 answers
    • 0 votes
  • OK I got it to work but it is not exactly what I had in mind and this is my fault for poor explanation.  So it should look like this:

    WB2 = “Trainingcoursecompleted.xls”

    Column A = Names of people starting at row 4 and all names are in Column A
    Row 3 = Courses B1 = GIS, C1 =OAS, D1 = XYZ, etc

    so say in column A Row 4 the person name is Jane Doe

    WB1 = “Training.xls”

    Person’s name is in C3
    Training Course is in D3
    Training course completed I input a “Y” in AD26

    Once a “Y” gets inputted or pressing the button designated as “send to Training Completed spreadsheet.

    The WB2 workbook would automatically open and put a Y beside the person’s name but under the appropriate Course name.

    So it would find the name Jane Doe in Column 1 and the course Name  as example “OAS”and put a “Y” under the course name as an example Jane Doe’s name (in this example a “Y” would go in Row 4 column D.

    And if the person’s name is not found automatically insert the person name at the end of column A and place a Y under the appropriate Course completed.

    The code that you created is very close and I hope that what I envision is possible and again thank you so much for all your help. I am still amazed at what you created and hope that the additional request can be done.

    • 493 views
    • 7 answers
    • 0 votes
  • Is it also possible for me to download what you have created. I have tried your first code that you have created and I cannot get it to work and I know it is something that I am doing wrong.

    • 493 views
    • 7 answers
    • 0 votes
  • This is great and thank you very much. I was  just looking over your code and am wondering if there is a way to modify the code  to look for the course name in row 1 for example  course GIS is D1, course OAS is E1, course XYZ is F1 (this would be in the training completed.xls workbook)? The persons name  would be in one column like you have in your example. So if in Training.xls spreadsheet, they completed course GIS (it would activate the code by pressing on a button ), the code would open “trainingcoursecompleted” search for the person’s name and the course name (GIS) and input a Y in the correct spot. Also if we have a new person that just joined the company and his name was not found in the “trainingcoursecompleted.xls” is it possible to have his name automatically  inserted after the last name that is in spreadsheet (trainingcoursecompleted.xls spreadsheet). I am hoping this possible and thank you again for all your help. I am currently trying to learn how to do VBA coding and I am just amazed at the possibilities. Even more amazed at your knowledge

    • 493 views
    • 7 answers
    • 0 votes