Hello everyone,
I recently stumbled across a problem when creating a data system in excel for my engineering internship. I need to be able to take the data points and date that the data was entered from an operator spreadsheet (I work in a sulfuric acid plant) and then by creating some magical button/macro, transfer said data and date into another spreadsheet that has a row for all dates with data underneath, and historically plots the data into various scatter plots in a series fashion with one data set after the other from left to right. If at all possible, I also am trying to figure out a way to refresh the worksheet after the data is entered.
The problem that I'm having isn't that I don't know how to use a macro to copy/paste the data, but moreso create a button that puts the data in an updating series that historically is in order and keeps generating new data points when prompted by the operator sheet, and also keeps on placing data sets down the series (monthly operator sheet) and not in the same location as previous data sets.
Oh, and the only spreadsheet that is functional is the operator spreadsheet, because operators apparently cannot copy and paste, said my superintendent
I will be putting up the document as soon as possible, but for now if someone has an idea how to do this, and since I am not exceptional at excel any help would be appreciated. I hope that this will be an easy question to answer!
Bookmarks