Posts by gsw721

    will Left(the cell.Text, 3) get what you're after ?

    i dont know... i have never seen that before and have no idea where to put it into the code line.

    Any idea where and how it would fit into - Set wsTO = workbooks("2021 FIB Log.xlsm").Worksheets("AUG")

    also, i was mistaken. the cell formats the date as 1-aug. so i guess there is a "right" command too?

    Im a novice at VBA. if there isnt a video how to use it, it takes me much longer to figure it out.

    Thanks for the help



    I am not a code writer! i was able to write a few macros due to google/youtube knowledge. Here is the long story short:

    In my office, we use an excel spreadsheet to keep track of dates, times, addresses, comments, etc. This is broken down into monthly tabs. The same information that goes on the main log has to also be entered onto a personal log and a back up log. Basically entering the same information three times.

    I wrote a few macros that allow the user to input the information. It then places the information in the appropriate cells. At the end it copies the row of cells, opens the main spreadsheet, and pasts the row in the last line.

    Here is the problem. Each month, I have to edit the macro to open the current months tab. Is there a way to have the macro select the correct tab based on the date that the user input?

    1. message box asks for the date of the transaction MM/DD (8/1)
    2. Excel places the date into the cell as Aug-1

    I need the macro to be able to open the main spreadsheet and then open the AUG tab so it can paste the content in that line.
    Clear as mud?

    If i need to send the files I can.

    thanks for the help