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:
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:
Once you have tested the macro ... feel free to share your comments
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
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
Is this your very first message ...???
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
You are welcome
Still not what I need
QuoteStill not what I need
Try explaining more fully what you want.
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
What is not working with Carim's code, it should do what you want.
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