Kenja824
Automotive
- Nov 5, 2014
- 950
I am wanting to create a new Time-sheet for guys at work here to keep track of their hours through the year, but I would like to do something I don't have the foggiest idea how to do in VBA. I was hoping someone could please help me.
I would like to have a macro to attach to the blue button. When clicked, it would copy the four cells in yellow. Look at the date in A1, then paste the info to the four cells next to the same date in the column A of Sheet2.
If there is already something in those cells, I would like it to give a warning and have the user select OK to proceed or cancel.
On the other code, I would like to attach the macro to the yellow button that would do a near opposite. It would look at the date in J1 and find the same date in Sheet2, then copy the four cells next to it and past them in the four cells to the right of the yellow button. K1-N1.
No warnings needed for that one.
Just to be clear, this is just something I am doing on the side and not important or in a hurry. So please dont go out of your way much. Just if you get bored sometime and feel like you want something to do.![[rednose] [rednose] [rednose]](/data/assets/smilies/rednose.gif)
I would like to have a macro to attach to the blue button. When clicked, it would copy the four cells in yellow. Look at the date in A1, then paste the info to the four cells next to the same date in the column A of Sheet2.
If there is already something in those cells, I would like it to give a warning and have the user select OK to proceed or cancel.
On the other code, I would like to attach the macro to the yellow button that would do a near opposite. It would look at the date in J1 and find the same date in Sheet2, then copy the four cells next to it and past them in the four cells to the right of the yellow button. K1-N1.
No warnings needed for that one.
Just to be clear, this is just something I am doing on the side and not important or in a hurry. So please dont go out of your way much. Just if you get bored sometime and feel like you want something to do.
![[rednose] [rednose] [rednose]](/data/assets/smilies/rednose.gif)