Hi. I wanted to make an own thread for this because its not as simple as the title says.
I have sort of a "diary" that has 2 worksheets. On the first worksheet you enter the values of happenings
to certain cells. Second worksheet is designed to store these values for each day. The values that needed to be copied are
date, time, event and note. I already have a macro for date in the workbook that can be used for copying. Time, event and
note is written by the user. User selects a certain event by clicking a box.
I would like to have a macro that
works when I press a button. The macro would copy the date, time, event and note to the second worksheet. Note that the event
is selected with "click the box" way.
At the moment there are 2 events the user can select.
"Guest" and "Alarm". Now, if the user selects only "Guest" how do I make excel know that I only
want that box to be copied and not the other? And how does excel know what the selected boxes value is? The value is written
next to the box, but does excel know to copy that only when the box is marked?
cells I'd want excel to copy are: EFG-567 + E15 OR E16 (event) + H14-15 + I14-15 + JKLMN-14-21.
First one is for
date, second is for event, third one is for time and the last is for note. All are just simple "copy", except the
event, because I dont know how it works with the boxes.
Now, I would like excel to copy the values from those
cells to the second worksheet's cells: date to cell's AB3, time to cell's CD3, event to cell's EF3 and note to cell's
That would be the data for the first day.. next day would be the same except it would be row 4. Now, each
time a copy is made, it should NEVER be copied to a cell that already has data.
How do I make all this happen?
Thanks in advance.