Hello,
I wasn't quite sure what to title this to be honest. Here's the situation:
We have an electronic balance where when you hit the "print" button, it prints out data into Excel. It prints the date and time in one cell of a column, it prints the weight of the object in the adjacent cell, and it prints the unit of measurement in the third column. To be honest, I have no idea how this works, but maybe someone here does (or at least has a general idea).
The problem that I want to solve is that you have to click specifically on the cell you want Excel to start adding data. For instance, if you click on a cell in the "weight 1" column, it will first add the date and time to that cell in the "weight 1" column, then it will add the weight to the "unit" column, and then it will add the "unit" to the next "date and time" column, which of course is not where that data belongs. What I want is for excel to start adding data to the first empty cell, once the "print" button is pressed on the balance, no matter which cell is selected in the worksheet. When it has gotten to the final column, which is labeled "observations", I want it to be able to start over from the next row. There are 6 weight measurements per row, and associated with each of those measurements is the date and time and the unit. The main purpose of doing this is to prevent write over mistakes from occuring or putting data where it doesn't belong. Also, all the columns to the left of the first "date and time" column will be filled in already. I put in an example of how the output looks when you hit print on the balance.
I am uploading a blank copy of this worksheet so you can see what I mean. If anyone can help, it is greatly appreciated. I'm not even sure this is possible, but I thought I'd ask. Please ask if you need clarification on what I am looking for. Thank you!
Bookmarks