I built a 2 page report with quite a few cells that can be filled in. I also have a logbook with about 25 columns for data. Both worksheets are in different workbooks. On the sheet that has the report to fill out, I have a command button that uses code to open a new workbook and then copies the first sheet in the book and pastes into the new book and then saves the new book based on the data in a specific cell. After I save the report I have a command button that clears all of the cells and allows me to start a new report. What I am after is some code that after opening the logbook, would start a new row in the logbook, and then take the data out of H7 of the report and put it in cell 3 of the row it just created in the logbook. I also need it to hyperlink cell 2 to the report that I just saved. I will need it to copy and paste multiple cells of data. Here is a dummy version of both workbooks for an idea of where I am going.
Thanks in advance.
Bookmarks