Hello,

I have been trying to figure this out for a while now with no luck. I have a spreadsheet set up with different screenshots of a PLC HMI screen, each screen shot has multiple textboxes and command buttons where you can fill in the corresponding information you see on the PLC HMI screen. This needs to be filled in every week (not necessarily on the same day each week). I have the textboxes and command buttons linked to a column of cells so when you fill everything in and click the buttons, the values all auto populate a single column.

Since this needs to be done on a regular basis and I want to keep all previous reading in the spreadsheet for comparison/analysis, I want this column of data to populate a new column on a separate sheet every time the value in the "date" cell changes. The result would be a new column of data every time the screenshots are filled in again. Sorry if this sounds confusing.

An example for clarity:
Say I have a "date" cell and textboxes 1, 2 and 3 that populates the first 4 rows of column A on sheet 1. The first week I fill this in, column A on sheet 2 will contain these 4 values. The next week I fill it out again, column A on sheet 1 changes and these new values are sent to column B on sheet 2, and column A on sheet 2 retains last week's data. Each week column A on sheet 1 will change, and the current week's data will be sent to the next empty column on sheet 2. Is this possible with vba?

Also if possible, I would like to have the data from sheet 1 transfer to the next empty column in sheet 2, then the data deleted from sheet 1. This way each time you go to fill in the data, all boxes are blank making it easier to know which ones still need to be filled in (will be 100+ cells and text boxes to fill in each week, easy to miss some if you are changing existing values rather than simply filling in the empty textboxes/cells).

Hope someone can help me out with this, very familiar with excel and its formulas/functions but still new to vba.

Thanks,
Andrew