Hello!
I'm very new to VBA and been trying to implement a macro/code for some time now and haven't found a tutorial or sketch to work with.
I'm working on a file that takes in data from an Arduino continuously while connected. The file have many columns that does it's own calculations down 50 rows and eventually makes it to "J2" with one number in the one cell. I want to copy J2 content down a row every time that number changes.
How would I go about doing that? So basically I want what "Data Streamer" has; however I can't use Data Streamer due to my Arduino set up being wireless and the sensor I'm using.
Also, would I be able to implement this macro/code to all worksheets in the workbook? Even if a new worksheet is created (without having to add this code to that worksheet again).
It'll be super helpful with any sketch you can provide that is very similar to my goal.
Thank you so much.
I'm very new to VBA and been trying to implement a macro/code for some time now and haven't found a tutorial or sketch to work with.
I'm working on a file that takes in data from an Arduino continuously while connected. The file have many columns that does it's own calculations down 50 rows and eventually makes it to "J2" with one number in the one cell. I want to copy J2 content down a row every time that number changes.
How would I go about doing that? So basically I want what "Data Streamer" has; however I can't use Data Streamer due to my Arduino set up being wireless and the sensor I'm using.
Also, would I be able to implement this macro/code to all worksheets in the workbook? Even if a new worksheet is created (without having to add this code to that worksheet again).
It'll be super helpful with any sketch you can provide that is very similar to my goal.
Thank you so much.