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