Hi,
I would like some help. I have a daily record that requires 5 data entries per day. I record the date one, then the 5 entries of data. Then repeat daily.
the problem I have is, in column A the first date is in A3, then the next date is in A8, A13 and so on.
i want a second sheet, let’s call it sheet2, to show the dates without the 4 empty cells.
for example I want sheet2A3 to show sheet1A3, sheet2A4 to show sheet1A8.
I hope this makes sense and somebody can help me. Thanks in advance
I would like some help. I have a daily record that requires 5 data entries per day. I record the date one, then the 5 entries of data. Then repeat daily.
the problem I have is, in column A the first date is in A3, then the next date is in A8, A13 and so on.
i want a second sheet, let’s call it sheet2, to show the dates without the 4 empty cells.
for example I want sheet2A3 to show sheet1A3, sheet2A4 to show sheet1A8.
I hope this makes sense and somebody can help me. Thanks in advance