Copy & Paste Range of Cells Based On Combo Box Value

[medihx]

Hello

In the attached workbook i have a button "Read data from Unit 1" that pulls data from a DDE server into Cells B7:AC7 and B24:AC24 which works fine.

What i would like to be able to do is have a combo box with preset values in and a button next to this so once you have selected a value the data from B7:AC7 and B24:AC24 is placed in the row that corresponds to the value in the combo box.

Also once the rows have been filled after a day of collecting data i would like another button "Archive" to copy all the data to another sheet called Archive and clear the contents of the copied cells which also works fine at the moment. However i would like the Achive button to copy the data into the next empty rows on the Archive sheet so i can build up a database over several months and if possible place a date from system time in colum A of the Achive sheet next to the copied data.

I have tried many ways already but to no success as i am a newcomer to VBA and macros.

If there is an easier way of doing all of this when anyone looks at the workbook feel free to butcher as needed.