Move to cell after three entries

Hello,

I am working on a one tiny project where data will be automatically inputted by a device. Would it be possible to offset cell after date is inputted to E5 to move to F3 then after F5 to G3 and so on.

Excel file:

https://www.dropbox.com/scl/fi…yezaxpecgc01w7b3j0g7dtila

Quote from Carim

Hello and Welcome to the Forum

You could test following

Code

1. Private Sub Worksheet_Change(ByVal Target As Range)
2. If Target.CountLarge > 1 Then Exit Sub
3. If Target.Row < 3 Or Target.Row > 5 Then Exit Sub
4. If Target.Row = 5 Then Target.Offset(-2, 1).Select
5. End Sub

Hope this will help

But this only works for rows 3 - 5. I need for multiple like 6-8 9-11 12-14 and so on. There is multiple options

Quote from Carim

Is this your very first message ...???

Yes. What I meant it will go to the right and also down I even attached the excel file

Still not what I need

Quote from royUK

Try explaining more fully what you want.

When data has been inputted by device from E3 to E5 to move to F3 and so on but this should also work when date is being placed at E6 to E8 and moves to F5. It would go down to line 38. Sorry for long delay, I have been busy at work and couldn't respond

Quote from royUK

What is not working with Carim's code, it should do what you want.

With his code it only works between cells 3 and 5. I would need between 6 and 9, 10 and 12 and so on till 38