I'm making some, slow, progress with a project in Excel,(2000), that needs some use of VBA...
Briefly, the workbook has 2 worksheets. The first sheet is essentially a "timesheet". For each date that appears on this there is a checkbox. The second sheet is an expenses claim form.
If the checkbox for any given day is ticked the idea is that the values contained in 3 cells of data from that day, (date, start time, finish time), are transferred to the claim form.
Because of the possibility that any number of these checkboxes may be ticked I need to incorporate into the VBA coding some sort of "next line" instruction....
For example lets assume that no data has yet been transferred, the first transfer of data will go to cells A1,B1,C1 on the 2nd sheet. The next transfer of data will, therefore, go to A2,B2,C2. Because there is no way of knowing which date will result in a second transfer of data I can't tie particular cells from the first sheet to the second.
Can anyone help with the syntax I need for this specific task? I've run out of obvious permutations! Once I have this sorted I can move onto the next part of it!!
(The example is much simplified, compared to the real thing, for the sake of clarity, though I can expand on this if necessary.)
Thanks in anticipation,