Attached are two sheets, query and query log.
As a company we receive lots of queries containing information like on the (query) sheet attached. The same fields will be completed every time a query is received. Currently I would have to copy the row containing the query info (not the column headings) received and then copy and paste the row into the next available row in our query log sheet. In this example I would copy row 2 from the query sheet into the next available row in the query log sheet (row 10). It is important that the information copied from the query sheet matches the fields in the query log sheet. e.g. member name info would be copied into column E on the query log sheet. I would then have to populate the date (the date the query is copied into the query log) into column b.
Can any produce some code which will allow me to open a newly received query sheet, then click a button, this will then automatically copy and paste the appropriate info from the query into the next available row in the query log sheet and will automatically populate column B with the date.